Anyone who’s used Google Drive before knows how handy it can be when dealing with data as a team. It eliminates redundancies by allowing multiple members of a group access to an existing spreadsheet, and changes are instantly reflected. The Launchcloud integration with Google Drive further streamlines this process by connecting directly to your Google spreadsheets, automatically updating your spreadsheets with incoming data collected from a Launchcloud form.
In this article, we explain how to:
- connect your Launchcloud account to Google Drive
- create a new Google spreadsheet from Launchcloud
- send Launchcloud response data to a Google spreadsheet
- save files to Google Drive from Launchcloud
- populate a Launchcloud form with information from a Google spreadsheet
- populate one spreadsheet with data from another (watch the video)
What is Google Drive?
Google Drive is a collection of productivity apps, providing cloud access to documents that can be collaboratively updated in real time. The Launchcloud integration utilizes Drive’s spreadsheet feature.
All Google accounts have a corresponding Google Drive account. To signup with Google, click here.
Integrating Google Drive
Once you’ve created an account with Google, you’re able to connect it with Launchcloud. First, visit our Launchcloud Market and search for the Google Drive integration. (You’ll be able to peruse our other integrations here as well.) The Market can be found through the “Installed Apps” panel found in the navigation bar at the top of your account.
Alternatively, you can go straight to the Google Drive integration page by following this link.
Next you’ll need to activate the integration, which you can do by clicking the “Install” button.
A popup screen asking for permission to manage your Google Drive account will appear. Click “Allow.”
You’ll now see your Google Drive account listed as being attached to Launchcloud. To connect another account, click the “Add Google Drive account” button.
Disconnecting Google Drive
To disconnect your Google Drive account from Launchcloud, click the X to the right of the account email. Be aware that any forms with fields that use the Google Drive integration will stop working properly.
Creating Google Spreadsheets
Launchcloud already offers a powerful reports generator for viewing response data. However, users can also store form responses in a Google spreadsheet, with each new submission being entered as a new line.
To create a new Google spreadsheet from a Launchcloud form, open the form you’d like to track and navigate to the Form Settings menu in the bottom right corner of the Form Builder.
Next, head to the Storage tab and open the Google Drive option.
Finally, click the Google Sheet button on the Form Attachment Menu and hit Save.
Once you save the changes to your form, any future submissions will be saved in a Google spreadsheet in a folder titled “Launchcloud.”
Saving Files to Google Spreadsheets
In addition to text data, Launchcloud can also send PDFs and media files to a spreadsheet. This is also done from the Form Attachment Menu — just click the button to the right of the file type you’d like to include.
The attachment will appear as a link to the actual file.
You can also use the Google Drive integration to quickly populate a Launchcloud form with data from a Google spreadsheet. To utilize this feature, drag the “Data Search” field located under the “Text Input” tab onto your form.
This will launch the Search Data Link menu. Click the Google Drive option located in the Integrations tab.
Next, you’ll see a list of all your Google spreadsheets. Click on the spreadsheet you’d like to search from.
Finally, you’ll have the option of choosing from each of the column titles in that spreadsheet. Select each of the fields that you’d like to be populated with your search results.