Schedule Emails by Recipient Time Zone in Airtable (Intermediate Pt. 2)

Intermediate Email Automation: Part 2

Send the right email at the right time, in every recipient's local time zone. In Part 2 of the Intermediate Email Automation series, Kris from Optimize IS shows you how to build time zone-aware email scheduling in Airtable using formula fields and a single hourly automation.

🔗 Need this built for your team? → https://www.optimizeis.com/

▶️ WATCH PART 1 FIRST: https://youtu.be/t4Uwu4vzxTw

–

⏱️ TIMESTAMPS
00:00 Intro — what we're building
00:45 Adding a time zone field to the People table
01:30 Rolling up recipient time zone into Email Logs
02:00 New "Scheduled" status + send date/time fields
02:45 Combining date + time into a single formula
03:30 Calculating offset from GMT
04:30 Computing the actual GMT send time
05:15 Building the GMT Time Code formula
06:00 Hourly automation: scheduled trigger + script
07:30 Finding records that match the current hour
08:30 Looping through results to flip status to "send"
09:30 Live test — confirming the send works
10:15 Auto-queuing onboarding emails on new hire creation
12:00 Up next: HTML email sending

✅ WHAT YOU'LL LEARN
- Store and roll up recipient time zones from a People table
- Calculate GMT offset dynamically based on each recipient
- Convert local send times into GMT for accurate scheduling
- Build a single hourly automation that finds & sends matching records
- Auto-queue onboarding sequences when new hires are added

💡 WHY THIS MATTERS
Everyone gets your email at 9 AM their time, not yours. Critical for global teams, onboarding sequences, and customer comms across regions.

▶️ NEXT IN THE SERIES
Part 3: Sending beautiful dynamic HTML emails
https://youtu.be/GMf0xMernVM

–

👋 ABOUT OPTIMIZE IS
2x Airtable Partner of the Year. 🏆
Custom Airtable systems built to fit your process.

🔔 SUBSCRIBE for more Airtable tutorials
👍 LIKE if this saved you setup time
💬 COMMENT what you'd schedule next

–

#Airtable #EmailAutomation #TimeZones #NoCode #AirtableTutorial

Видео Schedule Emails by Recipient Time Zone in Airtable (Intermediate Pt. 2) канала Optimize Information Systems