> ## Documentation Index
> Fetch the complete documentation index at: https://docs.chatflows.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Google Sheets and Google Calendar steps

> Save customer replies straight to a Google Sheet, or add them to Google Calendar as an event — automatically, with no manual copy-paste.

Stop copying chat answers into a spreadsheet by hand. The **Integrations** category steps let your chatbot work with Google services. Automatically save customer information to Google Sheets or create Google Calendar events. These steps run in the background and don't send any message to the customer.

> [!NOTE]
>
> Both steps need a connected Google account. Set one up first in [Google Accounts](https://docs.chatflows.io/settings/google-accounts.md).

## Google Sheets

**What it does.** Adds a new row to a Google Sheet each time the flow reaches this step.

**When to use it.** Use it to automatically save **leads**, **orders**, **return requests**, **survey responses**, or any other customer information in Google Sheets.

**How to set it up.**

**1. Choose the Google Account (required)**

Pick a connected account, or click **Connect another account** to add one.

**2. Pick the Spreadsheet (required)**

Your spreadsheets load automatically. Choose the one you want to write into, or type a name in the box below the list and click **Create** to make a new one on the spot.

**3. Set the Sheet / Tab Name**

Optional. The tab within that spreadsheet — leave it as `Sheet1` unless you keep your data on a differently named tab.

**4. Map your Column Values (required)**

Click **Add Column** for each one. Give it a header, then set the value — type **@** to insert a [merge field](https://docs.chatflows.io/messaging/merge-fields.md) such as the contact's name or an answer you collected earlier. Add at least one column, or the step has nothing to write.

![Google Sheets settings with a Google Account field required and highlighted in red, a Sheet / Tab Name field set to Sheet1, and a Column Values section prompting you to add at least one column](https://mintcdn.com/chatflows-docs/wJMcyFv6gdBNOsVY/automation/img/integrations/google-sheets-settings.png?fit=max\&auto=format\&n=wJMcyFv6gdBNOsVY\&q=85\&s=d79903f6e640a82654db59f2b1897f01)

**Example**

A restaurant logs every booking taken by the chatbot:

| Column header | Value |
| - | - |
| Name | \{\{contact.first\_name}} \{\{contact.last\_name}} |
| Phone | \{\{contact.phone}} |
| Date | \{\{vars.booking\_date}} |
| Party size | \{\{vars.party\_size}} |

> [!TIP]
>
> Add this step last, after all your questions — otherwise the answers that come after it will be missing.

***

## Calendar Event

**What it does.** Creates an event in your Google Calendar using details the customer gave you.

**When to use it.** Callbacks, site visits, consultations, demos — anything where a time agreed on WhatsApp should also appear in your calendar.

**How to set it up.**

**1. Choose the Google Account (required)**

Pick the connected account, or click **Connect another account** to add one.

**2. Choose the Calendar**

Optional. Pick which of that account's calendars the event should go into, or create a new one by name. Leave it blank and the event goes to your primary calendar.

**3. Write the Event Title (required)**

For example, `Call with {'{{contact.first_name}}'}`.

**4. Set the Start Date (required)**

Type a date in any common format — `2026-06-04`, `04/06/2026`, `June 4` — or press **@** to use an answer the customer gave earlier. It's converted into a proper date for you.

**5. Add the optional details**

**Start Time**, **End Date**, **End Time**, **Location**, **Attendee Email** and **Description** are all optional, and **@** works in any of them. Leave **End Time** blank and the event runs for an hour from the start. Fill in **Attendee Email** and the customer is sent a calendar invite.

![Calendar Event settings with Google Account, Event Title, and Start Date fields all required and highlighted in red, and a tip explaining that typing @ inserts a merge field or an earlier Ask Question reply](https://mintcdn.com/chatflows-docs/wJMcyFv6gdBNOsVY/automation/img/integrations/calendar-event-settings.png?fit=max\&auto=format\&n=wJMcyFv6gdBNOsVY\&q=85\&s=3aa4c92a1eef33e96c48ac5b7f3c905c)

![Calendar Event settings continued, showing the optional Start Time, End Date, End Time, Location, Attendee Email, and Description fields](https://mintcdn.com/chatflows-docs/wJMcyFv6gdBNOsVY/automation/img/integrations/calendar-event-settings-optional.png?fit=max\&auto=format\&n=wJMcyFv6gdBNOsVY\&q=85\&s=a3ab4bc23eaf225b05517e813c65fe02)

**Example**

A clinic turns a WhatsApp booking into a calendar entry:

> **Title:** Consultation — \{\{contact.first\_name}} \{\{contact.last\_name}}
> **Start Date:** \{\{vars.booking\_date}}
> **Start Time:** \{\{vars.booking\_time}}
> **Location:** Green Valley Clinic, Room 3
> **Attendee Email:** \{\{contact.email}}
> **Description:** Booked through WhatsApp. Phone: \{\{contact.phone}}

The doctor sees it in their calendar, and because **Attendee Email** was filled in, the patient gets a Google invite by email too.

***

## A worked example

A consultancy books discovery calls end to end:

1. **Start Trigger** — When message contains `book`, `call`, `consultation`.
2. **Ask Question** (Text) — "What's your full name?" → `client_name`
3. **Ask Email** — "What's your email?" → `email`
4. **Ask Question** (Date) — "Which day suits you?" → `booking_date`
5. **Ask Question** (Text) — "And what time?" → `booking_time`
6. **Update Contact** — save the name and email onto the contact record.
7. **Calendar Event** — create the event from those answers.
8. **Google Sheets** — log the same details as a row for the sales team.
9. **Text Message** — "You're booked in for \{\{vars.booking\_date}} at \{\{vars.booking\_time}}. A calendar invite is on its way to \{\{vars.email}}."

![The finished booking flow — a Start Trigger leading through Ask Question, Ask Email, and two more Ask Question steps, into a Google Sheets step, a Calendar Event step, and a final Text Message confirming the booking](https://mintcdn.com/chatflows-docs/wJMcyFv6gdBNOsVY/automation/img/integrations/worked-example-booking-flow.png?fit=max\&auto=format\&n=wJMcyFv6gdBNOsVY\&q=85\&s=4d680049a9260edd438ba26a7b4d1da5)

## What's next

> [card] [Google Accounts](https://docs.chatflows.io/settings/google-accounts.md)
>
> Connect the Google account these steps use.

> [card] [Merge Fields](https://docs.chatflows.io/messaging/merge-fields.md)
>
> Use saved answers in any field by typing @.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.