> For the complete documentation index, see [llms.txt](https://help.botpenguin.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.botpenguin.com/bots/whatsapp-bot/manage-chatflow/components-in-chatflow/integrations-component/google-sheets-integration.md).

# Google Sheets Integration

### What is Google Sheets Integration?

Google Sheets Integration allows you to connect your Google account with the platform so your chatbot can interact with spreadsheets in real time. Once connected, your chatbot can store lead information, save responses, retrieve data during conversations, and update or delete existing records — all automatically.

{% hint style="info" %}
Google Sheets Integration helps automate data management by connecting your chatbot directly with Google Sheets.
{% endhint %}

***

### What's in This Section?

This section is divided into the following areas, based on how you want data sent to your spreadsheet:

| Topic                              | Description                                                                                                    |
| ---------------------------------- | -------------------------------------------------------------------------------------------------------------- |
| Google Sheets - Chat Flow Trigger  | Send, retrieve, update, or delete spreadsheet data through a Google Sheets component inside a Chatflow         |
| Google Sheets - Lead Alert Trigger | Automatically send data to a spreadsheet whenever a new lead is generated, with no Chatflow component required |

***

### Who Should Read This?

* Teams looking to capture and store lead data without manual entry
* Admins managing customer records, registrations, or appointments through spreadsheets
* Builders designing spreadsheet-driven Chatflow workflows

***

### Before You Begin

* A Google account to connect to the platform
* A Google Sheet set up with the columns you want your chatbot data mapped to

***

### Related Articles

* Google Sheets - Chat Flow Trigger
* Google Sheets - Lead Alert Trigger
* Integrations Overview

{% content-ref url="/pages/4NuWcAl6NvuiQbemWNse" %}
[Components in Chatflow](/bots/whatsapp-bot/manage-chatflow/components-in-chatflow.md)
{% endcontent-ref %}

***

### Support

If everything is correct and you are still unable to move forward, write to us at **<support@botpenguin.com>**. We will respond back within 48 business hours.