Google Sheets Delete Rows (Or Clear)

Help
1

Hi All,

I am making a workflow which receives a report from a location and then puts the contents onto a google sheet, overwriting the existing data.

With the current Google Sheets activities, there is no way for me to delete rows or to delete the contents. Does anyone have any work arounds doing such?

2

Hi @Nicholas_Doss,
Have you tried to write just empty data using “Write Range” from Google Spreadsheet activity?

2 Likes
3

Hi @Pablito,
I have done a read range to get the specifications of the google sheet and saved this as a datatable. Then I have changed the values of the datatable to blank and then I have done a write range back to the google sheet. This has successfully overwritten all of the data as blank.

1 Like
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.