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

Update or add rows to your Smartsheet sheet using data from completed Forms.

Updated over a week ago

Automatically update a row, add a new row, and upload a completed Form to your Smartsheet sheet based on your completed Form with Workflows.

When you update or add rows based on their condition, it's referred to as upserting.

Before you set up this Workflow, you’ll need to connect Smartsheet.

In the Workflows tab of the GoFormz web app click Create to access the Workflow Recipes Library.

Here, you’ll select the Upsert Form Data and Upload Form to Smartsheet Workflow recipe to navigate to the Workflow Editor where you’ll complete the following steps.

  1. In the Workflow Editor, click the pencil icon.
    ​

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


    Enter a Workflow name.


    ​Note: GoFormz recommends that you 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 Upsert Row in Sheet action.
    ​
    This action requires that you configure your Connection, Destination Sheet, and Sheet Column Mapping.
    ​

    Screenshot displaying the Smartsheet Upsert Row in Sheet action in the Workflow Recipe Builder of the GoFormz web app.

    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 Included Pages details.
    ​

    Screenshot displaying the Export Form PDF action in the Workflow Recipe Builder of 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 in 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 either Active or Inactive.
    ​

  7. Click Save.

Did this answer your question?