Google Calendar
Airtable
zapier

An automated workflow using zapier

Connects Google Calendar + Airtable

Import new events from Google Calendar into Airtable

About this workflow template

This automation scenario allows you to connect Google Calendar and Airtable

It can be build using Zapier, a no-code workflow automation tool. Zapier allows you to create automated scripts using a simple drag-and-drop interface for non-technical users. This is a ready-made scenario, but it can be customized by adding more apps, actions, filters or branches.

Google Calendar and Airtable can also be integrated using automation tools other than zapier:

Diagram

Import new events from Google Calendar into Airtable
Workflow diagram: Google Calendar + Airtable integration

How it works?

When this trigger fires in Google Calendar

Google Calendar

New Event in Google Calendar

Triggers when an event is created.

Then this action happens in Airtable

Airtable

Create Record in Airtable

Creates a new record with auto-populating fields.

How to set up this workflow

This guide contains information on how to set up an automatic workflow that allows to Import new events from Google Calendar into Airtable.

Part I

Configure Applications

First, we need to connect Google Calendar and Airtable to Zapier.

  • Create Zapier account.

    Create Zapier account.

    Create Zapier account if you don't have one.

  • Connect Google Calendar to Zapier.

    Connect Google Calendar to Zapier.

    Give Zapier access to your Google Calendar account, using Google Calendar credentials.

  • Connect Airtable to Zapier.

    Connect Airtable to Zapier.

    Give Zapier access to your Airtable account, using Airtable credentials.

Part II

Build an integration workflow

Next, we need to create a workflow automation scenario using graphical no-code web interface of Zapier.

  • Set up a Trigger action for Google Calendar

    Set up a Trigger action for Google Calendar

    Choose the following trigger: New Event (Triggers when an event is created.).

  • Then set up an Action for Airtable

    Then set up an Action for Airtable

    Choose this action: Create Record (Creates a new record with auto-populating fields.).

Part III

Test and Publish

Finally, we need to test this automation and publish it.

  • Customize data flow

    Customize data flow

    Configure the data that is exchanged between Google Calendar and Airtable.

  • Test the workflow and turn it on for production use

    Test the workflow and turn it on for production use

    Test your scenario and publish to production. Now you have an automatic workflow, that will Import new events from Google Calendar into Airtable!

Supported triggers and actions

  • Google Calendar

    New event

    Triggers when an event is created.

    zapierpabbly-connectalbato
    triggerbyzapierpabbly-connectalbato
  • Google Calendar

    Event start

    Triggers when a specified amount of time before an event starts.

    zapierautomateio
    triggerbyzapierautomateio
  • Google Calendar

    New or updated event

    Triggers when an event is created or updated (except when it's cancelled).

    zapier
    triggerbyzapier
  • Google Calendar

    Any event starts

    This Trigger fires a set number of minutes before the starting time of any event on your Google Calendar. Note: The time in the ingredient will be based on the timezone set in Google Calendar.

    ifttt
    triggerbyifttt
  • Google Calendar

    Event from search starts

    This Trigger fires a set number of minutes before the starting time of an event on your Calendar that contains a specific keyword or phrase in the event’s Title, Description, or Location. Ingredient will be based on the zone set in Google.

    ifttt
    triggerbyifttt
  • Google Calendar

    New event added

    This Trigger fires every time a new event is added to your Google Calendar. Note: The time in the ingredient will be based on the timezone set in Google Calendar.

    ifttt
    triggerbyifttt
  • Airtable

    Update record

    Update the values of specific cells in an Airtable record.

    zapierintegratelypabbly-connectpipedreamalbato
    actionbyzapierintegratelypabbly-connectpipedreamalbato
  • Airtable

    Get record

    Get a specific record

    pabbly-connectpipedream
    actionbypabbly-connectpipedream
  • Airtable

    Delete record

    Delete specific record by ID.

    pabbly-connectpipedreamintegratelyzapier
    actionbypabbly-connectpipedreamintegratelyzapier
  • Airtable

    Create single record

    Create single record

    pipedream
    actionbypipedream
  • Airtable

    Create multiple records

    Create multiple records

    pipedream
    actionbypipedream
  • Airtable

    List records

    List records

    pipedream
    actionbypipedream

Apps you need

Google Calendar

Google Calendar

Calendar

A time management and scheduling tool for efficient day-to-day organization

Google Calendar, the free time-management web application, simplifies scheduling and organizing your daily events. Easily manage and share your schedule with customizable notifications, ensuring you stay on top of your commitments.

Airtable

Airtable

Spreadsheets

A no-code platform for building collaborative apps using spreadsheet-database hybrid as a data-layer

Airtable is a modern and flexible low-code platform that combines the power of a full database with the ease of use of a spreadsheet. With native mobile and desktop apps, Airtable offers a variety of templates for easy-to-use and customizable workflows, providing powerful features such as file attachments, kanban card stacks, calendars, and reporting. Link related content intelligently, configure the perfect view, and integrate with hundreds of your favorite apps and services.

Zapier

Zapier

Automation Platforms

No-code automation service

Zapier simplifies busy people's lives by automating web app data transfers, reducing tedious tasks, and allowing teams to collaborate effortlessly. With over 5,000 popular apps connected, it's never been easier to streamline your workflow.