Skip to main content
Manage your NetSuite ERP data with natural language prompts. Let Gumloop handle the API complexity while you focus on automating business processes, running queries, and managing records across your organization.
Full access to NetSuite records, SuiteQL queries, and schema definitions so you can create, read, update, and delete any record type from a single node.

​
How to Use MCP Nodes

​
What is NetSuite MCP?

NetSuite MCP creates an AI-powered node that understands the NetSuite REST API for you. Instead of navigating complex endpoints or writing code, simply describe what you want and the node handles the rest. Results come back as structured data that you can pass to other nodes in your workflow.

​
What Can It Do for You?

  • List, create, update, and delete any NetSuite record type (customers, invoices, sales orders, vendors, etc.)
  • Run SuiteQL queries for advanced data retrieval with SQL-like syntax
  • Inspect record schemas to understand available fields before building queries
  • Power repeatable workflows by returning structured data that connects to Sheets, Slack, and more

​
Available Tools

ToolWhat It DoesExample Use
List RecordList records with filtering and automatic pagination”List customers where companyName contains ‘Acme’ and return id, companyName, email”
Get RecordGet a single record by ID with optional field selection”Get customer customer_id and return companyName, email, phone”
Create RecordCreate new records with support for sublists and subrecords”Create a customer with companyName ‘New Corp’, email ‘[email protected]‘“
Update RecordUpdate existing records with partial or full field replacement”Update customer customer_id, set phone to ‘555-1234‘“
Delete RecordDelete records by record type and ID”Delete customer customer_id”
Run SuiteQL QueryExecute SuiteQL queries for advanced data retrieval”Run query: SELECT id, companyName FROM customer ORDER BY id FETCH FIRST 10 ROWS ONLY”
Get Record SchemaGet the complete schema definition for any record type”Get schema for salesOrder and return all available fields”

​
How to Use

1

Create Your NetSuite MCP Node

Go to your node library, search for NetSuite, and click “Create a node with AI”
2

Add Your Prompt

Drag the NetSuite MCP node to your canvas and describe the single action you want to perform.
3

Test Your Node

Run the node to see the results. If it works as expected, you’re all set. If you run into issues, check the troubleshooting tips below.
4

Save and Reuse

Once your NetSuite MCP node is working, save it to your library for future workflows.

​
Setting Up NetSuite Credentials

NetSuite uses OAuth 2.0 for authentication. Before using the NetSuite MCP node, you need to configure OAuth credentials in both NetSuite and Gumloop.
For complete step-by-step instructions on setting up NetSuite OAuth authentication, see the NetSuite OAuth Configuration Guide.

​
Quick Setup Overview

1

Create a NetSuite Integration Record

In NetSuite, navigate to Setup > Integration > Manage Integrations > New and create an OAuth 2.0 integration with:
  • Authorization Code Grant enabled
  • Public Client checked
  • Redirect URI: https://api.gumloop.com/auth/callback
  • Scopes: RESTlets and REST Web Services enabled
Save and copy your Client ID and Client Secret.
2

Configure Role Permissions

Ensure your NetSuite role has the required OAuth permissions:
  • Log in using OAuth 2.0 Access Tokens
  • REST Web Services
  • RESTlets
3

Add OAuth Config in Gumloop

For Team/Enterprise plans: Organization admins add the NetSuite OAuth Config at Organization Credentials.For Individual users: Add the NetSuite OAuth Config at Personal Credentials.
4

Connect Your NetSuite Account

  1. Go to Personal Credentials
  2. Click Add Credential and select NetSuite
  3. Enter your workspace name (the subdomain of your NetSuite URL, e.g., mycompany for mycompany.app.netsuite.com)
  4. Click Add credential and authorize via NetSuite
The Client ID and Client Secret are only displayed once after saving in NetSuite. Store these credentials securely. For detailed troubleshooting and security best practices, refer to the full OAuth configuration guide.

​
Example Prompts

Here are some prompts that work well with NetSuite MCP: List Records: 
List customers and return id, companyName, email, phone
Get Record by ID: 
Get salesOrder `order_id` with expandSubResources=true and return all fields
Create Record: 
Create a customer with companyName "Acme Corp", email "[email protected]", phone "555-0100"
Update Record: 
Update customer `customer_id`, set phone to "555-9999" and return id, companyName, phone
Run SuiteQL Query: 
Run SuiteQL: SELECT id, companyName, email FROM customer WHERE companyName LIKE '%Tech%' ORDER BY id FETCH FIRST 20 ROWS ONLY
Get Record Schema: 
Get schema for invoice and return all available fields
Start with a simple prompt like “List customers” to confirm your connection works, then add filters and specific fields. Use Get Record Schema to discover available fields before building complex queries.

​
Supported Record Types

NetSuite MCP supports all standard NetSuite record types, including:
  • Customers & Contacts: customer, contact
  • Transactions: invoice, salesOrder, purchaseOrder, estimate, opportunity, vendorBill, journalEntry, payment, creditMemo
  • Items & Inventory: item, itemFulfillment
  • Vendors: vendor
  • Financial: account
  • Subscriptions: subscription, returnAuthorization
Use the Get Record Schema tool to discover all available fields for any record type before building your queries.

​
Troubleshooting

If your NetSuite MCP node isn’t working as expected, try these best practices:

​
Keep Prompts Simple and Specific

  • Good: “List customers where companyName contains ‘Acme’ and return id, companyName”
  • Less Efficient: “List all customers, filter by region, calculate their total orders, and send a summary email”
While the complex prompt might work, it’s more efficient to break it into separate nodes. NetSuite MCP works best with focused, single-action prompts.

​
Match What NetSuite Can Do

  • Good: “Run SuiteQL: SELECT id, companyName FROM customer ORDER BY id FETCH FIRST 10 ROWS ONLY”
  • Less Efficient: “Query customers, analyze their purchase patterns, and create a PowerPoint presentation”
NetSuite MCP excels at data retrieval and record management. For analysis or presentation creation, connect the output to Ask AI or other nodes in your workflow.

​
Break Complex Tasks Into Steps

For best results and to avoid timeouts or errors, break large tasks into smaller prompts. Instead of: 
List all sales orders, get customer details for each, calculate totals, and update the orders
Create a series of standalone nodes:
1

Step 1: List Sales Orders

List salesOrder and return id, customer, total
2

Step 2: Get Customer Details

Get customer customer_id and return companyName, email
3

Step 3: Update Order

Update salesOrder order_id, set memo to “Processed”
Connect these nodes sequentially in your workflow. The order IDs from Step 1 feed into Step 2, and so on.

​
Use SuiteQL for Complex Queries

For advanced filtering, joins, and aggregations, use SuiteQL queries instead of the List Record tool: 
Run SuiteQL: SELECT c.id, c.companyName, COUNT(so.id) as orderCount 
FROM customer c 
LEFT JOIN salesOrder so ON c.id = so.entity 
GROUP BY c.id, c.companyName 
ORDER BY orderCount DESC 
FETCH FIRST 10 ROWS ONLY

​
Troubleshooting Node Creation

In the node creation window (or if you’ve already created the node hover over it and click on ‘edit’), ask the Gummie to add debug logs and verify the API response.
In the node creation window (or if you’ve already created the node hover over it and click on ‘edit’), describe what you expected versus what you received.
Verify your OAuth connection is still valid. Check that your NetSuite role has the required permissions (REST Web Services, RESTlets, OAuth 2.0 Access Tokens). See the OAuth configuration guide for troubleshooting steps.
Ensure your NetSuite role has access to the record types you’re trying to query. Contact your NetSuite administrator to verify role permissions.

​
Need More Help?