All Collections
Automation
Workflows
Google integrations
Set up an “Upload a Scheduled Report to Google Drive” Workflow recipe
Set up an “Upload a Scheduled Report to Google Drive” Workflow recipe

Set up a Workflow recipe to automatically upload a scheduled report to your connected Google Drive.

GoFormz Support avatar
Written by GoFormz Support
Updated over a week ago

Use the "Upload a Scheduled Report to Google Drive" Workflow recipe, to automatically deliver your scheduled reports to your connected Google Drive account.

Schedule periodic Template-based reports with GoFormz reports. Because your reports change as your Form User’s submit Forms, you’ll want to run regular reports to track any changes. Use this Workflow to automatically upload those reports to Google Drive.

Set up this Workflow recipe in the GoFormz web app’s Workflows tab. Next, click Create to navigate to the Workflow Recipes Library where you’ll complete the following steps:

  1. Select the "Upload a Scheduled Report to Google Drive" recipe.

    Screenshot displaying the "Upload a Scheduled Report to Google Drive" in the Workflow Recipe Library in the GoFormz web app.



    You’ll navigate to the Workflow Recipe Builder.

  2. Click the pencil icon next to the default Workflow name.
    Enter a Workflow name.

    Screenshot displaying the location of the pencil icon in the Workflow Recipe Builder of the GoFormz web app.



    Note: GoFormz recommends that you include the report name used in the Workflow in your Workflow name.

  3. Establish your Schedule trigger to determine when you want your reports to run.
    Your options include daily, weekly, or monthly.

    Screenshot displaying the Schedule trigger in the Workflow Recipe Builder of the GoFormz web app.



    Click Next.

  4. Establish your Export Report View to CSV action.
    To do this, you’ll select the report you want exported as a CSV file for upload to Google Drive.

    Optional: Here, you can also enter an Export Delimiter and decide if you want to Include Newline Characters.

    Screenshot displaying the Export Report to CSV action in the Workflow Recipe Builder of the GoFormz web app.



    Click Next.

  5. Establish your Upload File action.
    This configuration details for this action include Connection, Destination Drive, and Destination Folder.

    Note: You’ll also see a Unique Identifier configuration option. This field is not required.

    Screenshot displaying the Google Workspace: Upload File action in the Workflow Recipe Builder of the GoFormz web app.


    1. Select your Connection from the Connection drop-down menu.

    2. Indicate the Destination Drive to which you want to save your files. If you leave this blank, your files will send to your personal drive.

    3. Destination Folder determines the name of your PDF and the Google Drive folder to which your PDF will upload.

      Note: You’ll also see a File(s) configuration option. Do not change this - it is a pre-populated field.

  6. Click the Activation slider if you want your Workflow active immediately.
    The Workflow Activation status will display as Active or Inactive.

    Screenshot displaying the location of the Activation slider in the Workflow Recipe Builder of the GoFormz web app.


  7. Click Save.

Want to verify that your Workflow is set up correctly?

If you want to verify that your Workflow is correctly set up, complete the Workflow trigger you set up in Step 3 above.

Next, navigate to the Workflows tab in the GoFormz web app and click View Jobs. This will bring you to the Workflow Jobs paeg

Screenshot displaying the location of the View Jobs link on Workflows page in the GoFormz web app.

Here you’ll see if your Workflow succeeds. If your Workflow is successful, you’ll see data from your exported report in your connected Google Drive account.

Did this answer your question?