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.
It might take up to 5 minutes for the edit rights to become active.
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.
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.