Skip to main content
  • Why Choose GURUS
    • About Us
    • Clients
    • Events
    • Gurus Partner Program
    • Reference Program
    • GURUS for GOOD
  • Careers
    • Job Openings
    • Working at GURUS
    • GURUS Academy
  • Contact
Free Business Intelligence Demo   1.877.664.1023
  • Solutions
    • NetSuite
      • NetSuite OneWorld
      • NetSuite PSA & SRP
      • NetSuite OpenAir
      • NetSuite Sandbox
    • Data Toolkit
      • Business Intelligence for NetSuite
        • BI by Role
        • NetSuite Data Warehousing
        • BI Templates for NetSuite
      • GURUS NetSuite Data Exporter
        • Financial Planning & Analysis Edition
    • Custom Solutions
      • Container Management
      • Engineer-To-Order (ETO)
      • Dynamic Special Order
      • Marketplace Reconciliation
      • Bulk Transaction Emailer
    • NetSuite Modules
      • Financials and Management
        • Dunning Letters
        • Financials
        • Fixed Assets
        • Incentive Compensation
      • Manufacturing
        • WIP & Routing
        • Work Orders & Assemblies
      • Retail and Distribution
        • Demand Planning
        • Grid Order Management
        • Inventory Management
        • Procurement
        • WMS Lite
      • Services
        • Job Costing
        • Project Management
        • Resource Allocation
        • Revenue Management
      • Software
        • Contract Renewals
        • Software Management
    • Boomi
    • NetSuite Add Ons Solutions
    • NetSuite for Private Equity Firms

    FREE BUSINESS INTELLIGENCE DEMO

    Request your Free Business Intelligence Demo & Discovery Call Today. Have our resident BI expert guide you through the solution’s features.

    Learn More

  • Industries
    • Industry Solutions
      • Food and Beverage
        • NetSuite’s Top 5 for Food and Beverage
        • Top Software For Food and Beverage Industry
        • Food and Beverage Industry Trends
      • Life Sciences
        • Biotherapeutics
        • Clinical Trials
        • Genomics
        • Laboratories
        • Medical Devices
        • Medical Distribution & eCommerce
        • Medical Practices
        • Medical Software
      • Professional Services
      • Software & Internet Providers
      • eCommerce
      • Media & Publishing
      • Non-Profits
      • Engineering
      • Construction
      • Manufacturing
        • Cloud-Based ERP for Manufacturing
        • Complete Manufacturing Workflow with NetSuite
        • How to Increase Profits with NetSuite ERP
      • Cannabis & CBD
      • Wholesale Distribution
        • The Benefits of an ERP For Wholesalers
        • Top Wholesale Distribution Software
        • Wholesale Distributors vs. Direct-To-Consumer
      • Healthcare
        • 5 ERP Features For Healthcare Suppliers
        • Healthcare ERP for Clinics
        • NetSuite FAQ for the Healthcare Industry
      • Energy
      • Retail
        • Benefits of NetSuite for Retail
        • Improve Customer Experience with NetSuite
        • Scale Operations with NetSuite for Retail

    FIND THE NETSUITE BUNDLE FOR YOUR INDUSTRY

     

    Our team of specialists can customize your NetSuite with the right features to meet the needs of your business. Find the right solution for your industry.

    Learn More

  • Services
    • NetSuite Services
      • NetSuite Implementation & Configuration
      • NetSuite Project Rescue
      • NetSuite Training
      • NetSuite Data Migration
      • Business Process Review
      • NetSuite Integration
      • NetSuite Upgrade Readiness Review
      • Customization & Development
      • Assessment & Architecture
      • NetSuite Optimization
      • NetSuite Support
      • Staff a Project
      • NetSuite Admin Services
    • Integrations and Connectors
      • NetSuite Integrations
        • NetSuite to Salesforce Integration
        • NetSuite to Shopify Integration
        • NetSuite to HubSpot Integration
        • NetSuite to Procore Integration
        • NetSuite EDI Integration
        • NetSuite eCommerce Integration
      • Salesforce Integrations
        • Salesforce To HubSpot
        • Salesforce To NetSuite
        • Salesforce To Outlook
        • Salesforce To QuickBooks
        • Salesforce To Slack
        • Salesforce To Call Center Software

    FIND THE RIGHT CUSTOM SOLUTION TAILORED TO YOUR INDUSTRY

    Custom ERP solutions to connect your company’s needs with NetSuite functionalities using custom script. Learn more to find a solution that meets your company’s needs.

    Learn More

  • Pricing
    • NetSuite Pricing
    • Integrations Pricing

    NetSuite Implementation Pricing

    Find the answers to all your NetSuite ERP cost, licensing and implementation questions in our comprehensive Pricing Guide for buyers.

    Learn More

  • Resources
    • Browse resources
      • FAQ
        • NetSuite Data Exporter
        • GURUS Business Intelligence
        • NetSuite FAQs
      • Blog
      • Video
      • Press Releases
      • ERP Comparison Hub
    • Filter resources
      • All
      • Demos
      • Podcasts
      • White Papers
      • Data Sheets
      • Webinars
      • Glossary

    GURUS CLOUD CONNECT

    Webinars as short as your coffee break. Register now to hear industry experts answer your tech-questions in snack-sized episodes.

    Learn More

Breadcrumb

  • Home
  • Blog
  • NetSuite to Google Sheets Data Exporter: Installation Guide

NetSuite to Google Sheets Data Exporter: Installation Guide

Profile picture for user Athen Bozoglu
By: Athen Bozoglu 01.04.2021
Copied to clipboard

So you’re looking to export Saved Searches from NetSuite to Google Sheets. Luckily, GURUS Solutions developed an add-on that allows you to automate the process of going from NetSuite to Google Sheets. Even more, you can get started free with a limited trial.

Today we’re running you through how to install the add-on.

Table of Contents:
  • How to Install the GURUS NetSuite Data Exporter
  • Registering the NetSuite Data Exporter
  • Installing the NetSuite SuiteBundle
  • Configuring Access for the GURUS NetSuite Data Exporter
     
    • Configure an Integration Application
    • Configuring a NetSuite Role
    • Configure an Access Token
  • Frequently Asked Questions During Installation
  • Configuring NetSuite Embed Dashboard (Premium Edition)

Get Help With The Installation

How to Install the GURUS NetSuite Data Exporter

Follow the steps below to Install the Google Sheet Add-on for the NetSuite data Exporter. These steps are usually done for each User on your Google Workspace that wants to use the software. It can also be done by your Google Administrator to be done across the whole Workspace.

  1. Open a Google Sheet in your Workspace.
  2. Navigate to Add-ons -> Get add-ons


     
  3. Search for the "NetSuite Data Exporter" in the search bar and select the listing. Make sure you select the one with the GURUS logo.

  4. Click the Install button on the top of the page to install it.


  5. Once installed, click Continue on the pop up screen.
  6. Sign in with your Google account
  7. Click Allow to grant the permissions required by the add-on.
  8. The add-on is installed.

Registering the NetSuite Data Exporter

The following step needs to be done only once per NetSuite Account. The Application must be registered with GURUS Solutions so it can be activated and the NetSuite Suitebundle to be shared with your account. To do so, please complete the following steps:

  1. Navigate to our website at the following address: https://gurussolutions.com/solutions/data-toolkit/netsuite-data-exporter/
  2. Review and agree to our Privacy Policy as well as the End User License Agreement
  3. Locate your NetSuite Account Number. You will need it to fill the registration.

     

    You can find your NetSuite account ID at the beginning of the NetSuite URL. For example, if the URL is https://1234567.app.netsuite.com/, your account ID is 1234567.

    Note: Please mention in the comments if you also want to get access for your sandbox account.

  4. Fill out the form and Submit it.

        5. Please wait for us to confirm your registration.

Installing the NetSuite SuiteBundle

Once your registration is completed and confirmed by your GURUS Representative, you can proceed to the installation of the NetSuite side SuiteBundle. You will need to follow this step only once per NetSuite Account.

This step must be performed by your NetSuite Administrator or anyone with sufficient permission to install a SuiteBundle.

  1. Log in into your NetSuite account as an administrator
  2. Navigate to Customization -> SuiteBundler -> Search & Install Bundles

  3. In the keywords field type in Netsuite Data Exporter or Bundle ID: 233251, then click Search
  4. Find the Bundle that has the ID of 233251 and then click on the Bundle’s name
  5. Click the Install button.

  6. Read and accept the End User License Agreement. 
  7. Click next and follow all the steps of the Assistant.
  8. Wait for the bundle to finish installing (this could take several minutes).

Configuring Access for the GURUS NetSuite Data Exporter

This section will describe the steps required to generate credentials that are required to use the Data Exporter.
You may need to get the assistance of your NetSuite Administrator to perform the following steps.

Some of these steps will need to be done at least once per instance, and some of these steps will need to be done at least once per user you want to give access to the Data Exporter.

Configure an Integration Application

This step needs to be done only once for the whole instance. You may require your NetSuite Administrator to perform these tasks. 

Refer to the following SuiteAnswers article on how to create an Integration Application for Token Based Authentication: https://netsuite.custhelp.com/app/answers/detail/a_id/82077/

  1. Log into NetSuite as Administrator (or with a role with Permission to create an Integration Application)

  2. Navigate to Setup -> Integration -> Manage Integrations -> New

  3. Give a name to the integration (ex: NetSuite Data Exporter).

  4. Set the status to Enabled.

  5. Check the box for Token-Based Authentication

  6. Uncheck every other checkbox.

  7. Save the Record

  8. Right after the page is saved, navigate to the bottom of the page and take note of the Consumer Key/Client ID and Consumer Secret/Client Secret.

  9. Keep these credentials securely. They will be required for all your users that will use the Data Exporter.

    IMPORTANT: It is the only time you can take note of those credentials, they will not be displayed again.

    ALSO IMPORTANT: Manipulate these credentials with the same care you would for your username and passwords. It is recommended that you do not save them in plain text, nor send them over email. Make sure they are shared securely.

Configuring a NetSuite Role

This step needs to be done at least once for the whole instance. You may want to create different roles depending on which user extracts data through the Data Exporter. You may require your NetSuite Administrator to perform these tasks.

We strongly recommend that you prepare a role that is read only and only provide access to the records and data that your user needs. We will leave to your discretion to decide the exact set of permissions to set.

Refer to the following article to understand how to create a NetSuite Role:

  • https://netsuite.custhelp.com/app/answers/detail/a_id/9896
  • https://netsuite.custhelp.com/app/answers/detail/a_id/9921
  • https://netsuite.custhelp.com/app/answers/detail/a_id/82075

Make sure your role contain the following permission:

  • Setup -> Log in Using Access Token

Assign this role to any users for which you will give access to the NetSuite Data Exporter on their Employee Record.

Configure an Access Token

This step needs to be done for each user that will have access to the NetSuite Data Exporter.

You can share tokens across multiple Google User, but keep in mind they will have access based on the context of the user and role attached to the Token.

An Access Token is a set of credentials combining a specific user and a specific Role. For information on how to create an access token, please refer to the following SuiteAnswers article :
https://netsuite.custhelp.com/app/answers/detail/a_id/82313/

  1. Log in as a user with the Access Token Management permission (This can be your Administrator).
  2. Go to Setup > Users/Roles > User Management > Access Tokens (Administrator).
  3. On the Access Tokens page, click New Access Token.
    The Access token page displays.

  4. On the Access Token page:
    1. Select the Application created in “Configure an Integration Application”.
    2. Select the User you gave the role as defined in “Configuring a NetSuite Role”.
    3. Select the Role created in “Configuring a NetSuite Role”.
    4. The Token Name is already populated by default with a concatenation of Application Name, User, and Role. Enter your own name for this token, if desired.
  5. Click Save.
  6. Right after the page is saved, navigate to the bottom of the page and take note of the Token ID and Token Secret.
  7. Keep these credentials securely. They will be needed to be set in the Data Exporter for the selected user.

    IMPORTANT: It is the only time you can take note of those credentials, they will not be displayed again.

    ALSO IMPORTANT: Manipulate these credentials with the same care you would for your username and passwords. It is recommended that you do not save them in plain text, nor send them over email. Make sure they are shared securely.

Frequently Asked Questions During Installation

Q: I cannot find the Bundle when I search it by name or by it's ID or I get the following error message:

What can I do?

A: This can mean the following:

  1. You have not completed the registration with GURUS solutions. Please follow the instructions in above for registering the GURUS NetSuite Data Exporter.
  2. The provisioning is not yet completed by the GURUS team. You can wait and try again later, or contact your representative to get a status on the progress. 
  3. If the button is present in Production but not in Sandbox, contact your GURUS representative to have the bundle shared with your sandbox account as well.

Q: I get the following error message. Why?

A: This can mean the following things:

  1. The required SuiteBundle has not been installed in the NetSuite instance. See the section on Installing the NetSuite SuiteBundle in the Installation Guide for guidance.
  2. If you are trying to run the Data Exporter with your Sandbox, it could mean the Bundle is not installed in the sandbox account. Please follow the instructions for Installing the NetSuite SuiteBundle on your Sandbox account.
  3. If you cannot install the bundle (you cannot find it or the Install button is not enabled or get the error message below), please contact GURUS Solution and ask that the bundle be shared with you. Make sure you have your NetSuite Account number as it will be necessary for this step.

Q: I receive the following error message when I try to run the Data Exporter. What does it mean?

A: This can mean the following:

  1. You have not completed the registration with GURUS solutions. Please follow the instructions for registering the GURUS NetSuite Data Exporter.
  2. The provisioning is not yet completed by the GURUS team. You can wait and try again later, or contact your representative to get a status on the progress.

Configuring NetSuite Embed Dashboard

With the Premium Edition of Data Exporter, users can embed their spreadsheets back into a NetSuite dashboard. Using the standard NetSuite “Personalize” functionality, spreadsheets can be displayed as a custom portlets for easy consumption. Moreover, Google Sheet hyperlinks will be available via the portlet to easily access the source data.

For a step-by-step guide in configuring an embed dashboard, please refer to the embed dashboard installation guide.

Get Help With The Installation


About Athen Bozoglu

Having caught the writing bug at an early age, Athen has been working with different companies in leveraging the freshest content for over a decade. He comes from a copywriting background. In the past, he has worked on copy for B2C and B2B clients across Montreal and Canada for retail, construction, manufacturing, education, and restaurants. He studied Communications and English literature at Concordia and developed a loving relationship with media the minute he laid hands on his first DSLR camera. 

Today, he consults with a team of technical experts to hone in on the latest industry trends and bring you powerful blogs on Oracle NetSuite, the Cloud, and technology.

In speaking with a great number of experts and clients across most major industries, the approach and questions remain the same: How can I optimize my business to bring in more money? What are the technologies that are right for my company? How can I improve my financials and better manage growth? 

Currently the resident Digital Marketing Specialist at GURUS Solutions and host of GURUS Cloud Connect, where he interviews executives and subject matter experts on the newest technologies, he stays busy. 

Not tired of hearing about Athen yet? (Neither is he) 

You can catch him in the latest episode of GURUS Cloud Connect by subscribing to the series below:

Recent posts

  • Profile picture for user Neil Stolovitsky
    By : Neil Stolovitsky 13.03.2023

    Power BI vs. Tableau

    • BI for NetSuite ERP integration
    • Data Visualization
    Discover the comparison of two influential software, Power BI and Tableau, to see which BI platform is right for your business data transformation.
    Read this post
  • Profile picture for user Victoria Sapsford
    By : Victoria Sapsford 13.03.2023

    What is Cost Savings?

    • Popular ERP Questions
    Discover how your company can benefit from cost savings with NetSuite ERP in order to reduce spending and control your company’s bottom line.
    Read this post
  • Profile picture for user Victoria Sapsford
    By : Victoria Sapsford 28.02.2023

    NetSuite Data Migration Strategy

    • NetSuite ERP
    Prepare for the implementation of your new ERP system by strategizing your data migration process and ensuring positive change management.
    Read this post
Related tags
  • NetSuite Tutorial
  • ERP Tools
  • NetSuite Integration Tools

News & Events

  • Press releases

    GURUS Solutions named to the Bob Scott Top 100 VARS for 2023

    Montreal, Quebec - June 28th 2022 On June 9th, 2022, GURUS Solutions was named to The Bob Scott Top 100 VARS for 2022. The
    Read more
    Published 30 January 2023
  • Press releases

    GURUS Solutions Unveils Partnership with Mavenlink

    GURUS Solutions is proud to announce its latest partnership with Mavenlink, the industry cloud for professional services
    Read more
    Published 10 March 2022
  • Press releases

    Dell sells Boomi to Francisco Partners and TPG Capital

    [Chesterbrook, PA, Round Rock, Texas, San Francisco - May 2, 2021] As of May 2nd, 2021, Dell Technologies has officially reached
    Read more
    Published 20 May 2021

Blog

  • Power BI vs. Tableau
    Neil Stolovitsky, 13.03.2023
     NetSuite customers are very fortunate to have powerful persona-based dashboards, reporting
  • What is Cost Savings?
    Victoria Sapsford, 13.03.2023
     Money makes the world go around, and to the chagrin of some, there is no escaping it. This
  • NetSuite Data Migration Strategy
    Victoria Sapsford, 28.02.2023
     At a time where Big Data reigns supreme and accurate data is crucial to companies looking
All posts

Contact

TOLL-FREE: 1.877.664.1023
info@gurussolutions.com

Head Office

9880 Clark Street, Suite 101
Montreal, QC
H3L 2R3 Canada

Tel: 514.664.1023

Join the Team

We are always on the 'lookout' for new talent. Are you The One we are looking for?

Careers

 

Regional offices

Boston, MA: 617.807.0903
Chicago, IL: 312.588.7295
Cleveland, OH: 216.202.0264
Dallas, TX: 214.377.1221
Manchester, NH: 603.657.9458
Miami, FL:786.453.9063
Oklahoma City, OK: 405.896.8422
Ottawa, ON: 613.454.6013
Rochester, NY: 585.666.0574
San Francisco, CA: 415.449.8611

 

SEE ALL LOCATIONS

100% MONEY BACK GUARANTEE

Follow us in social media

Copyright © 2023 Gurus Solutions

All rights reserved

  • Privacy policy