Automation: Google Calendar Dynamic Configuration

[Tiffany7]

Hello

I am beginner using airtable.

I would like to make automation when create calendar event. There is configuration place for Google Calendar account in trigger details. Is there any way to do dynamic in that configuration for multiple account.

I would like to do automation for multiple account. 

Thanks in advance.

[Sachin_191]

Airtable doesn’t natively support dynamic switching between multiple Google Calendar accounts within the same automation trigger. However, a workaround is to use Make.com (formerly Integromat) or Zapier, where you can configure multiple Google accounts and set up conditional logic to route events based on specific criteria (like team member, department, or project). This approach keeps your workflow smooth and eliminates the need for manual account selection.

[Tiffany7]

Thank so so much @Sachin_191  for your quick response. I think it will cost if we use use Make.com (formerly Integromat) or Zapier. Is it possible to use something like API?

[Sachin_191]

Absolutely, using APIs would be a smart, cost-effective alternative. Here’s what I can do: I’ll set up custom scripts using Google Calendar and Airtable APIs to manage multiple accounts. This way, we’ll skip any third-party platforms like Make.com or Zapier, and everything will be automated natively.

The plan: 

API Integration to connect Airtable with multiple Google Calendars

Script Logic  to dynamically route events to the right calendar based on parameters like user, project, or department Scheduled triggers (using Google Apps Script or Airtable automation) to sync updates automatically.