I have a task at hand: I regularly update a Google Sheets document. Sometimes, I delete entire rows, and as a result, Zapier sends me empty strings to notify me of the deleted rows. My question is, how can I determine which specific row was deleted? Is there any marker or unique identification that can help me with this?
Best answer
How to identify deleted row in Google Sheets with Zapier
Best answer by Troy Tessalone
It’s documented that deleting data from a GSheets being used in Zaps can cause issues.
You may want to look into using Airtable instead of GSheets.
Airtable Records have a unique Record ID that can be used.
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+14- Zapier Orchestrator & Solution Partner
Hi
Good question.
Zap triggers from GSheets related to row changes will include the ID/Row.
The problem is if user deleted row and shifted all rows up or down? Then row id becomes useless :(
+14- Zapier Orchestrator & Solution Partner
- Answer
It’s documented that deleting data from a GSheets being used in Zaps can cause issues.
You may want to look into using Airtable instead of GSheets.
Airtable Records have a unique Record ID that can be used.
⚡ Troy Tessalone - AutomationAce.com | Platinum Zapier Solution Partner | #1 Zapier Community Contributor
Thank you very much Troy, I will try to go with Airtable
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.