Hi Guys, How can we integrate NetSuite with Google Sheets? we don't want to use any integrator.

Well Google has an API to write to sheets. So youre looking at custom scripts to build your data and post to Sheets. Then if you want it the other way, you'll need a RESTlet inside netsuite to take a json payload and do whatever you want to with it. I'm not sure if Sheets can natively make API calls though so theres a chance youll need some kind of plugin to go from Sheets to NS

Yes, but you'll have to code the Integration yourself by a restlet/suitelet + Google Apps script and have that running on the Google sheet to sync the changes back to Netsuite

Okay @borncorp

@AB There are 3 options : 1. if you want to send data use can have userevent over record that will send your data when there's any change. 2. You can have saved search that will expose the data through restlet. 3. SuiteScript Analytic APIs that will allow you to programmatically expose the data out of netsuite.

Literally just set this up for some of my users! I have my google appscript call a suitelet on button click. But you can have it run when you first open the google sheet or use a time based trigger. Get familiar with UrlFetchApp.fetch("URL", options); _SpreadsheetApp.getActiveSpreadsheet_() getSheetByName(sheetName) getRange(row, column, numRows, numColumns) Be mindful of how much data you are trying to get. I had some large data sets and did run into time out issues (I convinced my users to narrow down the # of columns in the search they were calling).

Okay, thanks @Shubham Jadhav and @Xtina