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 …

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

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.

Google Sheets Delete Rows (Or Clear)

Help

system (system) Closed July 18, 2019, 10:12pm 4

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

Topic		Replies	Views
How to clear all the data of a google sheet? Activities database , activities , question	1	1128	June 7, 2021
Clearing existing data in google sheet before write range activity Help	5	2745	November 8, 2020
How To delete Google Sheet Row Help studio	4	1202	July 10, 2019
Add delete rows on google sheet Automation Starter studio , question , googlesheet	0	761	September 23, 2022
Google sheet Datatable row delete Help studio	4	1411	July 13, 2019

Google Sheets Delete Rows (Or Clear)

Related topics