With the “Upload submitted Public Form to Google Drive” Workflow recipe you can automatically send your Public Form submissions to your Google Workspace account.
Send Public Forms directly to your connected Google Drive account as soon as they're submitted with the "Upload Submitted Public Form to Google Drive" Workflow. This assures prompt access to submitted Public Forms via Google Drive for any users who need it.
Use Workflow Variables in the Upload File step (step 5 in the instructions below) to leverage Form data to help manage your Forms.
Open the Workflows tab in the web app and click Create to access the Workflow Recipes Library.
Next, complete the following steps:
Select the Upload Submitted Public Form to Google Drive recipe.
This opens the Workflow Editor.
Click the pencil icon next to the default Workflow name.
Enter a Workflow name.
Note: Include the Template name used in the Workflow in your Workflow name.
Establish your Public Form Submitted trigger.
To do this, configure your Owned By and Template details.
Click Next.
Configure your Export Form to PDF action details.
This includes the pages you want exported, and a name for your PDF.
Select the Form pages you want exported to PDF.
Note: If you want to export all Form pages, leave this field blank.
Click Advanced.
Here you’ll assign your PDF a name in Filename.
Note: If you choose not to name your PDF, your PDF will adopt the name of the corresponding completed Form.
Click Next.
Configure your required Upload File details.
These details include Connection, Drive, and Folder Path.
Note: Do not change the File(s) option.
Select the Connection from the menu to indicate the Google Workspace app connection you want used for your upload.
Destination Drive indicates the Google Drive where you want your files stored. If you leave this blank, your files are delivered to your personal drive.
The Destination Folder determines the Google Drive folder where the PDF will be placed.
Click the Activation slider if you want your Workflow active immediately.
The Workflow Activation status is either Active or Inactive.
Click Save.