How to delete entries in Google Sheets automatically?

Erstellt von Igor Galic, Geändert am Thu, 07 Jul 2022 um 02:52 PM von Sasa Markagic

The focus of this article will be on deleting entries in Google Sheets without manually going through them.

 

First we need to integrate Google Sheets. You can find the guide here.

 

Next, we need a source sheet, in this case we will use Sheet C, as seen below:

 

 For our target sheet, in this case Sheet D we will map the fields which entries we want deleted with the Constant Value, in this case "redacted".

 

 

 

As we can see, the exported sheet is the same as the Source sheet except the redacted fields. 

 

 

 

If the file contains sensitive information that needs to be redacted and the originals deleted from the records, for example Names and Addresses like in the Sheet below:

 

 

 

 

You might want to delete the source file after the export has been completed. You can do that by selecting the following option:

 

 

 

 

Furthermore, if you would like to delete the previous versions of the exported file make sure to select the Overwrite option in the Target Configuration.

 

 

 

 

 If you have any questions or need assistance, feel free to contact our support team via the chat widget on our site and within SyncSpider app. 

 

War dieser Artikel hilfreich?

Das ist großartig!

Vielen Dank für Ihr Feedback

Leider konnten wir nicht helfen

Vielen Dank für Ihr Feedback

Teilen Sie uns mit, wie wir diesen Artikel verbessern können!

Wählen Sie wenigstens einen der Gründe aus

Feedback gesendet

Wir wissen Ihre Mühe zu schätzen un werden versuchen, den Artikel zu korrigieren