Today, the shift to teleworking affects everyone. Technology keeps you connected to your managers and team, but small steps are...
NetSuite to Google Sheets Data Exporter: Tips, Tricks & Installation Guide
So you’re looking to export Saved Searches from NetSuite to Google Sheets (Excel). Luckily, GURUS Solutions developed a free add-on that allows you to automate the process of going from NetSuite to Google Sheets.
Today we’re running you through how to install the add-on, how to use it, as well as some tips and tricks for the average user!
Table of Contents:
- What is the NetSuite Data Exporter?
- How to Download the NetSuite Data Exporter
- How to Install the NetSuite Data Exporter
- How to Use the NetSuite Data Exporter
- NetSuite Data Exporter: Tips, Tricks, & Troubleshooting
The NetSuite Data Exporter is a Google Sheet Add-on, created by GURUS Solutions, that helps companies automate the process of exporting NetSuite Saved Searches to Google Sheets/ Excel.
The Data Exporter allows you to connect to your NetSuite account with the provided credentials, run specified Saved Searches, and export the results into Excel spreadsheets. It also supports additional filters on existing Saved Searches to further refine the results.
In case we didn’t mention, one of the best parts of the NetSuite to Google Data Exporter is that it’s free! To download the tool, click the link here (or the banner below) and fill out the form on the right side of the page.
In order to begin using the Data Exporter, you need the Data Exporter bundle in NetSuite to be activated, or the tool will not work. Therefore, please wait for confirmation from a member of the GURUS Solutions team stating that your bundle has been activated.
If your bundle has not been activated, you’ll likely get the following error message:
Once you’ve filled out the form, and a GURUS employee has confirmed that your Data Exporter license has been activated, you have two installation options:
To help you get your Data Exporter up and running as fast as possible, our team put together a quick Installation Guide to help you install the tool for yourself.
Note: Because the Data Exporter is a free tool, please note that the amount of time required to obtain support for the tool will depend on the availability of our team. As such, please allow us at least 24 hours to respond to your Data Exporter related questions and queries.
For an extra level of support, GURUS Solutions now offers a Data Exporter Installation package to help install your tool, troubleshoot any questions or complications, and even obtain support in the long-term.
The standard Data Exporter Installation and Support package includes installation by a member of the GURUS team, and a 4-hour package for support, demos, troubleshooting, and more.
Learn more about package details and pricing here.
Essentially, how the NetSuite to Google Sheets Data Exporter works is that it installs part of the application on NetSuite, and another part on Google, which links with NetSuite. The application uses Google as a trigger to bring information in.
Using an account ID or search IDs that you put in the field, NetSuite takes the information and pushes it into Google Sheets.
To start seamlessly exporting your NetSuite Saved Searches to Google Sheets, check out our extensive User Guide here (or by clicking the banner below).
The User Guide offers step-by-step instructions about exporting your searches, as well as an FAQ that goes over some of the most commonly asked questions regarding the NetSuite to Google Sheets tool.
Note: If you purchase the Data Exporter Package, you’ll have a Guru run you through the process using a live demo, as well as the ability to instantly connect with a professional for any questions, troubleshooting, and more along the way.
Find out about some of the most commonly asked questions, as well as helpful tips related to using the NetSuite to Google Sheets Data Exporter.
- Saved Search Limits If you are using the NetSuite Data Exporter with a Limited License, the tool allows you to request 2 Saved Searches at a time. If you try to request more than 2 Saved Searches, you may see the following error message:
You can easily exclude the extra searches from the list by selecting “yes” in the Skip column. You may also contact us to request an upgrade to your license.
- 10 Requests Per Day You are using a NetSuite Data Exporter with a Limited License, the tool allows you to perform 10 requests per day. If you exceed your daily 10 request limit, you may get the following error message:
You may continue using the Data Exporter on another day, or contact us to request an upgrade to your license.
- Exporting Large Searches
If you are exporting a large NetSuite search (with a large number of search results), it is possible that your integration times out before you can complete the export.
To solve this, Splice, or divide, the search, into parts and then merge the exports into one Google sheet.
- Google Cell Limit
Note that Google Sheets has a limit on the number of cells per sheet. If your export exceeds the number of cells in Google Sheets, your export will be cut off.
- Exporting from NetSuite Sandbox
If you wish to export data from your NetSuite Sandbox, please provide GURUS with your Sandbox user ID when activating the Data Exporter bundle.
- Automating Exports
Automating data exports from NetSuite requires the creation of a custom script that will create time triggers in Google Sheets.
If you would like to set this up yourself, our team can give you access to the source code. The GURUS team can also create the custom script for you, at a service cost!
- Setting Up the Data Exporter With Company Permissions
When installing the Data Exporter, please note that setting up the authentication for different roles and permissions within your company can be tricky. Sometimes companies have complex permissions that may require codes or custom script.
Fill out the form below for more information or assistance.
Need More Assitance?
Fill out the form below to ask for assistance with Data Exporter installation or usage, or inquire about purchasing the Data Exporter Installation & Support package.
Get Help With The Installation