With our Google Spreadsheet Connector, you can utilize FormAssembly's sophisticated features and have your data readily available in Google Spreadsheets (also known as Google Sheets).
This means no more manual exporting, let the connector do it for you!
You can click on Advanced when you receive the Unverified App error and proceed to FormAssembly.
Grant Access and Select Spreadsheet
Begin by going to the connectors page for the form you are working with. This can be reached by hovering your mouse over the form's Configure button and then choosing Connectors.
Once there, add in the Google Spreadsheet Connector to the Form Submitted section of the timeline and click on Configure.
Once you are in the connector, click the link that reads "Click here to begin" in Step 1.
You'll be asked to sign into your Google account. Then you can choose whether to let FormAssembly create a new spreadsheet for the web form's responses, or add the responses to an existing spreadsheet. Click Apply to save your changes.
To see the connector in action, submit a test response.
Then, log into your Google account and either open the existing spreadsheet where you told the connector to place your data, or take a look at the newly-created spreadsheet.
Responses are automatically added to the spreadsheet upon submission.
Additionally, renaming the most current tab in your Google Sheet will cause a new tab to be created the next time a response is submitted to the form.