Connect Airtable to Google Calendar
Ideas
What you can do with Airtable and Google Calendar
Book appointments into your calendar and log clients in Airtable
Each booking request is placed in a free slot in your calendar and the client is added to your Airtable CRM.
See how it worksBook a kickoff meeting when a client starts onboarding
When a client's status changes to Onboarding in Airtable, a kickoff meeting is booked with them and the link is saved on their record.
See how it worksBook interviews for candidates you shortlist in Airtable
When you mark a candidate as Shortlisted in Airtable, the next free 30-minute slot is booked on your calendar and the candidate is invited.
See how it worksCreate calendar reminders for upcoming Airtable due dates
Purchase orders due in the next week get a reminder in your Google Calendar, without duplicates.
See how it works Your own logicAny other automation you can describe in words
Your own rules, schedule and AI steps with Airtable and Google Calendar, plus any other app. Describe it and your assistant builds it.
See how to build your ownBuild your own
Build any Airtable and Google Calendar automation you can describe
Your own rules
Conditions, thresholds, filters and exceptions, written the way you'd explain them to a colleague.
Any number of apps
One automation can read from one app and update several others. Over 248 apps are ready, and anything with an API works too.
AI where it helps
Summaries, classification, extraction and drafts use ClickRuntime's built-in AI, with no extra key.
On a schedule or on each event
Runs as often as every 5 minutes, or the moment an app sends an event, and keeps track of what it already handled.
For example, ask your assistant
Every 15 minutes, create Google Calendar events for Airtable records in my Shoots table whose Status is Confirmed, and delete the event if the status changes to Cancelled.
Each Friday, compare next week's Google Calendar with my Airtable Bookings table and email me any events missing from Airtable or any records missing from the calendar.
Use cases
Why people connect Airtable and Google Calendar
How the two apps work together
- ClickRuntime checks Airtable every few minutes for records with dates and creates or updates Google Calendar events.
- It can also read calendar events on a schedule and write them into Airtable as records.
- The event ID is stored on the record so later changes update the same event.
Content team puts publish dates on a calendar
Airtable records with a Publish Date can show up as events on a shared Google Calendar. Everyone sees the schedule in their usual calendar.
Recruiter books interviews from a base
When a candidate record gets an Interview Time, a calendar event is created with the interviewer as a guest.
Property manager schedules inspections
Inspection records with a date and address become calendar events. Changes to the date in Airtable move the event.
Studio logs bookings in Airtable
New events on a bookings calendar can be added as Airtable records for reporting and invoicing.
More apps
Airtable, Google Calendar and other apps in one automation
Calendar events plus confirmation email
When an Airtable booking is confirmed, add the Google Calendar event and email the client the details from Gmail.
Daily schedule from Airtable to Slack
Each morning, post today's Airtable events that are on our Google Calendar to #team in Slack.
Zoom meetings for Airtable interviews
When an Airtable interview record is scheduled, create a Zoom meeting and add the link to the calendar event and the record.
Setup
Connect Airtable and Google Calendar once
Airtable
Database / No-code
- In Airtable, go to airtable.com/create/tokens and create a new token with a name you'll recognise.
- Add the scopes the automation needs, such as
data.records:read,data.records:writeandschema.bases:read. - Add the bases or workspaces the token may use.
- Copy the token. Airtable only shows it once.
- In the ClickRuntime dashboard, open Connections & secrets and save the token as a secret for Airtable.
Google Calendar
Calendar / Scheduling
- At console.cloud.google.com, create a project and enable the Google Calendar API.
- Set up the OAuth consent screen: Internal on Google Workspace, or External on a personal account. Add the scope
https://www.googleapis.com/auth/calendar.events(orcalendar). - Create an OAuth client of type Web application with the redirect URI
https://clickruntime.com/oauth/callback. - In the ClickRuntime dashboard, open Connections, choose Google Calendar and enter the client ID and secret, then connect.
- Prefer a service account? Create one with a JSON key, share the calendar with its email with Make changes to events, and save the key as a secret on Connections & secrets.
FAQ
Questions about connecting Airtable and Google Calendar
How does ClickRuntime connect to Airtable?
Will it create the same event twice?
Does it update the calendar when I change a date in Airtable?
Can it invite the client or candidate?
Can it use an Airtable view?
Which time zone does it use?
What happens if I delete the record?
Related pages
Keep exploring
Tell your assistant what Airtable and Google Calendar should do together
Free plan. No credit card.