TROUBLESHOOTING: When sending data from a NetSuite saved search to Google Sheets, the import performs a sheets delete method and then a sheets write method for each line of the saved search

Integrator.io
, , ,
1

This problem can cause bottlenecks in a flow because the saved search output from NetSuite contains hundreds of lines, so integrator.io attempts the deletion process hundreds of times.

To resolve this issue, you can use the clear method in Google Sheets API. This clears the entire data range with a single command. The simplest solution is to create two flows:

  1. The first flow sends the saved search data from NetSuite to an FTP endpoint that creates a CSV file.
  2. The second flow groups all of the data in the CSV file, clears the sheet, then writes the grouped data back into the sheet.
2

The simplest solution would be to add an advanced function to "run once per flow" like what has been build for the Snowflake connector.

3

We published a brand new template in our marketplace that makes it super easy to work with Google Sheets. We published a new article too explaining all the details (here). Hope this helps.