Configure and run the flows in Google Sheets – NetSuite quickstart integration template

Contents

• Overview: Understanding the Google Sheets – NetSuite quickstart integration template
• Install the Google Sheets – NetSuite quickstart integration template
•  Configure and run flows in the Google Sheets – NetSuite integration template
  • NetSuite customers to Google Sheets spreadsheet rows
  • NetSuite purchase orders to Google Sheets spreadsheets

After you install the template, additional record mapping is required to integrate the template’s exports and imports with your Google Sheets and NetSuite apps.

Note that all of your flows are disabled when first installed. After configuring the flows, you can enable them in your Flows dashboard or in Flow Builder with the Off/On toggle button. Then run or schedule each flow.

NetSuite customers to Google Sheets spreadsheet rows

This flow syncs NetSuite customers as Google Sheets spreadsheet rows. When customers are added to the NetSuite, this integration flow exports customers from NetSuite to Google Sheets spreadsheet rows in real-time.

Flow details

• Export source: NetSuite
• Built-in listener: Get NetSuite customers - get all recently created customers from NetSuite using a webhook.
• Import destination: Google Sheets
• Built-in import: Import Google Sheets spreadsheet rows - add spreadsheet rows to Google Sheets.

Before you begin

Ensure to create a Google Sheet spreadsheet with column headers as shown below.

Setup instructions

1. In Relative URI, replace the {spreadsheetId} parameter with the Google Sheet spreadsheet ID. You can identify your spreadsheet ID as shown in this example: if https://docs.google.com/spreadsheets/d/xyz1234/edit#gid=0 is your spreadsheet URL, then xyz1234 is your spreadsheet ID.

Replace the Relative URI

2. In Relative URI, replace the Sheet1 range value according to your business requirements. For more information, refer to the Google Sheets API Overview article.

Sample spreadsheet

NetSuite purchase orders to Google Sheets spreadsheets

This flow syncs NetSuite purchase orders as Google Sheets spreadsheets. When purchase orders are added to the NetSuite, this integration flow exports purchase orders from NetSuite to Google Sheets spreadsheets.

Flow details

• Export source: NetSuite
• Built-in export: Get NetSuite purchase orders - get all purchase orders from NetSuite that have been created since this flow last ran.
  • preSavePageFunction: Processing NetSuite purchase order - combines all NetSuite purchase order records.
• Import destination: Google Sheets
• Built-in import: Import Google Sheets spreadsheets- add spreadsheet rows to Google Sheets.

Sample spreadsheet