Setting Up Google Spreadsheet Connector
As we mentioned in an earlier post, FormAssembly now integrates directly with Google Spreadsheets. If you’ve used Google Speadsheets’s native form solution, you may have found it lacking in some key features. FormAssembly integration allows you to utilize FormAssembly’s sophisticated features while also taking advantage of having your data readily available in Google Spreadsheets.
To get this up and running, you need to have a Google account (get one here if you don’t have one) and be on the FormAssembly Professional Plan.
Configure the Connector
In the Connectors tab for the form you’re working with, click “configure” next to the Google Spreadsheets connector, choose either “interactive” or “background” mode, then click the blue “Click here to begin” link.
Grant Access and Select Spreadsheet
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.
Be sure to enable the connector in either background or interactive mode.
Note that if you’ve installed FormAssembly for Google Apps, you won’t need to grant access again (as access will have been granted at installation).
To see the connector in action, submit a test response. Then, login to 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.
Please note: Once a form is revised and saved, the next submission will start a new tab at the bottom of your spreadsheet.
In the coming weeks, we’ll add some posts about how you can get even more from this feature, including renaming columns in the spreadsheet and using filters.
We hope you utilize and benefit from this new feature. As always, we’d love to hear about what you’d like to see in future posts and features. Leave a comment here, request a new feature at our UserVoice forum, or share your thoughts with us via Twitter.