I'm trying to create a Zap that runs daily and deletes all rows from a Google Sheet where the date (entered in column C) is in the past. This is my current test setup, but it doesn't seem to be working correctly.
Step 2 transforms the start date into the previous day by subtracting 1 day.
I use this to compare it with the value in column C of the Google Sheet and, if they match, I delete the row using step 4.
Unfortunately, after a few days where it seemed to work, I now keep finding old rows still there. Also, this "solution" only checks for today - 1 and doesn't delete rows with dates further in the past.
Does anyone have a solution?
Best answer by Troy Tessalone
@BoCcZzZ
Also, info about using DateTime modifiers:
You should add a Filter step between the GSheet steps to make sure the first GSheet step found rounds to delete, otherwise the second GSheet step will have an error.
You can check your Zap Run history to help you troubleshoot by viewing the DATA IN/OUT for each Zap step: https://zapier.com/app/history/
If you are trying to find all rows matching with a date before today, then that is different more advanced logic, which may involve using the GSheets API.
You should add a Filter step between the GSheet steps to make sure the first GSheet step found rounds to delete, otherwise the second GSheet step will have an error.
You can check your Zap Run history to help you troubleshoot by viewing the DATA IN/OUT for each Zap step: https://zapier.com/app/history/
If you are trying to find all rows matching with a date before today, then that is different more advanced logic, which may involve using the GSheets API.
We just wanted to see how everything is going with your Zap. Did Troy's recommendation get the job done? Feel free to reach out if you need further assistance with your Zap. We're glad to address any concerns and assist you.
