)
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.”
Setting up Excel synchronization with NetSuite requires specific permissions and role configurations that many users find confusing. The permission requirements overlap whether you’re doing one-way imports or planning bidirectional sync.
Here’s exactly what permissions you need and how to configure them properly for NetSuite Excel integration.
Essential NetSuite permissions for Excel data access using Coefficient
While true bidirectional sync requires additional write permissions, Coefficient demonstrates the core permission framework needed for NetSuite Excel integration. These same permissions form the foundation for any synchronization solution.
How to make it work
Step 1. Configure OAuth 2.0 authentication settings.
Your NetSuite Admin must set up OAuth credentials in the NetSuite interface. This includes creating integration records, generating consumer keys, and configuring callback URLs. Domain email addresses are required – Gmail accounts won’t work for this setup.
Step 2. Enable REST Web Services and SuiteScript.
Navigate to Setup > Company > Enable Features and activate both REST Web Services and SuiteScript. These features allow external applications to communicate with your NetSuite data through API calls.
Step 3. Deploy RESTlet scripts with proper execution permissions.
Upload and deploy the required RESTlet scripts that handle data communication. These scripts need execution permissions and must be accessible to the roles that will use the integration.
Step 4. Create custom roles with SuiteAnalytics Workbook permissions.
Set up roles that include SuiteAnalytics Workbook access, which is essential for data imports. Add permissions for specific record types you want to access – Customers, Items, Transactions, Accounts, and any custom records.
Step 5. Configure record-level and field-level access rights.
Grant access to the specific NetSuite records and fields your Excel integration needs. This includes custom fields, subsidiary permissions, and department access where applicable. For bidirectional sync, you’d also need create/edit permissions for target records.
Step 6. Set up saved search access permissions.
If you plan to import existing NetSuite saved searches, ensure the integration role has access to view and execute these searches. This permission is separate from basic record access.
Start connecting your NetSuite data to Excel
Getting NetSuite permissions right is the foundation for any Excel integration project. These permission requirements give you the access needed for comprehensive data analysis and reporting. Try Coefficient to see how proper NetSuite permissions enable powerful Excel workflows.
