Add Row to Sheet with Smartsheet API on New Reaction Added (Instant) from Slack (legacy) API

Pipedream makes it easy to connect APIs for Smartsheet, Slack (legacy) and 2,900+ other apps remarkably fast.

Trigger workflow on

New Reaction Added (Instant) from the Slack (legacy) API

Next, do this

Add Row to Sheet with the Smartsheet API

No credit card required

▶

Watch us build a workflow

8 min

Watch now ➜

Trusted by 1,000,000+ developers from startups to Fortune 500 companies

Developers ♥ Pipedream

Getting Started#

This integration creates a workflow with a Slack (legacy) trigger and Smartsheet action. When you configure and deploy the workflow, it will run on Pipedream's servers 24x7 for free.

Select this integration
Configure the New Reaction Added (Instant) trigger
1. Connect your Slack (legacy) account
2. Optional- Select one or more Channels
3. Configure slackApphook
4. Optional- Configure Ignore Bots
5. Optional- Select one or more Icon (emoji)
6. Optional- Configure Include User Data
Configure the Add Row to Sheet action
1. Connect your Smartsheet account
2. Select a Sheet
3. Optional- Configure To Top
4. Optional- Configure Cells
Deploy the workflow
Send a test event to validate your setup
Turn on the trigger

Details#

This integration uses pre-built, source-available components from Pipedream's GitHub repo. These components are developed by Pipedream and the community, and verified and maintained by Pipedream.

To contribute an update to an existing component or create a new component, create a PR on GitHub. If you're new to Pipedream component development, you can start with quickstarts for trigger span and action development, and then review the component API reference.

Trigger#

New Reaction Added (Instant) on Slack (legacy)

Description:Emit new event when a member has added an emoji reaction to a message

Version:1.1.26

Key:slack-new-reaction-added

View on GitHub

Slack (legacy) Overview#

The Pipedream app for Slack enables you to build event-driven workflows that interact with the Slack API. Once you authorize the app's access to your workspace, you can use Pipedream workflows to perform common Slack actions or write your own code against the Slack API.

The Pipedream app for Slack is not a typical app. You don't interact with it directly as a bot, and it doesn't add custom functionality to your workspace out of the box. It makes it easier to automate anything you'd typically use the Slack API for, using Pipedream workflows.

Automate posting updates to your team channels
Create a bot to answer common questions
Integrate with your existing tools and services
And much more!

Trigger Code#

import common from "../common/base.mjs";
import sampleEmit from "./test-event.mjs";

export default {
  ...common,
  key: "slack-new-reaction-added",
  name: "New Reaction Added (Instant)",
  version: "1.1.26",
  description: "Emit new event when a member has added an emoji reaction to a message",
  type: "source",
  dedupe: "unique",
  props: {
    ...common.props,
    conversations: {
      propDefinition: [
        common.props.slack,
        "conversation",
      ],
      type: "string[]",
      label: "Channels",
      description: "Select one or more channels to monitor for new messages.",
      optional: true,
    },
    // eslint-disable-next-line pipedream/props-description,pipedream/props-label
    slackApphook: {
      type: "$.interface.apphook",
      appProp: "slack",
      async eventNames() {
        if (this.conversations?.length) {
          const conversations = [];
          for (const conversation of this.conversations) {
            conversations.push(`reaction_added:${conversation}`);
          }
          return conversations;
        }

        return [
          "reaction_added",
        ];
      },
    },
    ignoreBot: {
      propDefinition: [
        common.props.slack,
        "ignoreBot",
      ],
    },
    iconEmoji: {
      propDefinition: [
        common.props.slack,
        "icon_emoji",
      ],
      description: "Select one or more emojis to use as a filter. E.g. `fire, email`",
      type: "string[]",
      optional: true,
    },
    includeUserData: {
      label: "Include User Data",
      description: "Include user object in the response. Default `false`",
      type: "boolean",
      optional: true,
      default: false,
    },
  },
  methods: {
    ...common.methods,
    getSummary() {
      return "New reaction added";
    },
    async processEvent(event) {
      let iconEmojiParsed = [];

      try {
        iconEmojiParsed = typeof this.iconEmoji === "string" ?
          JSON.parse(this.iconEmoji) :
          this.iconEmoji;
      } catch (error) {
        iconEmojiParsed = this.iconEmoji.replace(/\s+/g, "").split(",");
      }

      if (
        ((this.ignoreBot) && (event.subtype == "bot_message" || event.bot_id)) ||
        (iconEmojiParsed?.length > 0 && !iconEmojiParsed.includes(event.reaction))
      ) {
        return;
      }

      if (this.includeUserData) {
        const userResponse = await this.slack.usersInfo({
          user: event.user,
        });
        const itemUserResponse = await this.slack.usersInfo({
          user: event.user,
        });

        event.userInfo = userResponse.user;
        event.itemUserInfo = itemUserResponse.user;
      }

      event.message = await this.getMessage({
        channel: event.item.channel,
        event_ts: event.item.ts,
      });

      return event;
    },
  },
  sampleEmit,
};

Trigger Configuration#

This component may be configured based on the props defined in the component code. Pipedream automatically prompts for input values in the UI and CLI.

Label	Prop	Type	Description
Slack (legacy)	`slack`	`app`	This component uses the Slack (legacy) app.
N/A	`db`	`$.service.db`	This component uses `$.service.db` to maintain state between executions.
Channels	`conversations`	`string[]`	Select a value from the drop down menu.
	`slackApphook`	`$.interface.apphook`
Ignore Bots	`ignoreBot`	`boolean`	Ignore messages from bots
Icon (emoji)	`iconEmoji`	`string[]`	Select a value from the drop down menu.
Include User Data	`includeUserData`	`boolean`	Include user object in the response. Default `false`

Trigger Authentication#

Slack (legacy) uses OAuth authentication. When you connect your Slack (legacy) account, Pipedream will open a popup window where you can sign into Slack (legacy) and grant Pipedream permission to connect to your account. Pipedream securely stores and automatically refreshes the OAuth tokens so you can easily authenticate any Slack (legacy) API.

Pipedream requests the following authorization scopes when you connect your account:

channels:historychannels:readchannels:writeemoji:readgroups:historygroups:readgroups:writeim:historyim:readim:writelinks:readlinks:writempim:historympim:readmpim:writereactions:readreactions:writereminders:readreminders:writestars:readteam:readusergroups:readusergroups:writeusers:readusers:read.emailusers:writechat:write:botchat:write:userfiles:write:userfiles:readcommandsusers.profile:writeusers.profile:readsearch:read

About Slack (legacy)#

Slack is a channel-based messaging platform. With Slack, people can work together more effectively, connect all their software tools and services, and find the information they need to do their best work — all within a secure, enterprise-grade environment.

Action#

Add Row to Sheet on Smartsheet

Description:Adds a row to a sheet. [See docs here](https://smartsheet.redoc.ly/tag/rows#operation/rows-addToSheet)

Version:0.0.3

Key:smartsheet-add-row-to-sheet

View on GitHub

Smartsheet Overview#

The Smartsheet API unlocks the power of managing and automating complex workflows, directly interacting with Smartsheet's features such as sheets, rows, columns, and attachments. You can create, read, update, and delete sheets, share them with others, and extract complex data reports. Leveraging the API on Pipedream allows for seamless integration with other services for enhanced productivity and data management. Whether you're orchestrating an approval process, syncing data across platforms, or automating project tracking, the Smartsheet API pairs with Pipedream's serverless platform to build powerful, scalable, and automated workflows.

Action Code#

import smartsheet from "../../smartsheet.app.mjs";

export default {
  key: "smartsheet-add-row-to-sheet",
  name: "Add Row to Sheet",
  description: "Adds a row to a sheet. [See docs here](https://smartsheet.redoc.ly/tag/rows#operation/rows-addToSheet)",
  version: "0.0.3",
  annotations: {
    destructiveHint: false,
    openWorldHint: true,
    readOnlyHint: false,
  },
  type: "action",
  props: {
    smartsheet,
    sheetId: {
      propDefinition: [
        smartsheet,
        "sheetId",
      ],
      reloadProps: true,
    },
    toTop: {
      type: "boolean",
      label: "To Top",
      description: "Set to `true` to add new row to the top of the sheet",
      optional: true,
      default: false,
    },
    cells: {
      type: "string[]",
      label: "Cells",
      description: "Array of objects representing cell values. Use to manually create row when `sheetId` is entered as a custom expression. Example: `{{ [{\"columnId\": 7960873114331012,\"value\": \"New status\"}] }}`",
      optional: true,
    },
  },
  async additionalProps() {
    const props = {};
    const { data: columns } = await this.smartsheet.listColumns(this.sheetId, {
      params: {
        include: "columnType",
      },
    });
    if (!columns) {
      return props;
    }
    for (const column of columns) {
      props[column.id] = {
        type: "string",
        label: column.title,
        description: column?.description || "Enter the column value",
        optional: true,
      };
      if (column.type.includes("CONTACT_LIST")) {
        props[column.id] = {
          ...props[column.id],
          options: async ({ page }) => {
            const { data } = await this.smartsheet.listContacts({
              params: {
                page,
              },
            });
            return data?.map(({ email }) => email ) || [];
          },
        };
      }
      else if (column?.options) {
        props[column.id].options = column.options;
      }
    }
    return props;
  },
  async run({ $ }) {
    const {
      sheetId,
      toTop,
      cells = [],
      smartsheet,
      ...columnProps
    } = this;

    const data = {
      cells: [],
    };
    if (toTop) {
      data.toTop = true;
    }
    for (const cell of cells) {
      const cellValue = typeof cell === "object"
        ? cell
        : JSON.parse(cell);
      data.cells.push(cellValue);
    }
    for (const key of Object.keys(columnProps)) {
      data.cells.push({
        columnId: key,
        value: columnProps[key],
      });
    }

    const response = await smartsheet.addRow(sheetId, {
      data,
      $,
    });

    $.export("$summary", `Successfully created row with ID ${response.result.id}`);

    return response;
  },
};

Action Configuration#

This component may be configured based on the props defined in the component code. Pipedream automatically prompts for input values in the UI.

Label	Prop	Type	Description
Smartsheet	`smartsheet`	`app`	This component uses the Smartsheet app.
Sheet	`sheetId`	`integer`	Select a value from the drop down menu.
To Top	`toTop`	`boolean`	Set to `true` to add new row to the top of the sheet
Cells	`cells`	`string[]`	Array of objects representing cell values. Use to manually create row when `sheetId` is entered as a custom expression. Example: `{{ [{"columnId": 7960873114331012,"value": "New status"}] }}`

Action Authentication#

Smartsheet uses OAuth authentication. When you connect your Smartsheet account, Pipedream will open a popup window where you can sign into Smartsheet and grant Pipedream permission to connect to your account. Pipedream securely stores and automatically refreshes the OAuth tokens so you can easily authenticate any Smartsheet API.

Pipedream requests the following authorization scopes when you connect your account:

ADMIN_SHEETSADMIN_SIGHTSADMIN_USERSADMIN_WEBHOOKSADMIN_WORKSPACESCREATE_SHEETSCREATE_SIGHTSDELETE_SHEETSDELETE_SIGHTSREAD_CONTACTSREAD_SHEETSREAD_SIGHTSREAD_USERSSHARE_SHEETSSHARE_SIGHTSWRITE_SHEETS

Add Row to Sheet with Smartsheet API on New Reaction Added (Instant) from Slack (legacy) API

Pipedream makes it easy to connect APIs for Smartsheet, Slack (legacy) and 2,900+ other apps remarkably fast.

Trusted by 1,000,000+ developers from startups to Fortune 500 companies

Developers ♥ Pipedream

1-24of2,900+apps by most popular

1
-
24
of
2,900+
apps by most popular