Writing a Record to Smartsheet

To write a record to Smartsheet, you need the following:

Configure Smartsheets
  1. Select Apps and Integrations… from the menu under your Profile.
Apps and Integrations menu option under the Smartsheet Profile
  1. Select API Access from the Personal Settings menu.
  2. Click the Generate new access token button.
  3. Name your token and click OK.
Wizard step 1 to generate a Smartsheet API token
  1. Your Smartsheet API token appears. Please note this value for future use.
Step 2 of the Smartsheets API token generation
Determine Your Sheet ID

To retrieve or modify the contents of your Smartsheet, you need to determine the ID of the Smartsheet.

  1. Open your Smartsheet.
  2. Select File > Properties.
  3. Note the Sheet ID in the Properties window. It will be referenced in the steps below.
Update Your SmartFlow

Note: Each column in a Smartsheet is represented as an ID. These IDs are needed to make inserts or updates at higher frequencies.

  1. Add an External Web Call action to your flow.
  2. Configure the action as follows:

HEADER VALUES

CONTENT-TYPE:application/json

AUTHENTICATION:Bearer {Your API Token Value}

METHOD:GET

URL OF SERVICE:https://api.smartsheet.com/2.0/sheets/{Smartsheet ID}/columns

RESPONSE VARIABLE: (add one entry for each column you want to capture)

Name:column<#>Id (e.g., column1Id)

Query Expression:result.[<column#>].cells.[column#].columnId (e.g. result.[0].cells.[0].columnId )

SmartFlow Inputs Example

Example of SmartFlow Inputs
  1. Add an additional External Web Call action to your flow.
  2. Connect the two actions.
  3. Configure the second action as follows:

HEADER VALUES

AUTHENTICATION:Bearer {Your API Token Value}

METHOD:POST

URL OF SERVICE:https://api.smartsheet.com/2.0/sheets/{Smartsheet ID}/rows 

CONTENT-TYPE:application/json

BODY

[{ 

“toBottom“:true, 

“cells”: [  

                    {“columnId”: <column1Id>, “value”: <column 1 Value>}, 

                    {“columnId”: <column2Id>, “value”: <column 2 Value>} 

         ] 

                         

}] 

  1. Configure the RESPONSE VARIABLES to capture any additonal information required. For more information see the Smartsheet Rows support page.

SmartFlow Inputs Example

SmartFlow Inputs example for the second external web call
  1. Save and Deploy your flow.

When the flow is activated, it will return the row where your value is located.