)
Written by
Table of Contents
“Supermetrics is a Bitter Experience! We can pull data from nearly any tool, schedule updates, manipulate data in Sheets, and push data back into our systems.”
When a Google Sheets marketplace app is installed organization-wide in HubSpot, it creates significant security exposure by making ALL Google Sheets visible to ANY user with workflow creation permissions.
Here’s what this means for your data security and how to implement a secure alternative that eliminates these organization-wide visibility issues.
Replace organization-wide installations with individual connection management using Coefficient
Organization-wide marketplace app installations create several problematic outcomes: personal or confidential sheets become visible to all workflow builders, no differentiation between public and private sheet access, department-specific sheets are exposed to users from other departments, and no audit trail exists for who can see which sheets.
Coefficientprovides a secure alternative that addresses these organization-wide visibility issues through individual connection management and granular access control.
How to make it work
Step 1. Set up individual connection management.
Users establish their own Coefficient connections rather than relying on organization-wide marketplace app installations. Each user maintains control over their sheet visibility through personal connections in “Connected Sources.”
Step 2. Configure granular access control.
Each Coefficient connection can be configured for specific sheets and ranges, eliminating the broad exposure created by marketplace app permissions. Users only connect to sheets they’re authorized to access.
Step 3. Implement department-level separation.
Different departments maintain separate Coefficient connections to their relevant sheets without cross-departmental visibility issues. Sales connects to sales sheets, marketing to marketing sheets, with no overlap.
Step 4. Create scalable security model.
As your organization grows, new users can establish their own secure connections without affecting existing setups or exposing additional sheets. Each new user starts with zero sheet access until they create their own connections.
Step 5. Replace organization-wide apps with user-controlled connections.
Eliminate the organization-wide marketplace app and replace it with user-controlled Coefficient connections that provide the same functionality with better workflow access control and integration security settings.
Step 6. Monitor connection activity.
HubSpotUse Coefficient’s connection management to track which users have active connections to which sheets, providing the audit trail that organization-widemarketplace apps cannot offer.
Eliminate organization-wide security vulnerabilities
Start buildingThis approach eliminates the security vulnerabilities of organization-wide marketplace app installations while maintaining the collaborative capabilities needed for effective workflow automation.secure, user-controlled connections today.
