> 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/journeys/google-sheet-integration-in-journeys.md).
# Google Sheet Integration in Journeys
Connect Google Sheets with QuickReply to automatically add or update data from your Journeys in an existing Google Sheet.
With the Update Google Sheet node, you can select a connected spreadsheet, choose a Sheet Tab, map Journey data to the sheet columns, and decide whether to update an existing row or add a new row.\
\
\
**Prerequisites:**
* The spreadsheet you want to use already exists in your 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.
Note: The spreadsheet must be connected to QuickReply before you can use it in a Journey Builder
\
**Step By Step Process:**\
\
1\. Go to Settings.
2. Open Integrations Tab.
3. Click and Google Spreadsheet and click connect.
4. Sign in to your Google account and grant the required permissions.
5. Once connected, the spreadsheet becomes available for use in Journeys.
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.
### How to Connect a Google Sheet file from your drive?
After connecting your Google account:
1. Open the Connected Files tab and Click on Connect New Files.
2. Select the Google Sheet file you want to use.
3. Connect the selected files.
Once connected, the file appears under Connected Files and can be used in your Journeys.
Important: The Google Sheet must be connected from Connected Files before it can be used in a Journey or 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.
## How to Add Google Sheet to a Journey?
1. Open the Journey where you want to use Google Sheets.
2. Click on edit and open the workflow tab
3. Click + to add a node.
4. Select Flow Control, then click on Update Google Sheet.
5. Click Start Configuration.
The configuration includes selecting a sheet, mapping its columns, and choosing how duplicate data should be handled.
### How to use Google Sheet in Journeys?
Select the spreadsheet you want to update.
You can choose a file from the Connected Files (files already connected and used in QuickReply).
Steps:
1. Select the required spreadsheet.
2. Use Search to find a specific file, if needed.
3. Click View to verify the file.
4. Click Save & Continue.
### 2. Map Sheet Columns
After selecting the spreadsheet, choose the Sheet Tab where you want to add or update data. QuickReply detects the columns from the selected tab's header row and makes them available for mapping.
For each column, you can either:
* Enter free text for a fixed value, or
* Click Add dynamic value to insert data from your QuickReply workflow.
For dynamic values, select the Source and Field Name, then click Add.
Example:
Steps
1. Open the Sheet Tab dropdown and select the required tab.
2. Click on add dynamic value, then select the source and field name and click add.
3. Map each sheet column to the relevant variable, then click on Save & Continue.
QuickReply supports variables from:
● Customer attributes
● Profile attributes
● Tags
● Order details
● Conversation details
● Journey/event variables
● Custom or static values
For example:
| Google Sheet Column | QuickReply Variable |
| ------------------- | ------------------- |
| Name | {{name}} |
| Phone | {{phone}} |
| Order ID | {{order\_id}} |
| Lead Stage | {{lead\_stage}} |
Note: The selected Sheet Tab must have a header row. If a header is not detected, select a tab with valid headers before continuing.
### 3. Choose Duplicate Handling
Choose how QuickReply should handle data that may already exist in the sheet.
Update Existing Row
Select Update Existing Row to update an existing record instead of creating a new row.
You must select a Key Column. The Key Column is used to identify the record that should be updated.
You can use values such as:
● Phone number
● Email
● Order ID
● Customer ID
Choose a column with a unique and consistent value that can identify the record.
Always Add New Row
Select Always Add New Row when you want every Journey execution to create a new row.
A Key Column is not required for this option.
### 4. Test and Save
Before saving the node, review the configuration and send a test row.
The configuration summary includes the selected file, Sheet Tab, column mappings, duplicate handling method, and Key Column when applicable.
Steps
1. Click Send Test Row.
2. Open the selected Google Sheet.
2. Open the selected Sheet Tab.
3. Verify that the test data appears in the expected columns.
4. Save the configuration.
Once saved, the Update Google Sheet node appears as a configured node in your Journey.\
## Troubleshooting:
No Google Sheet is available?
Make sure the required spreadsheet has been connected from Settings → Integrations → Google Spreadsheet.
I can't connect a new Sheet?
If you're a Member, ask an Account Owner or Admin to connect the Google Sheet. Members can use files that have already been connected.
No header is detected?
Select a Sheet Tab that contains a valid header row. QuickReply uses the header row to identify the columns available for mapping.
I can't continue with Update Existing Row?
Select a Key Column. It is required when Update Existing Row is selected.
My Sheet or Sheet Tab is no longer available?
Check that the Sheet still exists, the selected tab has not been deleted, and your Google access is still valid. Also review your column mappings if the sheet structure has changed.
## FAQs
Can I create a new Google Sheet from QuickReply?
No. The current integration supports existing Google Sheet files. Creating a new Sheet from QuickReply is not part of the current version.
Do I need a Key Column?
Only when Update Existing Row is selected. Always Add New Row does not require one.
Can I enter a fixed value instead of a dynamic value?
Yes. You can enter free text directly in the Value field or use Dynamic Value to insert data from the sheet.