Skip to main content

add_spreadsheet_row

Facts

DescriptionAdd to spreadsheet
SchemaConnectors.GoogleSheets.functions.AddSpreadsheetRow
ServiceGoogle Sheets

Input parameters

Required input parameters

columnsobjectRequired

An object where each key is a string containing a numerical index representing a column. The corresponding values are the content associated with the individual cells in those columns. The keys, in this case, serve as string representations of column indices.

Examples
{"0": "Scott Slacksalot","1": "scott.slacksalot@slack.tld"}
google_access_tokenslack#/types/credential/oauth2Required

Google Access token. See the authentication section for details.

sheet_titlestringRequired

The title of the sheet where the columns can be found

Examples
Sandra's reacjis
spreadsheet_idstringRequired

The ID of the spreadsheet

Examples
1234567890_abcdefg_1q2w3e4r5t6y7u

Output parameters

Required output parameters

spreadsheet_idstringRequired

Spreadsheet ID

spreadsheet_urlstringRequired

Spreadsheet URL

timestamp_completedslack#/types/timestampRequired

Time when step ended

timestamp_startedslack#/types/timestampRequired

Time when step started

Optional output parameters

column_valuesobjectOptional

An object containing the column values of the newly added spreadsheet row

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.AddSpreadsheetRow, {
  //...

🧙🏼 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.