> For the complete documentation index, see [llms.txt](https://docs.quickreply.ai/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.quickreply.ai/product-modules/ai-builder/google-sheet-integration-in-ai-builder.md).
# Google Sheet Integration in AI Builder
Connect Google Sheets with QuickReply to store or update data collected through your AI Builder bots.
With the Update Google Sheet node, you can select a connected spreadsheet, map bot data to its columns, and choose whether to update an existing row or add a new row.
### Before you start
Make sure:
* The spreadsheet you want to use already exists in Google Drive.
* You have access to the Google account you want to connect.
* The spreadsheet has been connected to QuickReply from Settings → Integrations → Google Spreadsheet → Connected Files.
* The Sheet Tab you want to use has a header row.
### Connect Google Sheet
1. Go to Settings.
2. Open Integrations.
3. Find Google Spreadsheet and click connect
4. Sign in to your Google account and grant the required permissions.
5. Your google account is shown under the Connected google accounts.
Note: Google Sheet connections are managed at the workspace level. The Account Owner and Admins can connect and manage Google Sheet files. Members can use files that have already been connected.
### Connect a Google Sheet file
After connecting your Google account:
1. Open the Connected Files tab.
2. Click Connect New Files.
3. Select the Google Sheet file you want to use.
4. Connect the selected file.
Once connected, the file appears under Connected Files and can be used in your AI Builder.
Important: The Google Sheet must be connected from Connected Files before it can be used in the AI Builder flow.
#### What are Connected Files?
Connected Files displays the Google Sheet files that have been connected to QuickReply from the connected Google account. Only files that have been connected are available to use in the Google Sheet node.
### Add Google Sheets to an AI Builder Bot
1. Open AI Builder.
2. Go to Custom Bots and open an existing bot or create a new bot.
3. In the Build tab, click + to add a node.
4. Under Collect User Data, select Update Google Sheet.
The Update Google Sheet node is added to your bot.
### 1. Select a Google Sheet
Select the Google Sheet file you want to use.
#### Steps
1. Click on Edit Node.
2. Select the required Google Sheet.
3. Use Search to find a specific file, if needed.
4. Click View to verify the file.
5. Click Save & Next.
Note: Only Google Sheets that have already been connected from Settings → Integrations → Google Spreadsheet → Connected Files are available here.
### 2. Configure Data
After selecting the file, choose the Sheet Tab where you want to add or update data.
QuickReply detects the columns from the Sheet Tab's header row and displays them under Column mapping.
For each column, you can either:
* Enter free text for a fixed value, or
* Click Dynamic Value to insert data from the sheet.
#### Add a Dynamic Value
1. Click Dynamic Value next to the required column.
2. Select the Value type.
3. Select the relevant attribute name and click add.
4. Click Save & Next.
The available value types include:
* Profile attributes
* Tags
* Custom attributes
* Conversation ID
For example, Profile attributes can include values such as Name, Phone, Email, Location, Lead Stage, and Latest query.
After mapping the required columns, click Save & Next.
Note: The selected Sheet Tab must have a header row so that QuickReply can identify the columns available for mapping.
### 3. Duplicate Handling
Choose what should happen when the bot sends data that already exists in the Google Sheet.
#### Update existing row
Select Update existing row to update an existing record.
You must select a Key column to identify the row that should be updated.
For example, if Phone uniquely identifies a customer, select Phone as the Key column.
#### Always add new row
Select Always add new row when every bot interaction should create a new row.
A Key column is not required for this option.
### 4. Finish
Review your configuration and click Save to complete the setup.
Once saved, the Update Google Sheet node appears in your AI Builder bot with the selected Google Sheet and Sheet Tab.
When the bot reaches this node, the configured data is added to or updated in the selected Google Sheet based on your duplicate handling settings.