Install the Google Sheets – NetSuite quickstart integration template

Contents

• Overview: Understanding the Google Sheets – NetSuite quickstart integration template
•  Install the Google Sheets – NetSuite quickstart integration template
  • Before you install
    • A. Create your Celigo iPaaS account
    • B. Enable SuiteTalk (web services) and SuiteScript
  • Find and install the Google Sheets – NetSuite template from the marketplace
  • Set up the connections and integrate with Google Sheets and NetSuite
    • Step 1. Connect to Google Sheets
    • Step 2. Connect to NetSuite
    • Step 3. Install NetSuite integrator bundle
    • Step 4. Copy resources now from the template zip
  • Install NetSuite custom bundle (432614)
  • Get started with the quickstart template
• Configure and run flows in the Google Sheets – NetSuite quickstart integration template

This article explains how to install the Google Sheets – NetSuite quickstart integration template. 

Before you install

A. Create your Celigo iPaaS account

Sign up for an integrator.io account with administrative access to install the Google Sheets – NetSuite template.

B. Enable SuiteTalk (web services) and SuiteScript

Sign in to your NetSuite account and complete the following tasks to prepare the account for installing the required NetSuite bundle:

1. Go to Setup > Company > Enable features > Company.
2. Under Data management, select the File cabinet.
3. Under SuiteCloud, select Custom records, Client SuiteScript, Server SuiteScript, and Web services.
4. Click Save.

Find and install the Google Sheets – NetSuite template from the marketplace

To install the Google Sheets – NetSuite template:

1. Navigate to integrator.io > Marketplace.
2. From the available templates, select either NetSuite or Google Sheets.
3. Find the Google Sheets – NetSuite template and click Preview. The Install template page appears.
4. Review the template’s contents and the ReadMe file, and click Install now to begin.

Set up the connections and integrate with Google Sheets and NetSuite

To install the integration, complete the following steps.

Step 1: Connect to Google Sheets

Click Configure to set up the Google Sheets connection. If you have already set up a connection to Google Sheets, select Use existing connection and choose it from the Connection list. Otherwise, click Set up new connection and provide your Google Sheets account credentials.

Step 2. Connect to NetSuite 

Click Configure to set up the NetSuite automatic token-based auth or manual token-based auth connection. If you have already set up a connection to NetSuite, select Use existing connection and choose it from the Connection list. Otherwise, click Set up new connection and provide your NetSuite account credentials.

Step 3. Install NetSuite integrator bundle

Click Install to install the NetSuite integrator bundle

The setup page detects whether this integration bundle is already installed with the NetSuite connection that you provided. If not, it will be installed in your NetSuite account for you.

The bundle status will change to “Installed.”

Step 4: Copy resources now from the template zip

Click Install to create all 2 flows in your application.

Install NetSuite custom bundle (432614)

After installing the Google Sheets – NetSuite template, you must install the NetSuite custom bundle (ID 432614) in NetSuite:

1. Sign in to your NetSuite account.
2. From the Customization menu, select Suite Bundler > Search and install bundles.
3. Enter the bundle ID 432614 into the Keywords field, and click Search.
4. Select this bundle, and click Install.
   Information: The installation process could take a while.

The integrator bundle status changes to “Installed.”

Get started with the quickstart template

Now that you’ve installed the quickstart template in your integrator.io account, learn how to configure and run your flows:

• For more information on using integration tiles, see Use your integration tile.
• For more information on how to schedule or run a flow, see Schedule data flows.
• For more information on how to use the flow dashboard, see Dashboard tab.
• For more information on template management, see Delete or restore a quickstart integration template.