How to connect google sheet to Netsuite ? With custom solution

AI generated answer (using internal Slack threads):

****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ****** To connect Google Sheets to NetSuite, you can use a variety of methods. Here are a few options that have been discussed in the Slack threads: 1. Using a third-party tool: There are several third-party tools available that can help you connect Google Sheets to NetSuite. For example, Maven Cloud offers a Google Sheets Connector that allows you to define what data to send via saved search and at what frequency. Another tool is Integrator.io, which offers a free tier for a single flow. 2. Using Microsoft Flow and Gmail: You can set up a NetSuite saved search to send a CSV to your Gmail on a schedule. Microsoft Flow can then automatically pick it up and upload it to Google Drive in a folder. You can then open it via Google Sheets as needed. 3. Using a custom Google Sheet Function and a Restlet: You can write a simple Restlet that proxies

search.lookupFields

and a Custom Google Sheet Function. Then you can use formulas like

=GET_NETSUITE_VALUE('transaction', A2, 'amountremaining')

to pull data from NetSuite. 4. Using Google Apps Script with a NetSuite access token: You can pull data from scripts in Google rather than push data from NetSuite. This method requires some knowledge of Google Apps Script and how to use a NetSuite access token. Remember to choose the method that best suits your needs and technical capabilities.