Schedule a zap to be triggered one week before the first Tuesday of the month
Hi,
I want to create a zap that automatically triggers one week before the first tuesday of the month and this should repeat itself every month.
This zap is then supposed to take data from a google spreadsheet and send out Mails.
Is it possible to do something like this with Schedule and Formatter? If so, then how?
Page 1 / 1
Hey @Revolution2019 ,
The best solution i can suggest is write a Javascript code in Code by Zapier and than use filter in next steps.
Your Zap will be, Scheduler → Check if after a week it is first tuesday (Code by Zapier)→ If Yes (Filter)→ Get data from Google Spreadsheet and Send emails
Note - Consider hiring an expert for this. You can visit expert directory here (Or you can hire me also)
Created this spreadsheet for you in Google Sheets. It has a formula that looks at the first day of the month, and then pulls out the first Tuesday of that month and subtracts 7 days from it to give you one week before the first Tuesday:
Now with Scheduler you can on the daily, check the current Date against the date in 7 day prior column and if they match trigger the rest of your zap.
Hey @Revolution2019
Created this spreadsheet for you in Google Sheets. It has a formula that looks at the first day of the month, and then pulls out the first Tuesday of that month and subtracts 7 days from it to give you one week before the first Tuesday:
Now with Scheduler you can on the daily, check the current Date against the date in 7 day prior column and if they match trigger the rest of your zap.
Hi Aaron,
thanks a lot for this!
The first step is “Schedule: Look up every day”
Problem is that the second step Lookup Spreadsheet Row in Google Sheets says “We had trouble getting a matching spreadsheet row. :-(Error details: Nothing could be found for the search.”
I attached a screenshot, maybe you can help?
Can anyone help with my last question?
Hey @Revolution2019!
From the look of that screenshot it seems that the Lookup Spreadsheet Row step is searching the 7 Days Prior column for Oct 27, 2021:
Does the 7 Days Prior column in the Google Sheet contain the date in that specific format, or is the date formatted differently? If the date format is different then that could well be why it’s having trouble finding a match.
From the look of that screenshot it seems that the Lookup Spreadsheet Row step is searching the 7 Days Prior column for Oct 27, 2021:
Does the 7 Days Prior column in the Google Sheet contain the date in that specific format, or is the date formatted differently? If the date format is different then that could well be why it’s having trouble finding a match.
thanks for your answer! I tried using the formatter and I’m pretty sure that it’s now the same format as in google sheets but the lookup step still doesn’t work. It still says that it can’t find a matching row.
Any other ideas? :(
Hey @Revolution2019!
Hmm, that’s odd. Can you send a screenshot of the row you would have expected the Zap to find? And a screenshot showing the value that it searched for?
Then we can compare the two to see if there are any other differences that are preventing a match from being found. :)