How to Turn Form Submissions into Google Calendar Events

Turn every booking, appointment, or scheduled request from your Cognito Forms submissions into a real Google Calendar event — automatically, with no copying and pasting required.

Build Time & Skill

20-30 min

Intermediate

What you'll learn

How to connect Cognito Forms to Google Calendar through Zapier or Make so form submissions automatically create, update, and delete calendar events for bookings and appointments.

Turn Form Submissions into Google Calendar Events Automatically with Cognito Forms

When customers book a time with you through an online form, the last thing you want is to manually add that appointment to your calendar. By connecting Cognito Forms to Google Calendar, every form submission becomes a real, invite-ready calendar event the moment someone hits submit. Updates and cancellations from your customers can flow through, too.

This guide is for service-based teams that book time with clients, like consultants, coaches, healthcare providers, agencies, and anyone running meetings, sessions, or appointments. You’ll build a booking form in Cognito Forms, then use Zapier or Make to push entries into Google Calendar as fully detailed events.

This setup gives you the ability to:

  • Avoid manual data-entry errors. Event details are transferred directly from Cognito Forms to Google Calendar, eliminating the risk of typos and missed information.
  • Send calendar invitations automatically. As soon as someone submits your form, you can send them a calendar invite with reminders and an optional Google Meet link.
  • Keep your calendar up-to-date automatically. When an appointment is booked, rescheduled, or canceled through your form, Google Calendar updates automatically to match.
  • Reclaim time for actual client work. Replace hours of manual calendar management each week with a workflow that runs itself.

Key Takeaways

  • Cognito Forms syncs with Google Calendar via Zapier or Make, turning form submissions into calendar events automatically.
  • A calculation field formats Date and Time fields into the yyyy-MM-ddTHH:mm format Google Calendar requires.
  • Automation handles the full cycle: create, update, and delete calendar events as appointments are booked, rescheduled, or canceled.
  • A consistent event name (e.g., “Consultation with [Client Name]”) lets each automation find the right calendar event.
  • The result: no manual entry, automatic customer invites, and a calendar that stays in sync.

In Cognito Forms: Build a Form For Customers to Book a Time

Before any automation can run, your form needs to capture the right pieces of information: who the customer is, when they want to meet, and how long the event should be. The setup below gives Zapier or Make the data they need to create a clean, accurate calendar event.

Animated GIF showing how to set up your form with date and time fields

Step 1: Create your form with Date and Time fields

Start by building (or opening) the form customers will use to book time with you. On your Build page, add the basic fields you’ll need to populate the event:

  1. Add Name and Email fields to capture the customer’s information.
  2. Add a Date field for the booking date.
  3. Add a Time field for the appointment’s start time. Name this “Choose a time,” or something similar.
  4. Add a second Time field for the appointments end time. Name this “End Time,” or something similar.
  5. Prefill the “End Time” field with a calculation that adds the amount of time needed for the appointment onto your “Start Time” field. Here are three calculations for popular booking durations:
    • 30 minutes: ChooseATime.AddMinutes(15)
    • 1 hour: ChooseATime.AddHours(1)
    • 2 hours: ChooseATime.AddHours(2)
  6. Set your “End Time” field’s Show This Field setting to Never or For Roles > Internal, if desired.
  7. Set the “End Time” field to Read Only > Always.
  8. Add any additional fields you need, such as phone number, appointment reason, location preference, or notes, depending on the information you want your calendar event to include.

Want to prevent customers from selecting the same appointment time?

You can do this with Quantity Limits. Learn more about setting up limited time slots with these guides:


Step 2: Prepare your Date and Time fields for Google Calendar

Google Calendar needs a full start date and time and an end date and time in a single value to create an event. Cognito Forms’ Calculations let you combine your separate Date and Time fields into the format the calendar expects.

Screenshot of two Cognito Forms Calculation fields

Start time calculation

  1. Add a Calculation field labeled Start Time Calculation, with Type set to Text.
  2. In the calculation, set it to: =StartDate.ToString("yyyy-MM-dd") + "T" + StartTime.ToString("HH:mm")
    • This calculation combines your Date and Time fields while also converting them to a text format that matches how Google Calendar’s data is formatted.
    • Be sure to replace ‘StartDate’ and ‘StartTime’ to match the field names on your form.
  3. Set the field’s Show This Field setting to Never or For Roles > Internal. This ensures the field doesn’t display to the customer filling out the form.

End time calculation

  1. Add a second Calculation field labeled End Time Calculation, also set to Text.
  2. In the calculation, set it to: =StartDate.ToString("yyyy-MM-dd") + "T" + EndTime.ToString("HH:mm")
    • This calculation combines your Start Date and End Time fields while also converting them to a text format that matches how Google Calendar’s data is formatted.
    • Be sure to replace ‘StartDate’ and ‘EndTime’ to match the field names on your form.
  3. Set the field’s Show This Field setting to Never or For Roles > Internal. This hides the field from the customer filling out the form.

Step 3: Customize your form’s Workflow (optional)

Customers can cancel their appointment time directly from their form submission, using Workflow Actions and Workflow Links in Cognito Forms. This step will set your form up to automatically cancel the Google Calendar event associated with the customer’s submission.

Note: This step only applies if you are wanting to automatically delete events when customers click a “Cancel” Workflow Action button.

Setup a Status and Action

Animated GIF showing how to add a new Action button and Status to your form

Setup steps:

  1. Open your form’s Workflow settings.
  2. Add a new Status for canceled bookings — for example, Canceled.
  3. Add a Workflow Action button (e.g., labeled Cancel Appointment) that moves the entry to that status when clicked.
  4. Decide who can see the button and when, using the Allow Action settings. Assuming you want customers to be able to cancel their own appointment, set this logic to: When > Entry.Role is one of Public, Internal AND Entry.Status is "Submitted"
    • This lets customers cancel the appointment, only when it’s been scheduled. It also lets your team cancel the appointment on their end (for situations like if the customer called to cancel).

Let customers change their appointment time on their own

Animated GIF showing how to add a Workflow Link to a custom email notification in COgnito Forms

Setup steps:

  1. Open your “Submit” Action and click + Add Email.
  2. Set up a custom email notification to send to the customer’s email address. Customize the subject and message of the email for your needs. Use the Insert Field option to prefill form data into the email’s content.
  3. Click the Share Workflow Link and select the Public Role. Adjust the Workflow Button text, if desired.
    • This gives the customer a button to return to their entry and self-cancel their appointment using the Action available to them on the form.

In Zapier or Make: Set up your automation(s)

With your form built and your Calculation fields ready, the next step is to connect Cognito Forms to Google Calendar using either Zapier or Make. Both tools work well, so the choice depends on your personal preference. Zapier tends to be more beginner-friendly, while Make gives you finer control and is often more cost-effective for higher-volume workflows. Pick whichever you already use or prefer and follow that path through one or all of the three scenarios below.

Create a new calendar event based on a form

This is the core automation: every time a customer submits your form, a new Google Calendar event is created with their booking details. Set this up first; the Update and Delete automations below rely on the event name pattern you choose here.

How to set this up with Zapier

1. Create a new Zap in Zapier.

2. Choose Cognito Forms  as the Trigger App and New Entry  as the Trigger Event.

3. Connect your Cognito Forms account, if you haven't already.

4. Select the Form you want to sync.

5. Test the connection with a recent form entry.

animated GIF showing how to add a trigger in Zapier to watch new entries on a specific form in Cognito Forms

1. Create a new Zap in Zapier.

2. Choose Cognito Forms  as the Trigger App and New Entry  as the Trigger Event.

3. Connect your Cognito Forms account, if you haven't already.

4. Select the Form you want to sync.

5. Test the connection with a recent form entry.

animated GIF showing how to add a trigger in Zapier to watch new entries on a specific form in Cognito Forms

How to set this up with Make

1. Create a new Scenario.

2. Add Cognito Forms  to the first module.

3. Select the Trigger Watch New Entries .

4. Create a Webhook and connect your Cognito Forms account.

5. Choose the Form you want this Scenario to watch.

animated GIF showing how to add a trigger module in Make to watch new entries on a specific form in Cognito Forms

1. Create a new Scenario.

2. Add Cognito Forms  to the first module.

3. Select the Trigger Watch New Entries .

4. Create a Webhook and connect your Cognito Forms account.

5. Choose the Form you want this Scenario to watch.

animated GIF showing how to add a trigger module in Make to watch new entries on a specific form in Cognito Forms


Update a calendar event based on changes made to a form

When a customer reschedules or your team edits an entry internally, your calendar should reflect the new time without anyone moving the event manually. This automation watches for changes on existing entries, finds the matching calendar event, and updates it in place.

Quick Tip

For this automation to find the right event later, your Create automation needs to set a predictable. For example, "Consultation with Client Name" or "Form Name for Company". Use the same name pattern in both automations so the lookup/search step can match them.

How to set this up with Zapier

1. Create a new Zap in Zapier.

2. Choose Cognito Forms  as the Trigger App and Update Entry  as the Trigger Event.

3. Connect your Cognito Forms account, if you haven't already.

4. Select the Form you want to sync.

5. Test the connection with a recent form entry.

Animated GIF showing how to set up a Trigger step connected to Cognito Forms with the Update Entry Trigger

1. Create a new Zap in Zapier.

2. Choose Cognito Forms  as the Trigger App and Update Entry  as the Trigger Event.

3. Connect your Cognito Forms account, if you haven't already.

4. Select the Form you want to sync.

5. Test the connection with a recent form entry.

Animated GIF showing how to set up a Trigger step connected to Cognito Forms with the Update Entry Trigger

How to set this up with Make

1. Create a new Scenario.

2. Add Cognito Forms  to the first module.

3. Select the Trigger Watch Updates .

4. Create a Webhook and connect your Cognito Forms account, if you haven't already.

5. Choose the Form you want this Scenario to watch.

Animated GIF showing how to add a Trigger Module connected to Cognito Forms with the Watch Updates trigger

1. Create a new Scenario.

2. Add Cognito Forms  to the first module.

3. Select the Trigger Watch Updates .

4. Create a Webhook and connect your Cognito Forms account, if you haven't already.

5. Choose the Form you want this Scenario to watch.

Animated GIF showing how to add a Trigger Module connected to Cognito Forms with the Watch Updates trigger


Delete a calendar event when a customer clicks a “Cancel” Workflow Action

If you set up the optional cancellation Workflow Action in Step 3, this third automation closes the loop. When a customer cancels through your form, the automation checks only for entries in the “Canceled” Status. Then, the matching Google Calendar event is removed, so you never show up to a meeting that isn’t happening.

The Filter step in Zapier (and the equivalent setup in Make) ensures this automation only fires on canceled entries. Without it, every form update would attempt to delete the event, including harmless edits like a corrected phone number.

How to set this up with Zapier

1. Create a new Zap in Zapier.

2. Choose Cognito Forms  as the Trigger App and Update Entry  as the Trigger Event.

3. Connect your Cognito Forms account, if you haven't already.

4. Select the Form you want to sync.

5. Test the connection with a recent form entry.

Animated GIF showing how to set up a Trigger step connected to Cognito Forms with the Update Entry Trigger

1. Create a new Zap in Zapier.

2. Choose Cognito Forms  as the Trigger App and Update Entry  as the Trigger Event.

3. Connect your Cognito Forms account, if you haven't already.

4. Select the Form you want to sync.

5. Test the connection with a recent form entry.

Animated GIF showing how to set up a Trigger step connected to Cognito Forms with the Update Entry Trigger

How to set this up with Make

1. Create a new Scenario.

2. Add Cognito Forms  to the first module.

3. Select the Trigger Watch Updates .

4. Create a Webhook and connect your Cognito Forms account, if you haven't already.

5. Choose the Form you want this Scenario to watch.

Animated GIF showing how to add a Trigger Module connected to Cognito Forms with the Watch Updates trigger

1. Create a new Scenario.

2. Add Cognito Forms  to the first module.

3. Select the Trigger Watch Updates .

4. Create a Webhook and connect your Cognito Forms account, if you haven't already.

5. Choose the Form you want this Scenario to watch.

Animated GIF showing how to add a Trigger Module connected to Cognito Forms with the Watch Updates trigger


After Your Integration Is Live: Take It Further

Once your form-to-calendar automation is running, a few Cognito Forms features can make your booking workflow even more powerful:

  • Ask the right questions at the right time. With Conditional Logic, you can show or hide form fields based on the type of appointment a customer selects. This means a 15-minute discovery call doesn’t ask the same intake questions as a one-hour consultation.
  • Collect deposits, booking fees, or full payments when customers book. Use one of our payment integrations so the booking and payment collection happen in the same flow, without leaving your form.
  • Send customers a custom confirmation email the moment they book, with the appointment details and a personal note from you. You can also set up internal notifications, so your team is alerted to every new booking.
  • Give returning customers a branded portal where they can view past bookings, reschedule, or request a new appointment without having to start over each time.

Automate Your Booking and Scheduling Workflow Today

Connecting Cognito Forms to Google Calendar removes one of the most error-prone, time-consuming parts of running a booking business. This setup replaces it with an automation that’s simple and works seamlessly. Build your form, set up your calculation fields, connect Zapier or Make, and your team will never have to copy a booking into a calendar again.

Connect Cognito Forms to Google Calendar today.

Connect Cognito Forms to Google Calendar today.


FAQ