Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

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?

Hi ​@BoCcZzZ 

For Zap step 2, instead of using AI by Zapier, use this action: Formatter > Date & Time > Format

Formatter steps count as 0 Tasks in Zap Runs.

 

For Zap step 3, how is this field configured? (screenshot)

 

How is your Zap step 4 configured? (screenshots)

Hi ​@Troy Tessalone Thank you!,
Step3:


Step4:

 

​@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.

Filter: https://zapier.com/apps/filter/integrations#help

 

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.

Zap action: GSheets - API Request

GSheets API: https://developers.google.com/workspace/sheets/api/guides/concepts

Hi ​@BoCcZzZ,
 
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.
 
We're looking forward to your response.

thank you ​@Troy Tessalone for your help!

I’ve applied the changes and I’m now monitoring the Zap.

 

So glad Troy was able to help point you in the right direction here, ​@BoCcZzZ—nice work ​@Troy Tessalone! 🙌

Thanks so much for popping back in to mark Troy’s suggestion as the best answer, we really appreciate it.

Feel free to reach back out if you need help with anything else. In the meantime, happy Zapping! ⚡️ 

Terms & Conditions