How to Use the Google Sheets Integration
The Google Sheets integration allows you to sync form responses to a spreadsheet in your Google Drive. Note, to use this integration you must have a Google account.
How it’s done:
1. Connect your Google Account to Blitzen
Navigate to the ‘Integrations’ section in the left-side panel and click on the ‘Sheets’ app.
Click ‘Connect’ in the right-side panel.
You will be directed to log in with your existing credentials and asked to give Blitzen permission to access the app. Don’t worry, we won’t mess with the stuff that’s already there!
Make sure that the app is on by moving the app slider to ‘On’
If, for any reason, you would like to disable this app, just move the slider to ‘Off’ or disconnect it all together (How to Disconnect an App).
2. Create a Workflow with the Google Sheets App
Navigate to the ‘Workflow’ section in the left-side panel and create a new workflow (How to Create a Workflow). You can also edit an existing workflow.
Choose the form or survey you wish to send to Google Sheets (How to Choose the Input).
Drag the Google Sheets App over into your workflow and configure by clicking the ‘+’ icon.
The default setting is to sync all files from your indicated form as they come in. If that is not what you wish to do simply add filters. Click ‘Add custom filter’ and use the three fields to create a segment.
You are able to create any number of filters, just make sure they do not contradict each other.
To delete a filter simply click on the ‘x’ icon in the right corner.
You will then be asked to choose the spreadsheet your data will be sent to. Blitzen will pull up a list of Google Sheets you have already created. If you wish to create a new one, do so in your Google Drive and refresh the Blitzen page.
Once you have chosen the spreadsheet, Blitzen will give you the option of choosing the worksheet. The default for Google Sheets is ‘Sheet1’. Use the options available or create a new worksheet by typing in the text box and clicking ‘Create’.
Your changes will be saved automatically. Now every time someone submits a file through your form or survey, the answers will be sent to this Google Sheet.
To sync previous data to your spreadsheet, see this article.