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.

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?

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.