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.

Tom Santiago Principal Technical Writer Community moderator

• January 22, 2021 20:29
• Edited

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.

0

• Official comment

  

  Scott Henderson CTO

  • October 19, 2023 22:17

  

  

  

  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.
• 

  Jeffery Hill Senior Solutions Consultant

  • December 19, 2021 15:41

  

  

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

  1

Please sign in to leave a comment.