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 Sheet. All you need is a Google account.
Setup
Go to the Integration page in your flow and select the Google Sheets response handler.
2. Create a new Google Sheet as usual.
3. Share edit rights to enable your flow access to the sheet and add responses to it. Click on the green Share button top right and add the following email address as an editor.
You might get asked if you really want to share your sheet with Heyflow. Please agree and don't worry: Heyflow will only have access rights to this particular Google Sheet and will only use access rights to insert your data and nothing else.
It might take up to 5 minutes for the edit rights to become active.
4. Next, fill out the predefined Spreadsheet ID and Sheet ID fields on the integration page in Heyflow.
Spreadsheet ID: You will find the Spreadsheet ID in the URL of your sheet. It consists of a long combination of numbers and letters between spreadsheet/d/ and /edit
e.g.,
docs.google.com/spreadsheets/d/[Your Spreadsheet ID]/editSheet ID: You can find the Sheet ID at the bottom left of your sheet.
5. Lastly, you just need to click on Connect and that's it! All new answers are transferred to your sheet in real time!
❗ Caution: Do not change the name (labels) of the headers, since we need the initial ID to keep posting the data correctly. If you want to display your data differently, please copy it to another sheet.
Frequently Asked Questions (FAQ)
When are fields added as columns in Google Sheets?
Your columns will automatically appear in the Google Sheet as soon as data starts coming in, meaning when a response is submitted in your flow.
Do I need to update Google Sheets if I add questions to my flow?
No worries! When you add more questions to your flow, there's no need to reconfigure the integration. New response entries will simply create an additional column on the right with the new information.
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.
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 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. If you want the updated System Label to appear in your Sheet, you'll need to reconnect the Google Sheet integration.
Can I change the column headers in my Sheet?
No, the column headers are required as unique identifiers to ensure that data continues to flow into your Sheet properly.
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}.