)
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.”
Yes, multiple users can share the same Salesforce connector authentication in Google Sheets through team workspace functionality that eliminates the need for individual user authentication.
Here’s how to set up shared authentication that lets your entire team access Salesforce data through a single connection.
Enable shared authentication with team workspaces using Coefficient
Native Google Sheets connectors don’t support effective shared authentication across multiple users. Coefficient excels in this area by allowing one administrator to authenticate once and share access with unlimited team members.
How to make it work
Step 1. Set up the primary authentication.
One team member (typically an admin) connects their Salesforce account to Coefficient. This person becomes the authentication source for all shared data access, but their credentials remain completely private.
Step 2. Create shared imports accessible to all team members.
Build imports for the Salesforce reports and objects your team needs. All team members can access these same imports without needing individual Salesforce logins or API access.
Step 3. Enable collaborative refresh capabilities.
Any authorized team member can trigger data refreshes, but all refresh activities use the original authenticator’s credentials. This means seamless data updates without authentication barriers.
Step 4. Maintain centralized control with distributed access.
The original authenticator controls which data is accessible and can update permissions centrally. Team members inherit access based on workspace permissions, not individual Salesforce user rights.
Scale your team without scaling authentication complexity
This approach eliminates individual authentication requirements while maintaining security through centralized control. Your team gets collaborative access to current Salesforce data without the complexity of multiple connector setups. Get started with shared authentication today.
