Follow these steps to start exporting your NetSuite Saved Searches into Google Sheets

NetSuite Data Exporter is a Google Sheet Add-on built to accelerate and automate the process of exporting NetSuite saved search results to Google Sheets. This app will allow you to connect to your NetSuite account with the provided credentials, runs specified saved searches, and exports the results into spreadsheets. It also supports additional filters on existing saved searches to further refine the results.

Prerequisite:

Follow the steps in the Installation Guide to have NetSuite Data Exporter installed.

How to request a search:

If you already see the NetSuite Data Exporter sidebar and Settings tab in your sheet, skip to Step 3.

Open a Google sheet that you want to have the search results saved. Navigate to Add-ons > NetSuite Data Exporter > Request Search Results
The NetSuite Data Exporter sidebar appears to the right and a pop-up message displays to request your confirmation to add the Settings tab. Click Yes.
The Settings tab is now created. Enter details for the searches that you want to retrieve.

3.1. Search Id: mandatory.

In NetSuite, you may obtain the Search Id of your saved search from its URL

Or from the Saved Searches list view, once you have enabled the preference to Show Internal IDs

3.2. Tab: mandatory.

Enter the name of the tab to place the search results in. If the specified tab does not exist, a new tab will be created. If the specified tab exists, it will be overwritten by the search results.

3.3. Skip: optional.

Select Yes to skip this search from the next request. (ex: If you want to pull your list of customers once a month, but update your sales data weekly). Select No or leave it empty to include this search in the next request.

3.4. Additional Filters: optional.

Multiple filters may be applied as long as you enter the filters on new rows before the next saved search.

(ex:)

4. In the NetSuite Data Exporter sidebar, enter required authentication credentials for your NetSuite instance.

4.1. For standard login:

4.1.1. Enter your NetSuite Username and Password

4.1.2. Click button: Retrieve Roles and Accounts

4.1.3. Select from dropdown list: Role and Account. The Role ID and Account Number will be populated.

Note: if your account has two-factor authentication enabled, you need to use Token Based Authentication.

4.2. For Token Based Authentication:

4.2.1. Click the button: Switch to Token Based Authentication

4.2.2. Enter your TBA credentials and Account Number

5. Click Request

6. Done! Search results are now exported to the specified tabs and a success message displays. If you entered an existing tab for your search, you will be prompted to confirm that the tab will be overwritten before the results are exported.

Frequently Asked Questions:

Q: I get an error saying that my email/password is invalid. But I’m able to log in to NetSuite with the exact same credentials. Why?

A: This may occur to customers who log in to their sandbox using the separate sandbox domain: https://system.sandbox.netsuite.com. As all sandboxes are going away from it in their next refresh, there is no plan to support it. Nevertheless, you can always use NetSuite Data Exporter for your production instance.