All Collections
Automation
Workflows
Smartsheet integration
Set up your “Add Form Data and Upload Form to Smartsheet” Workflow recipe
Set up your “Add Form Data and Upload Form to Smartsheet” Workflow recipe

With this recipe, you can add transmitted Form data to your connected Smartsheet - along with the Form PDF.

Updated over a week ago

Automatically add data transmitted from Forms to your connected Smartsheet along with a PDF copy of your Form with the Add Form Data and Upload Form to Smartsheet Workflow recipe.

🗒️ Note: This Workflow does not look for a unique identifier to map new data to existing data. If you want to map to existing data, use the Upsert to Smartsheet Using a Completed Form recipe.

Before you set up this Workflow, you’ll need to connect Smartsheet. The connection you choose determines your options in the configuration details of this Workflow.

In the Workflows tab of the GoFormz web app click Create to access the Workflow Recipes Library. Select the Add Form Data to Your Smartsheet recipe card to navigate to the Workflow Editor where you’ll complete the following steps.

  1. Click the pencil icon.
    ​

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


    Enter a Workflow name.
    ​

    Note: Include the Template name used in the Workflow in your Workflow name.
    ​

  2. Establish your Form Completed trigger by configuring your Completed By & Template details.
    ​

  3. Establish your Add Row to Sheet action.
    ​
    This requires that you configure your Connection, Destination Sheet, and Sheet Column Mapping.
    ​

    1. Connection is a menu listing your available Smartsheet connections. Your Smartsheet connections determine the options available to you here.
      ​

    2. Destination Sheet specifies the path to the Smartsheet sheet you want your action to reference.
      ​

    3. In Sheet Column Mapping you’ll provide the Sheet Column Name to which you want your data to be mapped. Enter the New Cell Value to determine the data which will populate your corresponding Sheet Column Name.
      ​
      Your New Cell Value can be a specific alphanumeric value, or you can use Workflow variables to populate the value with a specific field from your Template.
      ​

  4. Establish your Export Form to PDF action by configuring your Form ID and Pages details.
    ​

    Screenshot displaying the Export Form to PDF action in the Workflow Recipe Builder in the GoFormz web app.

    1. The Form ID is pre-populated based on your preceding Workflow steps.
      ​

    2. Enter the pages you want included in your export in the Included Pages field.

  5. Establish the Upload Attachment to Row action.
    ​
    For this action you’ll configure your Connection, Destination Sheet, Attachment Destination Row, and File(s).
    ​

    Screenshot displaying the Smartsheet Upload Attachment to Row action in the Workflow Recipe Builder of the GoFormz web app.


    ​

    1. Your Attachment Destination Row field is pre-populated with the necessary information.
      ​

    2. Your File(s) are automatically defined using the outputs from your preceding action. These are the files you’ll upload to your specified rows.
      ​

  6. Click the Activation slider if you want your Workflow active immediately.
    ​

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

    Your Workflow Activation status displays as Active or Inactive.
    ​

  7. Click Save.

Did this answer your question?