Heyflow offers you numerous possibilities to collect the answers of your users in a meaningful way. One of them is our Google Sheets integration, with the help of which the answers are transferred directly into a Google Sheet. All you need is a Google account.
Here is how to integrate Google Sheets
Go to the Integration page 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.
Note: 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! ✅