)
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.”
You can revoke individual Salesforce connector access while preserving Google Sheets collaboration by using layered permission systems that separate data access from sheet sharing controls.
Here’s how to remove Salesforce access for specific users without disrupting their ability to collaborate on the spreadsheet itself.
Use independent permission layers for selective access revocation using Coefficient
Native connectors often tie data access directly to Google Sheets permissions, making selective revocation difficult. Coefficient provides granular revocation capabilities through its layered permission system that operates independently of Google Sheets sharing.
How to make it work
Step 1. Revoke Coefficient workspace access while maintaining sheet permissions.
Remove the user from your Coefficient workspace or modify their role to restrict data access. They retain full ability to view, edit formulas, and collaborate on non-data elements in the Google Sheet.
Step 2. Implement selective access removal for specific data sets.
Remove access to specific Salesforce imports while maintaining others, or downgrade permissions from “refresh” to “view only” without complete removal. This allows graduated access control based on changing needs.
Step 3. Understand post-revocation behavior and user experience.
After revocation, users see the last-refreshed data but cannot refresh or modify imports. Scheduled refreshes continue for other authorized users, and Google Sheets collaboration features remain fully functional with clear messaging about data update status.
Step 4. Maintain administrative oversight and documentation.
Use Coefficient’s audit trail to track revocation actions and timing. Maintain the ability to restore access quickly if needed. Document revocation reasons for compliance and future reference without disrupting team workflows.
Control data access without disrupting collaboration
This approach ensures secure data access management while preserving collaborative workflows and sheet functionality. You can make immediate permission changes without affecting other team members’ access. Implement flexible access control for your team today.
