Send Netsuite Data to Google Sheet

Does anyone have an idea to send Netsuite Data to Google Sheet?

Beginner Asked on March 1, 2021 in SuiteScript.
Add Comment
3 Answer(s)

A little setup in googlesheets is required, you have to deploy your googlesheet script as a webapp (which generates an endpoint for you starting with “https://script.google.com/a/macros/…”), and your script has to reckon with the data coming in (via googlesheets’ doGet and doPost functions).  I noticed that googlesheets’ script legacy editor seems difficult with generating these webapp deployments, so you should try doing it in the new script editor.

As for Netsuite side, it should be as simple as making an https.post request to the googlesheet endpoint you generated.  I say “should” because I’ve personally only posted data through an html <form> from the client side rather than via the N/https module.

Rookie Answered on March 2, 2021.
Add Comment

Is it possible to trigger from Netsuite? like if we click the Suitelet URI we have to store data in Google Sheet. is there a way to deploy script in all google Sheets?

Beginner Answered on March 2, 2021.
Add Comment

Fair chance that if you have to ask, the answer is to look for an existing solution that integrates with Google Sheet.

The hard answer is to use N/search in combination with N/https to access the google sheets api. Depending on how you plan on authenticating, you may end up needing support for JWT, which will probably require a JWT package, or if you are very ambitious, the N/crypto module. I believe you have asked this question here enough times to realize that your question is very broad and not simple.

Intermediate Answered on March 2, 2021.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor