← Google Drive + Slack integrations

Send Message to a Private Channel with Slack API on New Spreadsheet (Instant) from Google Drive API

Pipedream makes it easy to connect APIs for Slack, Google Drive and 800+ other apps remarkably fast.

Trigger workflow on
New Spreadsheet (Instant) from the Google Drive API
Next, do this
Send Message to a Private Channel with the Slack API
No credit card required
Into to Pipedream
Watch us build a workflow
Watch us build a workflow
7 min
Watch now ➜
Trusted by 250,000+ developers from startups to Fortune 500 companies:
Trusted by 250,000+ developers from startups to Fortune 500 companies

Developers Pipedream

Getting Started

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

  1. Select this integration
  2. Configure the New Spreadsheet (Instant) trigger
    1. Connect your Google Drive account
    2. Select a Drive
    3. Optional- Configure Watch for changes to file properties
    4. Configure Push notification renewal schedule
    5. Optional- Select one or more Folders
  3. Configure the Send Message to a Private Channel action
    1. Connect your Slack account
    2. Optional- Configure Send as User
    3. Optional- Configure Bot Username
    4. Optional- Configure Icon (emoji)
    5. Optional- Configure Icon (image URL)
    6. Optional- Configure Schedule message
    7. Optional- Configure Include link to workflow
    8. Optional- Configure Metadata Event Type
    9. Optional- Configure Metadata Event Payload
    10. Select a Channel
    11. Configure Text
    12. Optional- Configure Send text as Slack mrkdwn
  4. Deploy the workflow
  5. Send a test event to validate your setup
  6. Turn on the trigger

Details

This integration uses pre-built, open source 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

Description:Emit new event each time a new spreadsheet is created in a drive.
Version:0.0.12
Key:google_sheets-new-spreadsheet

Trigger Code

import newFilesInstant from "../../../google_drive/sources/new-files-instant/new-files-instant.mjs";

export default {
  ...newFilesInstant,
  key: "google_sheets-new-spreadsheet",
  type: "source",
  name: "New Spreadsheet (Instant)",
  description: "Emit new event each time a new spreadsheet is created in a drive.",
  version: "0.0.12",
  hooks: {
    ...newFilesInstant.hooks,
    async deploy() {
      // Emit sample records on the first run
      const spreadsheets = await this.getSpreadsheets(10);
      for (const fileInfo of spreadsheets) {
        const createdTime = Date.parse(fileInfo.createdTime);
        this.$emit(fileInfo, {
          summary: `New File: ${fileInfo.name}`,
          id: fileInfo.id,
          ts: createdTime,
        });
      }
    },
  },
  methods: {
    ...newFilesInstant.methods,
    shouldProcess(file) {
      return (
        file.mimeType.includes("spreadsheet") &&
        newFilesInstant.methods.shouldProcess.bind(this)(file)
      );
    },
    getSpreadsheetsFromFolderOpts(folderId) {
      const mimeQuery = "mimeType = 'application/vnd.google-apps.spreadsheet'";
      let opts = {
        q: `${mimeQuery} and parents in '${folderId}' and trashed = false`,
      };
      if (!this.isMyDrive()) {
        opts = {
          corpora: "drive",
          driveId: this.getDriveId(),
          includeItemsFromAllDrives: true,
          supportsAllDrives: true,
          ...opts,
        };
      }
      return opts;
    },
    async getSpreadsheets(limit) {
      const spreadsheets = [];
      const foldersIds = this.folders;
      for (const folderId of foldersIds) {
        const opts = this.getSpreadsheetsFromFolderOpts(folderId);
        const filesWrapper = await this.googleDrive.listFilesInPage(null, opts);
        for (const file of filesWrapper.files) {
          const fileInfo = await this.googleDrive.getFile(file.id);
          spreadsheets.push(fileInfo);
          if (spreadsheets.length >= limit) { return spreadsheets; }
        }
      }
      return spreadsheets;
    },
  },
};

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.
LabelPropTypeDescription
Google DrivegoogleDriveappThis component uses the Google Drive app.
N/Adb$.service.dbThis component uses $.service.db to maintain state between component invocations.
N/Ahttp$.interface.httpThis component uses $.interface.http to generate a unique URL when the component is first instantiated. Each request to the URL will trigger the run() method of the component.
DrivedrivestringSelect a value from the drop down menu.
Watch for changes to file propertieswatchForPropertiesChangesboolean

Watch for changes to file properties
in addition to changes to content. Defaults to false, watching for only changes to content.

Push notification renewal scheduletimer$.interface.timer

The Google Drive API requires occasional renewal of push notification subscriptions. This runs in the background, so you should not need to modify this schedule.

Foldersfoldersstring[]Select a value from the drop down menu.

Trigger Authentication

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

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

emailprofilehttps://www.googleapis.com/auth/drivehttps://www.googleapis.com/auth/drive.readonly

About Google Drive

Internet-related services and products

Action

Description:Send a message to a private channel and customize the name and avatar of the bot that posts the message. See [postMessage](https://api.slack.com/methods/chat.postMessage) or [scheduleMessage](https://api.slack.com/methods/chat.scheduleMessage) docs here
Version:0.2.7
Key:slack-send-message-private-channel

Action Code

import common from "../common/send-message.mjs";

export default {
  ...common,
  key: "slack-send-message-private-channel",
  name: "Send Message to a Private Channel",
  description: "Send a message to a private channel and customize the name and avatar of the bot that posts the message. See [postMessage](https://api.slack.com/methods/chat.postMessage) or [scheduleMessage](https://api.slack.com/methods/chat.scheduleMessage) docs here",
  version: "0.2.7",
  type: "action",
  props: {
    ...common.props,
    conversation: {
      propDefinition: [
        common.props.slack,
        "privateChannel",
      ],
    },
    text: {
      propDefinition: [
        common.props.slack,
        "text",
      ],
    },
    mrkdwn: {
      propDefinition: [
        common.props.slack,
        "mrkdwn",
      ],
    },
    username: {
      propDefinition: [
        common.props.slack,
        "username",
      ],
      description: "Optionally customize your bot's username (default is `Pipedream`).",
    },
    icon_emoji: {
      propDefinition: [
        common.props.slack,
        "icon_emoji",
      ],
      description: "Optionally use an emoji as the bot icon for this message (e.g., `:fire:`). This value overrides `icon_url` if both are provided.",
    },
    icon_url: {
      propDefinition: [
        common.props.slack,
        "icon_url",
      ],
      description: "Optionally provide an image URL to use as the bot icon for this message.",
    },
  },
};

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.

LabelPropTypeDescription
SlackslackappThis component uses the Slack app.
Send as Useras_userboolean

Optionally pass TRUE to post the message as the authed user, instead of as a bot. Defaults to FALSE.

Bot Usernameusernamestring

Optionally customize your bot's username (default is Pipedream).

Icon (emoji)icon_emojistring

Optionally use an emoji as the bot icon for this message (e.g., :fire:). This value overrides icon_url if both are provided.

Icon (image URL)icon_urlstring

Optionally provide an image URL to use as the bot icon for this message.

Schedule messagepost_atinteger

Messages can only be scheduled up to 120 days in advance, and cannot be scheduled for the past. The datetime format should be a unix timestamp (e.g., 1650507616, see here for help with this format).

Include link to workflowinclude_sent_via_pipedream_flagboolean

Defaults to true, includes a link to the workflow at the end of your Slack message.

Metadata Event Typemetadata_event_typestring

The name of the metadata event

Metadata Event Payloadmetadata_event_payloadstring

The payload of the metadata event. Must be a JSON string e.g. {"key": "value"}

ChannelconversationstringSelect a value from the drop down menu.
Texttextstring

Text of the message to send (see Slack's formatting docs). This field is usually necessary, unless you're providing only attachments instead.

Send text as Slack mrkdwnmrkdwnboolean

TRUE by default. Pass FALSE to disable Slack markup parsing. See docs here

Action Authentication

Slack uses OAuth authentication. When you connect your Slack account, Pipedream will open a popup window where you can sign into Slack 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 API.

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

bookmarks:writecalls:readcalls:writechannels:historychannels:readchannels:writednd:readdnd:writeemoji:readfiles:readgroups:historygroups:readgroups:writeim:historyim:readim:writelinks:readlinks:writempim:historympim:readmpim:writepins:readpins:writereactions:readreactions:writereminders:readreminders:writeremote_files:readremote_files:sharestars:readstars:writeteam:readusergroups:readusergroups:writeusers:readusers:read.emailusers:writechat:write:botchat:write:usercommandsfiles:write:userusers.profile:writeusers.profile:readsearch:read

About Slack

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.

More Ways to Connect Slack + Google Drive