Skip to main content

update_spreadsheet_row

Facts​

DescriptionUpdate a spreadsheet
SchemaConnectors.GoogleSheets.functions.UpdateSpreadsheetRow
ServiceGoogle Sheets

Input parameters​

Required input parameters

column_namestringRequired

The name of the column that contains the cell value that will be used to determine which row to update

Examples
assignees
google_access_tokenslack#/types/credential/oauth2Required

Google Access token. See the authentication section for details.

sheet_titlestringRequired

The title of the sheet which contains the row to update

Examples
Sandra's great ideas
spreadsheet_idstringRequired

The ID of the spreadsheet

Examples
1234567890_abcdefg_1q2w3e4r5t6y7u
updated_valuesobjectRequired

An object where each key is a string containing a numerical index representing a column you want to update. The corresponding values are the updated contents to be associated with the individual cells in those columns. The keys, in this case, serve as string representations of column indices. You only need to include the specific column indices and corresponding values of the columns you want to update (and remember: the columns are zero-indexed)

Examples
{ "1": "scott2@slack.tld" }

Optional input parameters

cell_valuestringOptional

The cell value to look for in the column provided by column_name to determine which row to update

Output parameters​

Required output parameters

column_valuesobjectRequired

Column values

spreadsheet_urlstringRequired

Spreadsheet URL

timestamp_completedslack#/types/timestampRequired

Time when step ended

timestamp_startedslack#/types/timestampRequired

Time when step started

Authentication​

End-user authentication

User workflows that include a connector function relying on end-user authentication can only be started with a link trigger.

{
  "google_access_token": {
    "credential_source": "END_USER"
  }
}

End-user experience: User will be prompted to link their external account via OAuth when they first start the workflow that contains this connector.

Developer experience: Developer does not have to implement authentication in the app.

Usage info​

First, import Connectors from deno-slack-hub into your project's import_map.json file, like this:

import_map.json
{
    "imports": {
      "deno-slack-hub/": "https://deno.land/x/deno_slack_hub@2.2.0/",
      "deno-slack-sdk/": "https://deno.land/x/deno_slack_sdk@2.14.2/",
      "deno-slack-api/": "https://deno.land/x/deno_slack_api@2.8.0/"
    }
  }

Next, import Connectors at the top of your workflow's definition file:

my_workflow_file.ts
import { Connectors } from "deno-slack-hub/mod.ts";

Finally, add the connector as a step in your workflow just like you would a Slack function.

my_workflow_file.ts
SomeWorkflow.addStep(
  Connectors.GoogleSheets.functions.UpdateSpreadsheetRow, {
  //...

🧙🏼 Your admin may need to approve the connector first. If your workspace has been configured to only allow admin-approved apps, the CLI will prompt you to send an admin approval request the first time you try to use a connector that hasn't been approved by an admin yet. While waiting for admin approval, the CLI may report an error like this:

Workflow function X is referring to an unknown step output parameter Y

You can safely ignore this error; it will go away as soon as your workspace admin approves your request to use the connector.