NetSuite

NetSuite (Oracle NetSuite) is a cloud ERP that unifies accounting, order management, inventory, and CRM in one system. Connecting NetSuite to Coupler.io lets you export standard and custom records, or run your own SuiteQL queries, into spreadsheets, BI tools, or databases on a schedule — without building a custom integration.

Why connect NetSuite to Coupler.io?

• Automate sales and financial reporting — Schedule regular exports of sales orders, invoices, vendor bills, and other records instead of running manual saved searches.
• Query exactly what you need — Use the SuiteQL data type to pull custom joins, filters, or aggregations that a single record type can't provide.
• Build custom dashboards — Export NetSuite data to Looker Studio, Power BI, or Google Sheets for reporting NetSuite doesn't offer natively.
• Combine with other sources — Merge NetSuite data with e-commerce, marketing, or support data for a complete view of the business.
• Flexible destinations — Export to AI tools, Google Sheets, Excel, BigQuery, Looker Studio, Power BI, or other supported destinations.

Prerequisites

Before connecting, make sure you have:

• Administrator access to your NetSuite account, needed to enable features and create the integration and token records below
• Token-Based Authentication and REST Web Services enabled (Setup → Company → Enable Features → SuiteCloud tab)
• An Integration record with Token-Based Authentication enabled (Setup → Integration → Manage Integrations → New) — this gives you a Consumer Key and Consumer Secret
• An Access Token created for the role you want Coupler.io to use (Setup → Users/Roles → Access Tokens → New) — this gives you a Token Key and Token Secret
• Your NetSuite Account ID (Realm) — found under Setup → Company → Company Information, or in your NetSuite URL

NetSuite only shows the Consumer Secret and Token Secret once, at the moment you create them. Copy all five values (Realm, Consumer Key, Consumer Secret, Token Key, Token Secret) before leaving the page — if you lose them, you'll need to create a new access token.

Quick start

Start with the Objects data type and the Invoice entity, leaving Start date and Window in days at their defaults. Run it once to confirm the connection and see the fields available, then switch to SuiteQL if you need a custom join or filter.

How to connect

NetSuite uses token-based authentication (TBA) — you enter credentials generated in NetSuite rather than signing in through a redirect.

See How to Connect for the full walkthrough of generating your Realm, Consumer Key/Secret, and Token Key/Secret in NetSuite, including the required role and feature setup.

1

In NetSuite, enable Token-Based Authentication and REST Web Services (Setup → Company → Enable Features → SuiteCloud), then create an Integration record (Setup → Integration → Manage Integrations → New) with Token-Based Authentication turned on. Note the Consumer Key and Consumer Secret NetSuite generates.

2

Create an Access Token for the role you want Coupler.io to use (Setup → Users/Roles → Access Tokens → New). Note the Token Key and Token Secret.

3

In Coupler.io, create a new data flow and select NetSuite as a source. Enter your Realm (Account ID), Consumer Key, Consumer Secret, Token Key, and Token Secret, then click Connect. For a sandbox account, append the sandbox suffix to the Realm, e.g. 1234567_SB1.

4

Choose a Data type: Objects to select a standard or custom NetSuite record type, or SuiteQL to write a custom query.

5

For Objects: select an Object (e.g., Invoice, Vendor Bill, Customer) and adjust Start date or Window in days if needed.

6

For SuiteQL: enter your query in the SuiteQL field.

7

Choose your destination and run the data flow.