> For the complete documentation index, see [llms.txt](https://docs.ownchat.app/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.ownchat.app/bot/connections/google-sheet.md).

# Google Sheet

Google Sheets integration allows businesses to connect their Google Sheets account with Ownchat and manage spreadsheet data through automation workflows. \
\
It helps businesses automatically add new customer records, update existing information, and retrieve specific data from Google Sheets based on configured conditions. This reduces manual data entry and keeps customer information organised and up to date.

| **Action**                                | **Definition**                                                                                                                                                                                                           |
| ----------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| **Add New Row**                           | Adds a new row to the selected Google Sheet by inserting the values collected during the chatbot conversation or automation workflow into the corresponding columns.                                                     |
| **Update Row**                            | Searches for an existing record using the configured matching condition and updates the required column values without creating a new row.                                                                               |
| **Fetch the Row Value**                   | Searches the selected Google Sheet based on a specified condition and retrieves the details from the matching row. The retrieved values can be used in subsequent automation steps.                                      |
| **Fetch the First 10 Matched Row Values** | Searches the selected Google Sheet and retrieves up to the first 10 rows that match the configured conditions. The retrieved records can be used for displaying or processing multiple matching results in the workflow. |

**Example Use Case:**

A business can collect customer details through WhatsApp, automatically save them in Google Sheets, update existing customer records, and retrieve customer or product information whenever required through Ownchat automation.
