⭐ Available in the following bundle: Core Bundle (incl. in all plans)
⭐ Available on the following plans: Basic, Pro, Agency, Business
👀 Not sure which plan you're on? Check your subscription here.
Heyflow offers you numerous possibilities to collect the answers of your users in a meaningful way. One of them is our Google Sheets integration, which transfers the answers directly into a Google Sheets. All you need is a Google account.
❗ Are you using an old Google Sheets integration setup?
We launched an improved version in May 2025. The old integration will stop syncing data after September 30 - make sure to switch to the new one for continued support and full functionality.
Setup
Connecting your account
In your flow, go to the Integrate tab and open Response Handlers.
Click Connect to Google Sheet. A popup will appear asking you to sign in with your Google account.
Authenticate with Google and select the account you want to connect to confirm.
Choosing the spreadsheet
You can either:
Create a new Google Sheet, or
Be the owner or editor of an existing one.
Click Select Spreadsheet. A popup will show you all available Sheets in your account.
Choose the desired spreadsheet file and click Select.
❗ Note: You can only connect one spreadsheet per flow, not multiple.
Choosing the sheet
Click Select Sheet to choose the specific sheet (tab) inside your selected spreadsheet.
Pick the sheet you want to use and click Save changes.
And that’s it, you will now receive your responses in Google Sheets.
After connecting your flow for the first time, the initial columns will be created based on the questions in your flow.
Whenever a response is submitted, the data will automatically be appended to the selected Google Sheet.
If you add new questions later, new columns will be created automatically — right after the first response that includes those new questions.
💡 Tip: We recommend you run analysis in a second sheet, and leave room for the sheet with the incoming responses to grow.
Are you using an old Google Sheets integration setup?
We’ve upgraded the integration in May 2025 to support secure OAuth login, no more manual sharing or copying Sheet IDs. Just sign in with your Google account, pick your spreadsheet, and you’re good to go.
The old integration will stop syncing data after September 30 - make sure to switch to the new one for continued support and full functionality, e.g.
Fast & frictionless setup
Fewer errors, better reliability
Secure, standards-based authentication
If your flow is using a legacy Google Sheets integration, you can upgrade to the new version in just a few clicks. All settings will be carried over automatically, and the old integration will be disconnected in the background.
Here’s how:
Go to the new Google Sheets integration.
Select a connected Google account or connect a new one. Make sure you’re the owner or editor of the sheet that was linked to the old integration.
Click on Migrate now.
That’s it! You’re now using the new Google Sheets integration.
Frequently Asked Questions (FAQ)
Do I need to update Google Sheets if I delete questions to my flow?
No, the column associated with the deleted question will remain in your Sheet to preserve the historical data. However, no new data will be added to that column.
Can I reorder my columns?
Yes! You can freely rearrange columns in your Google Sheet. It won’t affect the incoming data—new responses will still be correctly matched to the corresponding columns.
Why are there two labels or IDs in my sheet?
Each column header in your sheet has two labels, such as:
First Name (ID: input-b6cec9cd).
The first label is the System Label from Heyflow.
The second is a unique system identifier (field ID) automatically generated when an input block is added. This identifier cannot be changed.
What happens if I change the System Label in Heyflow?
Changing the System Label in Heyflow will not affect the column headers in your Google Sheet. Your Sheet view will remain the same.
Can I change the column headers in my Sheet?
Yes, you can rename the column headers — as long as the field ID stays unchanged. For example, if your column is labeled First Name (ID: input-b6cec9cd), you can rename it to Name (ID: input-b6cec9cd) or any other label, as long as the part in parentheses (the ID) remains exactly the same. If you also change the ID, we cannot push the data to the correct column and would create a new one.
💡 Tip: If you'd like to display the information differently in Google Sheets, you can create a new tab or sheet and copy the data there. This can be done automatically using a formula like ={sheet1!A:A}.
Troubleshooting
If something goes wrong with your integration, an automatic email notification will be sent. The message includes the flow ID, response ID and a description of the error returned by your integration.
What does the error "Cell Limit Reached" mean?
If you get this error message:
Response handler issue. Error: You have reached the maximum of 10,000,000 cells per Google Sheets workbook.
…it means there are no empty cells left to insert new data — often because your sheet doesn't have enough rows.
This means the responses couldn't be sent due to missing blank cells. You can easily solve this issue by scrolling to the bottom of your Google Sheet and adding more empty rows. This creates the space needed for new responses to be added.
What does the authentication 403 error mean?
The 403 error means that the server is denying a request due to missing or insufficient permissions. Double check you're the Owner of or have got Admin or Editor rights for the Spreadsheet you are trying to connect your Heyflow to. If not, request the permissions from the Admin of the Spreadsheet.
What does the error "Invalid requests" mean?
If you get this error message:
Error: Invalid requests[0].updateSheetProperties: You are trying to edit a protected cell or object.
…it means the authenticated user doesn’t have permission to edit the protected sheet. Make sure you have edit access, or ask the sheet owner to remove protection on the relevant cells or sheet.
🔎 For a list of common issues and general recommendations, check out the Troubleshooting Guide for Response Handlers.