RE: How to send google sheet data to netsuite

Hi,  Does anyone has experience move google sheet data to netsuite?
how to setup for this?

Jai Beginner Asked on September 8, 2020 in SuiteScript.
Add Comment
8 Answers

Hi,

We could probably do with a bit more information about where you’re planning to put it in NetSuite bit here’s the genetic answer…

I’m not sure if there’s any third party plugin to do this but it can certainly be done with some scripting. In which case, the first decision is over whether you’re going to:

A. Push from Google Drive
There are a couple options here alone but it’s well worth looking at a connector like Zapier to deal with getting the data out of Drive.

Once in Zapier (or equivalent), you can pass the data to NetSuite via something like a RESTlet. Just need to make sure that you can authenticate from the chosen connector to NetSuite.

Alternatively, you could connect directly using Drive’s native scripting engine.

B. Pull from NetSuite
Authentication is the tricky bit again here bit it’s definitely possible (did it once upon a time). There a rich range of APIs to grab the data and your already in NetSuite to do with it as you wish.

I hope that helps and I’ll be happy to answer any further questions.

Thanks,

Chris

Intermediate Answered on September 8, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.