I'm attempting to automate my rent roles. I want to create a zapier that will delete all rows at the beginning of the month that have a checkout date in them. My first action is look up spreadsheet rows (advanced) in google sheets. I have check out date as my lookup column and [:nonempty:] as my look up value. For some reason during all test runs it says, “failed to find a spreadsheet rows in Google Sheets. Error from halted execution: nothing could be found for the search.” even though there's rows in my Google sheet with check out dates.
Question
How to automate deleting rows in Google Sheets based on checkout dates
+14- Zapier Orchestrator & Solution Partner
Hi
For us to have more info, post screenshots showing:
- how your GSheet is configured so we can see
- Row 1 headers
- Column with dates and the date format
- how your Zap steps are outlined
- how your Zap steps are configured in the CONFIGURE tab while in EDIT mode
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.