Hi All,

I've scoured a bunch of different posts about people trying to schedule Zaps to run on a schedule (or delay). I'm trying to do something slightly different and can't find a solution. In short, I'm trying to trigger an automation that grabs some analytic info out of a static view - no new records created or no new records in a new view (which is big Airtable/Zapier limitation). I'd like to grab this information every Sunday at 7pm and create an email in Gmail to go out as a weekly report.Β 

If I try to use Zapier and use the Schedule trigger, the only trigger options are 1) a new record, 2) new record in a view or 3) a search for a record can be done. The first 2 options won't work for what I'm trying to do. I can do a search for a record in Airtable but if I have multiple records that I want to report out the same analytics for, Zapier will only return 1 record.

I'm not as well versed in Integromat but I imagine that it's a much better tool for what I'm trying to do.Β 

Any insights would be much appreciated.Β 
i had a battle with zapier delays, was wanting to send 6 messages over a month at 9am on selected days.Β  ended up being a 14 step beast, but got there in the end using a combo of delay until and then delay for.

so if the report is pulled for each record, could you use:
1.Β  trigger on new record
2.Β  delay until sunday 9am each week repeating?

prolly not going to help with existing records tho ☹️

or perhaps create a calendar view of the base, then trigger it on every sunday?Β  or easier than that, create a event in your gmail calendar every sunday that will trigger the zap?

https://zapier.com/apps/airtable/integrations/gmail/14104/send-emails-from-gmail-with-digests-of-new-airtable-record-views
Thanks zachary king, I hadn't thought about the repeating calendar event. The other issue is I want to run this for multiple records and I think the only way to do that is with a little code to iterate through the records in the specific view. I'm wondering if Integromat is better for this but I believe that in order for Integromat to run on a schedule (every Sunday at 7pm) that there needs to be a Last Modified Time column in the record. Unfortunately, I don't know the workaround for the Last Modified Time to be changed without a manual change to the record each week (though reading through some of the documentation, there does seem to be a way).Β 
OK so the other way i thought about was creating a new column with a true/false condition for the day of the month.

then anytime it is the 5th of the month it could trigger the zap, for example.Β  then just hide the column since you don't really want to see it.Β  (or not).
I'm far from a Zapier expert so I'm hoping AndrewJDavison can help out with that angle. I think you can get around the scheduling issue by creating a Google Calendar event and using that as the trigger. Getting multiple records from AirTable seems to be an open issue based on the AirTable community forums but I'd be happy to be corrected on that.

Integromat definitely appears to work better for this. You can use the Tools > Basic Trigger module (just enter a single random value). The nice part is you can set the schedule to be every Sunday at 7pm. Then you use the AirTable > Search Records module to get all records in a table and do whatever you want with those.

Let me know if you decide to go that way and I can help you get started.
HiΒ Courtney BakerΒ 

Yep - you can do this with Integromat as it's able to search and return multiple/all Airtable records and then parse them.

Reach out andrew@luhhu.com if you want help with this.
Thanks Andrew, going to dig in a little deeper and try to figure it out but I'll reach out if I get stuck.
I think you can do it in Airtable with a few changes. Airtable automation has made a huge difference and you will be able to build a timer with a formula.
In one of my use cases - I have a multiselect field and based on what is selected , the schedule DATE/TIME field is calculated .Β  Then another field is computed to see if schedule has reached the current Date/Time and it drops into a view which triggers the automation.Β 

I do not exactly understand your use case, but I think it is doable with Airtable alone. If you want super efficient scheduling tool which can speak to APIs I recommend dashdash. It is very powerful and efficient.
Here is the type of formulas that I have used to automatically trigger automation based on schedule.

DATETIME_FORMAT(SET_TIMEZONE({Schedule}, 'India'), 'YYYY-MM-DD HH:mm') >= DATETIME_FORMAT(SET_TIMEZONE(NOW(), 'India'), 'YYYY-MM-DD HH:mm')

Post a comment

Log in