)
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.”
QuickBooks requires Admin or Master Admin permissions to establish live data connections with Google Sheets add-ons. Understanding these permission requirements is crucial for successful integration setup and team access management.
Here’s what permissions you need and how to share access with team members without compromising security.
Understanding QuickBooks permission requirements for Coefficient
Coefficient requires specific QuickBooks permissions to create live data connections for automatic sync with Google Sheets. These requirements ensure secure access to sensitive financial data while enabling broad team collaboration.
How to make it work
Step 1. Verify admin access requirements.
Ensure you have Admin or Master Admin permissions in QuickBooks Online before attempting to connect. Standard User or Limited User permissions are insufficient for establishing the live data connection due to QuickBooks API limitations.
Step 2. Handle connection limitations.
Remember that QuickBooks API allows only one admin connection at a time per company file. If someone else in your organization has already connected QuickBooks to another application using admin credentials, you may need to coordinate or disconnect other integrations.
Step 3. Set up secure connection sharing.
Once an admin establishes the Coefficient connection, they can share access with team members without sharing actual QuickBooks credentials. Team members can access QuickBooks data imports and refresh capabilities without needing admin permissions themselves.
Step 4. Configure Google Sheets permissions.
Ensure team members have standard Google Sheets editing permissions to install the Coefficient add-on and create QuickBooks data imports. No special Google Workspace admin permissions are required for the spreadsheet side of the integration.
Step 5. Manage data access scope and security.
The QuickBooks connection provides access to all data that the connecting admin user can see in QuickBooks Online. Coefficient maintains secure authentication through QuickBooks’ OAuth system, and the connection can be revoked at any time through QuickBooks’ app management interface.
Enable secure team access to QuickBooks data
Proper permission setup ensures secure access to sensitive financial data while enabling broad team access to automated QuickBooks reporting capabilities. Get started with your secure QuickBooks connection today.
