Are there any automations where I can get the timezone output in a column (EST,PST,MST,CST) based on another column (city input)?
For a deep dive into Airtable time zones, you can check out my training video & sample base here:
This seems like a good start. I mean theoretically I just want to set myself up for a scalable solution so that when new cities are added they are already geocoded for a specific time zone. Are there any blocks that can work with Googles Time Zone API?
We already have that - based on lat/lng, you can always know the local time and use an offset to get the time zone.