> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://help.encharge.io/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# Google Sheets Integration Overview

With this integration, you can trigger automation when a new Google Sheet row is added and add new rows to a selected sheet.

Note: You can only select spreadsheets that you have created via Encharge.

# How to connect Google Sheets

In your Encharge account, go to Settings, then Apps.  
![](https://storage.crisp.chat/users/helpdesk/website/93be1388ec969800/1c3a0a80-3bff-484a-890f-f6d4e7_17q42kj.png)

Click on Google Sheets and follow the integration wizard.

## 1. Choose Google Account

![](https://storage.crisp.chat/users/helpdesk/website/d42d0e8c24cea000/9d40b173-c1a0-4ee6-8490-c4200e_1knz3jt.png)
You'll be prompted to Select a google account.

## 2. Approve connection

![](https://storage.crisp.chat/users/helpdesk/website/dd9ad9c5544b0800/538c2408-0405-4c42-a3cf-5fbb3b_1du8i1i.png)
Click Continue and you'll be prompted to approve the integration. Click Allow and the integration will be completed.

![](https://storage.crisp.chat/users/helpdesk/website/7ecbe1b4e07b0000/8179a635-8936-4bdf-8f81-367fee_2xyj9g.png)

# Using the Google Sheets integration

There are two steps you can use in Encharge flows with the Google Sheets integration:

* [Row added in Google Sheets](//help.encharge.io/article/470-trigger-row-added-in-google-sheets) trigger step - The "Row added in Google Sheets" trigger adds people to a Flow whenever a new row is added to the selected Google sheet.
* [Add a Row in Google Sheets](//help.encharge.io/article/471-action-add-a-row-in-google-sheets) action step - The "Add a Row in Google Sheets" action step appends a new row to a selected Google spreadsheet with the mapped person details.