RE: Send Netsuite Data to Google Sheet
Does anyone have an idea to send Netsuite Data to Google Sheet?
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.
Chris00suttles
I found that the Netsuite Saved Search Connect tool from DataAnts does this really well. It’s also super cheap compared to most other solutions without the need for an on site expert or developer. You can find DataAnts on YouTube email this dude: sais@dataants.org