Use the Google Sheets integration to push your responses to a Google Sheet.
It's straightforward to do - let's go through the steps...
Click on the Extra Options tab and scroll down to Integrations. Click Google Sheets.
Now you'll have the settings screen.
- Enabled - make sure to toggle this button on to enable the feature.
- Spreadsheet ID - copy the spreadsheet ID which you'll find in the URL of your spreadsheet. Copy only the values between the "/d/" and the "/edit".
- Sheet Name - copy the name of the sheet - you'll find the sheet name in the tab at the bottom of the spreadsheet.
- Create - click Create to test the connection and create the header row for your questionnaire.
Make sure to share your document with the user firstname.lastname@example.org. It’s a very important step in this process.