With the Google Sheet destination (available on our paid subscriptions), you can send your submitted data to your Google Drive account.
In this article we'll provide an overview of setting up this destination To set this up, go to your "Forms" page and click the link in the destinations column of the form you would like to add the destination to, or select Destinations from the settings menu.
Note: If there are no destinations added to your account, this button will read "0"
This will take you to the "Destinations" page, where you will then need to click "New Destination".
A new page will load, and on it you will see different destinations to send your data. Click "Google Drive", then select the "Spreadsheet" format.
You will also see an option to send your images to a service other than Device Magic. If you would like to do this, select from the services provided. Please note, choosing a service other than "None (inline)" will result in a hyperlink to the hosted image being placed in the file generated by this destination instead of the actual image. See this help article for more information.
Step 4 will give you the option to add a Description to your destination. You can also set your destination to be Active or not here.
Continue on down the "Add new Destinations" page, and you will see an option to include submission meta data. This is data about the form itself, such as the submission ID. If you would like it to be included in your sheet, check the box.
Next, select to which account you'd like to have your data sent, and ensure you have a name for your sheet (if you would like to use placeholders to determine the name of the sheet, click the button that says "Show me placeholders I can use in this folder path" to see a list of the placeholders that are applicable to your form).
You will then see an option to provide a folder path for the sheet, for example:
However, this isn't a requirement, as Device Magic will automatically generate one for you. To learn more about Folder path customization, visit our article here.
In Step 7, you will be given the option to set your File access mode to Private or Public.
In Step 8, you have the option to create Destination Rules on when you want the Destination to be active. To learn more about how Destination Rules work, visit our article here.
Lastly, all you need to do is click the "Create Destination" button at the bottom of the page.
Please note that there are a couple of limitations to the Google Sheet Destination.
Google Sheet Limitations:
The following changes will result in a new tab being created and the next delivery will be sent there:
- Saving the mobile form - When a submission from the updated version is sent to the sheet, a new tab will be created, and the delivery sent there.
- Editing column headers generated by Device Magic.
- Adding an additional column header.
Note: If you were previously using the Google Sheet Connection and are now experiencing problems with stuck forms, read this article to find out how to redirect these errors to a Google Sheet Destination.
This concludes our overview of adding the Google Sheet destination. If you have any questions or comments feel free to send us a message at firstname.lastname@example.org