How to Integrate Smartsheets with Netsuite

AI generated answer (using internal Slack threads):

Integrating Smartsheets with NetSuite can be achieved in a similar way to integrating Google Sheets with NetSuite, as discussed in the provided Slack threads. Here are some methods that were mentioned: 1. Using a third-party tool: There are several third-party tools available that can help you integrate Smartsheets with NetSuite. For example, CData, MavenCloud, and Integrator.io were mentioned in the threads for Google Sheets integration. You can check if these tools also support Smartsheets integration. 2. Scheduled CSV export: One user mentioned a method where a NetSuite saved search sends a CSV to an email account on a schedule, and then a tool like Microsoft Flow automatically picks it up and uploads it to Google Drive. A similar process could potentially be used for Smartsheets. 3. Custom Google Sheet Function: Another user mentioned writing a simple Restlet that proxied

search.lookupFields

and a Custom Google Sheet Function. This allowed them to use formulas to pull data from NetSuite. A similar approach could be used with Smartsheets if it supports custom functions. 4. Pulling data from scripts: One user mentioned pulling data from scripts in Google rather than pushing data from NetSuite. This could be another approach to consider if Smartsheets supports similar functionality. Remember to check the documentation and support for each method to ensure it will work with Smartsheets and NetSuite. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******