Writing a Record to Smartsheet

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

Configure Smartsheet

  1. From the menu under your Profile, select Apps and Integrations.

The profile menu is highlighted, along with the Apps & Integrations menu option

  1. From the Personal Settings menu, select API Access.
  2. Click Generate new access token.
  3. Name your token, and click OK.

Step 1 of the Generate API Access Token is shown with a sample token name

  1. Your Smartsheet API token appears. Note this value for future use.

Step 2 shows a sample API token

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. You use it in the following steps.

On the Properties window, the Sheet ID field is highlighted

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)

The Configurations Panel for an External Web Call action, with sample field values

  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:
Copy
[{
“toBottom“:true,
“cells”: [
{“columnId”: <column1Id>, “value”: “<column 1 Value>”},
{“columnId”: <column2Id>, “value”: “<column 2 Value>”}
]
}]
  1. Configure the RESPONSE VARIABLES to capture any additional information required. For more information, see the Smartsheet Rows support page.

In the Configurations Panel for the External Web Call action, sample data appears in the body of the HTTP Request section

  1. Save and Deploy your flow. When the flow is activated, it returned the row where your value is located.