The complete Token-Based Authentication walkthrough (Setup > Integration > Manage Integrations > New > Consumer Key/Secret shown ONCE), the SuiteCloud features that have to be enabled to avoid the 'required features missing' install error, plus SuiteAnalytics Workbook exports, SuiteScript RESTlets + Apps Script, and no-code connectors.
NetSuite is the system of record for thousands of mid-market and enterprise finance teams, and one of the slowest, hardest data sources to extract from for live reporting. Every option has trade-offs: SuiteScript is too engineering-heavy for ad-hoc work, SuiteAnalytics Connect (ODBC) is Excel-first, enterprise iPaaS is $1k+/month, manual CSV exports are a chore. This guide covers every realistic path in 2026, with a full Brooked walkthrough including TBA setup, saved-search imports, SuiteQL queries, and multi-entity consolidation.
Quick comparison: 5 ways to get NetSuite data into Sheets
| Method | Cost | Setup | Auto-refresh | Two-way sync | Code | Best for |
|---|---|---|---|---|---|---|
| SuiteAnalytics Connect (ODBC) | Included with Premium+ | 30 min per user | Manual (Excel only refresh natively) | No | DSN setup | Excel users with Premium NetSuite |
| Saved Search → CSV export | Free | 30 seconds per export | Manual | No | None | One-off snapshots |
| Celigo / Workato / Boomi | $1,000+/month | Weeks | Scheduled | Yes | None | Org-wide iPaaS, NetSuite integrated with many systems |
| Apps Script + NetSuite REST API | Free | 4–6 hours (TBA setup) | Time-driven trigger | DIY | Required | One-developer custom workflows |
| Brooked add-on | Free tier · Pro $29/user | Under 15 min | 15 min / hourly / daily | Yes (Journal Entries, Customers, etc.) | None | Finance teams who want live NetSuite reporting in Sheets with AI |
Token-Based Authentication setup, step by step
Every NetSuite connector. GURUS, Coefficient, Brooked, anything else - needs the same four token values. The setup happens entirely inside NetSuite and trips up about 60% of first-time users because the Consumer Key/Secret and Token ID/Secret are shown exactly once and there's no way to retrieve them later. Have a password manager open before you start.
Step 1. Enable the SuiteCloud features. Go to Setup → Company → Enable Features → SuiteCloud tab. Tick Token-Based Authentication and REST Web Services. Save. Skipping this step is the cause of the 'required features missing' SuiteApp install error that GURUS users hit.
Step 2. Create an integration record. Go to Setup → Integration → Manage Integrations → New. Give it a name (e.g. "Brooked Sheets Integration"), tick Token-Based Authentication, leave User Credentials unticked. Save. NetSuite now shows your Consumer Key and Consumer Secret in a one-time confirmation. Copy both into your password manager immediately. They will never be visible again.
Step 3. Create a role with the right permissions. Go to Setup → Users/Roles → Manage Roles → New (or copy an existing role). Under the Permissions → Setup subtab, add Log in using Access Tokens (Full level). Under Permissions → Lists/Transactions/Reports, add view-level access to whatever objects you need to read into Sheets. Save.
Step 4. Assign the role to a user. Setup → Users/Roles → Manage Users → edit the user you want to use for the integration → Roles subtab → add the new role. Save.
Step 5. Generate the access token. Go to Setup → Users/Roles → Access Tokens → New. Pick the application (the integration you created in Step 2), pick the user, pick the role. Save. NetSuite now shows your Token ID and Token Secret, copy both immediately, same as in Step 2. Also note your Account ID, which is the number at the start of your NetSuite URL (e.g. 1234567.app.netsuite.com means Account ID 1234567).
Done. You now have the four token values (Consumer Key, Consumer Secret, Token ID, Token Secret) plus the Account ID. Any connector. Brooked included: connects with just these five values plus the environment indicator (production vs. sandbox).
Method 1. SuiteAnalytics Connect (ODBC)
NetSuite's official ODBC driver. Install locally, configure a DSN with your account credentials, use Excel's Data → Get Data → From ODBC. Excel refreshes natively. For Sheets, you'd need a separate step (Excel snapshot → Sheets, or pgloader pipeline). Pros: Native, official, real-time. Cons: Per-user driver install, Excel-first, SuiteAnalytics Connect license required on some editions.
Method 2. Saved Search → CSV export
Build a saved search in NetSuite, click Export → CSV, upload to Sheets. Native, free, takes 30 seconds. The standard monthly-close pain when you do this for 15 saved searches every month.
Method 3. Celigo / Workato / Boomi (enterprise iPaaS)
Integration platforms with deep NetSuite expertise. Built for syncing NetSuite to many destinations at scale. NetSuite → Salesforce, NetSuite → Shopify, NetSuite → Sheets all wired together at the org level. Reliable, enterprise-grade scheduling and error handling. Pricing starts at $1,000+/month: overkill for "I want NetSuite data in a Sheet" unless integration is broader.
Method 4. Apps Script + NetSuite REST API
NetSuite's REST Record Service is OAuth-based (or TBA-based). From Apps Script you can call the API, fetch records or saved searches, write to a sheet, schedule with time-driven triggers. The TBA setup is the same as for Brooked (Integration record, access token, four credentials), but here you write the signing logic yourself.
Pros: Free, customizable. Cons: HMAC-SHA256 signing in Apps Script is fiddly. 6-minute timeout. You maintain the script.
Method 5, A Google Sheets add-on (Brooked)
Brooked handles the TBA authentication flow, browses your standard reports + saved searches + record objects in a sidebar, supports SuiteQL for custom queries, multi-entity consolidation, scheduled refresh, two-way write-back for select objects, and the AI agent for plain-English finance questions.
Step 1. Install Brooked and create an Integration record in NetSuite
Install Brooked from the Workspace Marketplace. In NetSuite: Setup → Integration → Manage Integrations → New. Name it 'Brooked'. Check 'TOKEN-BASED AUTHENTICATION'. Save. NetSuite displays the Consumer Key and Consumer Secret once.
Step 2. Create an Access Token in NetSuite
Setup → Users/Roles → Access Tokens → New. Pick the 'Brooked' Integration, a dedicated 'Integration User' (create one if needed), and a tightly-scoped role. Save. NetSuite displays the Token ID and Token Secret once.
Step 3. Connect NetSuite in Brooked
Brooked sidebar → Add data source → NetSuite. Enter your Account ID (visible in NetSuite under Setup → Company → Company Information), and the four credentials (Consumer Key, Consumer Secret, Token ID, Token Secret). Click Test connection.
Step 4. Pull saved searches, records, or SuiteQL queries
Brooked's NetSuite browser shows: Standard reports (P&L, Balance Sheet, AR/AP Aging, GL Detail), Saved Searches your role can run, Records (Transaction, Customer, Vendor, etc.), and a SuiteQL editor for custom queries.
Pick what you need, configure period and dimension filters, click Import.
Step 5. Multi-entity / OneWorld setup
For consolidated reports across subsidiaries, connect with a top-level parent login. For entity-specific reports, connect each entity separately. Role-level subsidiary restrictions carry through, so Brooked only sees what your role allows.
Step 6. Schedule refresh and use the AI agent
Gear icon on the import → Auto-refresh, pick a cadence. Schedule for early morning to avoid NetSuite's quarter-end load.
Open Chat: "What's our DSO trend over the last 6 months?" or "Show me all open AP invoices over 30 days old by vendor". The agent picks the right saved search, record, or SuiteQL query and lands the result with computed columns (variance, % of budget, days outstanding) added.
Brooked AI, NetSuiteWhat about Microsoft Excel?
SuiteAnalytics Connect (ODBC) is NetSuite's native Excel path: free with Premium+ editions, per-user driver install, refresh requires Excel open. Coefficient supports NetSuite on its Pro tier for both Excel + Sheets. Most teams that try Excel-as-live for NetSuite settle on Sheets + Brooked for live and .xlsx export for monthly close snapshots.
The verdict, which method when
I need this saved search once
→ Saved Search → CSV export. Native, free, takes 30 seconds. Don't engineer for one-offs.
Excel-primary team on Premium NetSuite
→ SuiteAnalytics Connect (ODBC). Included with Premium NetSuite, native Excel refresh, no third-party in the data path.
Enterprise team syncing NetSuite to many destinations
→ Celigo / Workato / Boomi. iPaaS platforms with deep NetSuite expertise. Built for org-wide integration, not just Sheets.
Finance team wanting live NetSuite reporting in Sheets
→ Brooked. Standard reports + saved searches + custom SuiteQL in one sidebar. Scheduled refresh. Multi-entity support. AI for finance questions.
Troubleshooting common issues
Which FP&A tools sync NetSuite to Google Sheets automatically?
For finance teams the realistic options fall into three buckets. Native NetSuite exposes data through Saved Searches and SuiteQL, but the spreadsheet path is manual: run the search, export a CSV, paste it in. Enterprise iPaaS tools like Celigo and Workato automate the flow, but they are built to sync NetSuite to other applications, not to land a live model in an analyst's sheet, and they are priced for IT rather than FP&A. Sheets-native connectors (Brooked and Coefficient) pull NetSuite data straight into Google Sheets on a schedule.
Brooked is the lightest of these for FP&A. Connect NetSuite once with token-based authentication, pick a Saved Search or write SuiteQL, and set the import to refresh every 15 minutes, hourly, daily, or weekly - no manual export and no middleware. The sync is two-way, so approved changes can be written back, and the AI Analyst answers questions like "DSO trend over six months" or "AR aging by customer" in plain English: at $29/user/month, a fraction of the iPaaS tools' cost.
Closing across more than one system? The same setup covers QuickBooks and Sage Intacct, with the full cost breakdown in Brooked vs Coefficient.
Related Articles
- How to Connect Sage Intacct to Google Sheets
- How to Consolidate Multiple QuickBooks Companies in One Google Sheet
- Google Sheets to QuickBooks: How to Push Spreadsheet Data INTO QBO
Frequently asked questions
Which NetSuite editions does Brooked work with?
Every edition with SuiteAnalytics Connect or REST Record Service enabled. Limited, Standard, Premium, Enterprise. Most accounts have these on by default.
Does Brooked support Token-based Authentication and OAuth 2.0?
Both. TBA is recommended for service integrations. OAuth 2.0 supported for sandbox accounts that don't have TBA enabled. Brooked picks the right flow based on your account.
Can Brooked write data back to NetSuite?
Yes for select objects (Journal Entries, Customers, Vendors, etc.) on the Pro tier. Strong recommendation: start with a small overrides table, not two-way on production GL.
Does Brooked support multi-entity NetSuite?
Yes. Either connect each entity separately, or connect with the top-level parent for consolidated reports. Role-level subsidiary restrictions carry through.
Can I run cross-record queries (transactions + customers + items)?
Yes, via SuiteQL. JOIN across record types using their internal IDs. Brooked's schema browser shows the join relationships.
Is the connection secure?
Yes. Brooked uses NetSuite's official TBA with HMAC-SHA256 signed requests. Credentials encrypted at rest. Brooked never logs response payloads. Revoke any time by disabling the access token in NetSuite.
How does Brooked compare to Celigo or Workato for NetSuite?
Celigo and Workato are iPaaS: built for syncing NetSuite to many systems at scale (NetSuite → Salesforce → Shopify, etc.). Brooked is purpose-built for getting NetSuite data into a spreadsheet for analysis. Different problems.
Can the AI agent answer finance questions like DSO, AR aging, P&L variance?
Yes. The agent knows finance vocabulary and maps to NetSuite's record structure. 'DSO trend over 6 months' or 'AR aging by customer' or 'monthly P&L by subsidiary' all work without writing SuiteQL.
Which FP&A tools sync NetSuite to Google Sheets automatically?
For finance teams the practical options are Brooked, Coefficient, and the heavier ETL platforms (Celigo, Workato). Brooked is the lightest for FP&A: connect NetSuite via OAuth, pull saved searches or GL data into Sheets, and set an automatic refresh schedule (hourly/daily/weekly), plus two-way write-back and an AI Analyst that answers DSO, AR aging, and P&L variance questions in plain English, at $29/user/month.
Connect NetSuite to Sheets in under 15 minutes.
Free tier · 100 imports/month with AI for finance reporting. SuiteQL, multi-entity, two-way write-back all supported. See the full NetSuite integration details.
Install Brooked free →
