Dynamically find and delete a spreadsheet row

Question

When I receive a cancellation in rezdy I want to make a zap that will delete a Google Sheet row that was created before by another zap.

I created an action Action Lookup Spreadsheet Row in Google Sheets to look by name and date,
and action Delete Spreadsheet Row in Google Sheets, in which I was only able to add a manually add row and was unable to add a custom value that resulted in something other than an error, or connect it to search action.

What can I do to make this work?

Thank you!

icon

Best answer by Danvers 6 April 2022, 17:37

View original

Danvers · Accepted Answer

Hi@matea!If the search step found the row that it was looking for, here’s what you need to do for the Delete Row step:For the Row, click CustomIn the dropdown, choose the Find row step and select the field IDThe ID field is the Row ID of the row from the Find Row step. Using that as the custom value is how you ‘link’ the search step to the Delete step;it tells the delete step which row was found in the previous step and therefore should be deleted.If you try that and are still running into issues, it’sbest to contact the Support team using the Get Help form, as they will be able to take a look at your Zap with you.

Troy Tessalone · Answer

Hi @mateaGood question.You’ll want to map the ID/Row value found in the GSheet Lookup Row step.Here’s a help article about how to dynamically map data point variables between Zap steps using the ‘custom’ option:https://zapier.com/help/create/basics/set-up-your-zap-action#set-up-your-action

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded