Is there a way to delete a range in Google Sheets before updating cells?

💬 Queries and Resources
3

Hi @ysp,

I have a similar issue when I was generating a 6mos worth of data for a report. I usually generate this every week and sometimes week1 will have 14k rows and week2 will have 13k rows. The 1k row difference will still remain as GSheet resource here only updates what was the length of the data you are passing. I didn't want to do a for-loop for the delete a row method by the native gsheet resource so I did a custom api.

My workaround: Get the G Sheet API as a custom API resource.
My 2-step process here is:

  1. Clear the specified range using this POST request; and
  2. Update the values using gsheet resource of Retool.

At this point for me, if it's not within native gsheet methods in retool, I use the custom API. If you have already setup a gmail api resource, you can re-use your OAuth2.0 creds for this. Otherwise, you can follow the instructions here.

2 Likes