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
  • How to Export NetSuite Searches to Google Sheets for Free

How to Export NetSuite Searches to Google Sheets for Free

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

 

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.

  1. Open a Google sheet that you want to have the search results saved. Navigate to Add-ons > NetSuite Data Exporter > Request Search Results
  2. 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.
  3. 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.

Q: I get the following error message. Why?

A: The search id entered does not exist in the NetSuite instance. Verify the search id in the specified row.

Q: I get the following error message. Why?

A: Verify the role selected:

  • The search id is found in the NetSuite instance but your selected role does not have permission to run it.
  • Your selected a role is enabled with SAML Single Sign On (SSO), which blocks the username/password login method. Use a non-SSO role or switch to Token-Based Authentication as the alternative login method.

Q: I get the following error message. Why?

A: The filter criteria added to the search is invalid.

Q: I get the following error message. Why?

A: The required SuiteBundle has not been installed in the NetSuite instance. See section 3 in the Installation Guide for guidance.

Q: I get the following error message. Why?

A: You are currently using NetSuite Data Exporter with the Limited License which allows you to request 2 saved searches at a time. You may easily exclude the extra searches from the list by selecting “yes” in the Skip column. You may also contact us to request an upgrade of your license.

Q: I get the following error message. Why?

A: You are currently using NetSuite Data Exporter with the Limited License which allows 10 requests per day. You may continue using it on another day. You may also contact us to request an upgrade of your license.

 

Get Help With The Installation

Get Help With The Installation

 

  • Power BI vs. Tableau
    Power BI vs. Tableau
  • What is Cost Savings?
    What is Cost Savings?
  • NetSuite Data Migration Strategy
    NetSuite Data Migration Strategy
View all
Copied to clipboard

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 Support
  • NetSuite Reporting

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