How to send google sheet data to netsuite
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.
Did you end up doing the scripting in NetSuite and accessing Google Drive via the API?
If so, then there are a similar set of APIs for Google Sheets:
If you set up the permissions, then the same token that lets you access Google Drive can also be used for Sheets.
Ah, I thought you might be able to pull the data into NetSuite. Given that you done the scripting for GoogleDrive, it would be much quicker if you could make that option work.
However, if you need to start from the other end then you could use Google Apps Scripts:
But it may be a lot easier to use a connector like Zapier to grab the data from Google Sheets. In any case, you’ll be doing some extra scripting outside of Netsuite.