> 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

This section covers how to connect your chatbot to Google Sheets to automate data storage, retrieval, and management — for teams looking to replace manual spreadsheet entry with automated chatbot work

### 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 %}

***

### Before You Begin

* Customer must have integrated Google Sheets into their account.
* To integrate Google sheet, use the following article

{% content-ref url="/pages/HSjMxnM5OvBCYTibkdSU" %}
[Integrate BotPenguin with Google Sheets](/bots/whatsapp-bot/3rd-party-apps-integrations/botpenguin-integrations/integrate-botpenguin-with-google-sheets.md)
{% endcontent-ref %}

***

### 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

***

### 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.