Developer & DevOps

Connect Google Calendar with Airtable

92 nodes 214 111 Webhook
Download

Workflow Description

An automation template that synchronizes Google Calendar events with Airtable using a webhook trigger. The workflow retrieves calendar data, processes it through conditional logic, and automatically creates or updates records in Airtable to maintain data consistency across platforms.

How it works

  1. 1.Receive webhook request and identify event type
  2. 2.Fetch event details from Google Calendar
  3. 3.Process data and apply conditional logic
  4. 4.Create or update records in Airtable table
  5. 5.Send webhook confirmation response

Use cases

  • Automatically update Airtable records when new events are added to Google Calendar
  • Sync event modifications between both platforms in real-time
  • Generate project records in Airtable linked to scheduled meetings

Requirements

  • Active Google Calendar account with API access
  • Airtable base with predefined field structure
  • API keys or authentication tokens configured
  • Basic understanding of webhook and JSON data structures

Service Value

Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.

Apps Used

Google Calendar Airtable

Details

Trigger Webhook
Nodes 92
Apps 2
Views 214
Downloads 111

How to Use

  1. 1.Click "Download Template"
  2. 2.Open your n8n dashboard
  3. 3.Go to Workflows > Import from File
  4. 4.Select downloaded file and configure credentials

Nodes Used (92)

/

Input Arguments

Set

#1

Format response

Item Lists

#2

Sort

Item Lists

#3

Available Start Times & Ranges

Code

#4

Flatten Slots

Code

#5

Enrich Date

Code

#6

Build Response Payload

Set

#7

Booking Payload

Set

#8

Success Response

Set

#9

Add Friendly Error

Code

#10

Error Response

Set

#11

Escape Json

Code

#12

Has all information

If

#13

Respond with Error

Webhook

#14

Build Error Response Payload

Set

#15

Build Error Response Payload2

Set

#16

Sticky Note

Sticky Note

#17

Sticky Note1

Sticky Note

#18

Sticky Note2

Sticky Note

#19

Sticky Note3

Sticky Note

#20

Sticky Note4

Sticky Note

#21

Sticky Note5

Sticky Note

#22

Sticky Note BookSlot Webhook

Sticky Note

#23

Sticky Note BookSlot Check

Sticky Note

#24

Sticky Note BookSlot Error

Sticky Note

#25

Sticky Note BookSlot GCal

Sticky Note

#26

Sticky Note BookSlot Error Handle

Sticky Note

#27

Sticky Note BookSlot Response

Sticky Note

#28

Sticky Note BookSlot Airtable

Sticky Note

#29

Sticky Note CancelSlot Webhook

Sticky Note

#30

Sticky Note CancelSlot Check

Sticky Note

#31

Sticky Note CancelSlot Error

Sticky Note

#32

Sticky Note CancelSlot Search

Sticky Note

#33

Sticky Note CancelSlot GCal Delete

Sticky Note

#34

Sticky Note CancelSlot Airtable Update

Sticky Note

#35

Sticky Note CancelSlot Response

Sticky Note

#36

Sticky Note UpdateSlot Webhook

Sticky Note

#37

Sticky Note UpdateSlot Check

Sticky Note

#38

Sticky Note UpdateSlot Error

Sticky Note

#39

Sticky Note UpdateSlot Search

Sticky Note

#40

Sticky Note UpdateSlot GCal Update

Sticky Note

#41

Sticky Note UpdateSlot Airtable Update

Sticky Note

#42

Sticky Note UpdateSlot Response

Sticky Note

#43

Sticky Note CallResults Webhook

Sticky Note

#44

Sticky Note CallResults Airtable

Sticky Note

#45

Getslot_tool

Webhook

#46

Check Availability

Google Calendar

#47

Response

Webhook

#48

Check if time is available or not

If

#49

Time available (true) & Call_id

Set

#50

Get All Calendar Events

Google Calendar

#51

Extract start, end and name

Set

#52

Convert into Json format for Vapi

Code

#53

Response to Vapi

Webhook

#54

bookslots_tool

Webhook

#55

Input Arguments from booking tools

Set

#56

Convert time to CST America / Chicago

Code

#57

Create Event

Google Calendar

#58

Respond to Vapi

Webhook

#59

If the booking is confirmed then true

If

#60

Information to be Saved in Airtable

Set

#61

Logs the confirmed booking details

Airtable

#62

Updateslots_tool

Webhook

#63

Input Arguments from updateslot tool

Set

#64

Checks if required info is provided.

If

#65

Finds original appointment

Airtable

#66

Response with Error

Webhook

#67

Update Event

Google Calendar

#68

Updates Airtable record

Airtable

#69

Response & call_id

Set

#70

Respond to Vapi about Updating slots

Webhook

#71

CancelSlots_tool

Webhook

#72

Input Arguments from cancelslot tool

Set

#73

Checks if required info is provided for cancelation

If

#74

Finds the appointment record

Airtable

#75

Build Error Response

Set

#76

Respond with Error to Vapi

Webhook

#77

Delete Event

Google Calendar

#78

Update Airtable record

Airtable

#79

Call_id & Response

Set

#80

Respond to Vapi about cancelation

Webhook

#81

call_results

Webhook

#82

All Input Arguments

Set

#83

Save all information

Airtable

#84

Sticky Note7

Sticky Note

#85

Sticky Note15

Sticky Note

#86

Sticky Note16

Sticky Note

#87

Sticky Note17

Sticky Note

#88

Sticky Note18

Sticky Note

#89

Sticky Note19

Sticky Note

#90

Sticky Note9

Sticky Note

#91

Sticky Note12

Sticky Note

#92

Similar Templates

Automated workflow

2 nodes

Form with dynamic dropdown field

16 nodes

Connect Mattermost with Cron andGoogle Sheets

5 nodes

Automated workflow

6 nodes

Organize Saved Links from Raindrop Automatically

4 nodes

Automated workflow

4 nodes