Hey everyone,
I’ve been working on what should be a really simple Zap for 3 weeks now and I can’t get it to work. I have two issues.
🛠️ Zapier Troubleshooting Notes
Issue 1: Airtable Trigger Won’t Stay on “New Record”
-
In my Zap, the first step uses Airtable and is stuck on “New and Updated Record.”
-
I want it to trigger only on “New Record,” but every time I select it and save, it reverts back to “New and Updated Record.”
-
I’ve already tried the following:
-
Selected “New Record” again and saved it.
-
Disconnected and reconnected Airtable.
-
Changed the app temporarily, then came back to Airtable.
-
Refreshed fields and retried setup.
-
-
Despite all of this, the trigger won’t update, and it’s causing a looping issue in the Zap.
Issue 2: Emails Are Sending at Midnight Instead of Scheduled Times
-
I’m trying to automate email sends at specific Eastern times: 7:30 AM, 11:30 AM, and 4:30 PM.
-
However, emails are going out at midnight instead.
-
Airtable setup:
-
Date fields are configured to include time.
-
Time zone is set to Eastern (America/New_York).
-
"Use the same time zone for all collaborators" is enabled.
-
-
Zapier setup:
-
I use a “Format Date/Time” step set to Eastern.
-
Then I run JavaScript that only allows sending between 7:30 AM and 6:30 PM, weekdays only.
-
A “Delay Until” step is based on the JavaScript output.
-
-
Even with all of that in place, emails are still being sent at the wrong time
Any help is greatly appreciated! I’ve run out of ideas to try.