How to send google sheet data to netsuite

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

Rookie Asked on September 8, 2020 in SuiteScript.
Add Comment
8 Answer(s)

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

Do you have any idea how to connect google sheet to netsuite?

Thanks,
Jayaram.

Rookie Answered on September 8, 2020.
Add Comment

Hi Jayram,

I see that you’ve asked a previous more specific question on this matter. Are you still planning to connect to Google Drive from NetSuite?

If so, I will see if I can assist you further.

Thanks,

Chris

Intermediate Answered on September 9, 2020.
Add Comment

Hi Chris,

Thanks for your assist, I had completed to integrated from netsuite to gdrive.
Now I need to do from Google sheet to netsuite
Can you please assist me on this how to do and how to setup for this ?

Rookie Answered on September 9, 2020.
Add Comment

Hi Jayaram,

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:
https://developers.google.com/sheets/api

If you set up the permissions, then the same token that lets you access Google Drive can also be used for Sheets.

Thanks,

Chris

Intermediate Answered on September 9, 2020.
Add Comment

Hi Chris,

Actually we need to send data from Google sheet to netsuite.

Thanks,
Jayaram.

Rookie Answered on September 10, 2020.
Add Comment

Hi Jayram,

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:
https://developers.google.com/apps-script/overview

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.

Thanks,

Chris

Intermediate Answered on September 10, 2020.
Add Comment

Thanks for ur assist.

Rookie Answered on September 10, 2020.
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