Google Sheets, Slack Integrations

Google Sheets
Slack
Try Integromat for FREE
No credit card. You'll love it.

What is Integromat?

GmailWatch emailsGoogle SheetsAdd a rowGmailIterate attachmentsRouterFacebookCreate a postArchiveCreate an archiveDropboxUpload a fileDocuments onlyImages onlyWhen new email arrivesAdd a row to a sheetProcess attachmentsone by one ...Post images to pageZip all documentsUpload archive

Integromat will automate processes that you currently handle manually. It is not only capable of connecting apps but can also transfer and transform data. It works 24 hours a day, seven days a week and does not require your intervention. Simply set Integromat to do what you want and let it work for you. Save your time!

Google Sheets, Slack integrations

Create a link for a new file in Egnyte and share it with specified people from list stored in Google Sheets

Create a link for a new file in Egnyte and share it with specified people from list stored in Google Sheets

When a new file is saved in Egnyte, Integromat checks which people should have access to the file in Google Sheets. This template in Google Sheets was used. All the files must have the naming convention "nameOfTheProject_nameOfTheFile". After the list of filtered people is retrieved, the file links are created for the people and the links are sent to their e-mails. The generated password is then sent in private message to the concrete people via Slack.


9
Add Slack client info with e-mail to Google Sheets spreadsheet with client contacts

Add Slack client info with e-mail to Google Sheets spreadsheet with client contacts

When a Slack message is sent in a specified channel, the scenario checks the Google sheet with addresses. If it’s already there, it does nothing. But if it’s not there, the scenario adds the new email to the list. More information here.


2
Add or delete leaves from Google Calendar in Status Hero

Add or delete leaves from Google Calendar in Status Hero

When a new leave in shared Google calendar is added or the leave is prolonged, the dates of the leave are uploaded in Status Hero. Conversely, when a leave is deleted, the dates in Status Hero are cancelled. Please ensure that employees in case of shortening the length of their leave first delete all the leave and then upload updated shorter leave! Otherwise the deleted days will not be cancelled in Status Hero.


1
Create a Taxpayer's Signature Code (PKP) from new Google Sheets rows and post it to Slack

Create a Taxpayer's Signature Code (PKP) from new Google Sheets rows and post it to Slack

Every time you add a new row to your Google Sheets spreadsheet, Integromat will automatically generate a Taxpayer's Signature Code (PKP) using the EET module and post it to Slack. The template uses this example spreadsheet.


0
Create new Google Sheets rows from Formstack submissions, verifying the email by Zerobounce, and sending on slack

Create new Google Sheets rows from Formstack submissions, verifying the email by Zerobounce, and sending on slack

Every time a new Formstack form is submitted, Integromat will automatically validate the email with ZeroBounce. If the status of the email is "valid" it will look the person up with Clearbit. If a result is returned it will add a row in a Google Sheet and send a Slack message. This example uses the sheet in this link. It will also look the company up with Clearbit. If a result is returned it will add a new row to a Google Sheet and send a Slack message. This example uses the sheet in this link.


0

Triggers

Google Sheets

Perform a Function INSTANT

Receives data passed to the function INTEGROMAT used in a sheet. Sheets Add-On required.

Google Sheets

Watch Changes INSTANT

Triggers when a cell is updated. Watches only changes made in Google Sheet app. Sheets Add-On required.

Google Sheets

Watch Rows

Watches for new rows.

Slack

New Message INSTANT

Triggers when a new message is created.

Slack

Watch Direct Messages

Triggers when a new message is added to a direct message channel.

Slack

Watch Files

Triggers when a new file is added.

Slack

Watch Multiparty Direct Messages

Triggers when a new message is added to a multiparty direct message channel.

Slack

Watch Private Channel Messages

Triggers when a new message is added to a private channel.

Slack

Watch Public Channel Messages

Triggers when a new message is added to a public channel.

Slack

Watch Users

Triggers when a new user is added.

Actions

Google Sheets

Add a Row

Appends a new row to the bottom of the table.

Google Sheets

Add a Sheet

Adds a new sheet.

Google Sheets

Clear a Cell

Cleares a specific cell.

Google Sheets

Clear a Row

Clears values from a specific row.

Google Sheets

Create a Spreadsheet

Creates a new spreadsheet.

Google Sheets

Delete a Row

Deletes a specific row.

Google Sheets

Delete a Sheet

Deletes a specific sheet.

Google Sheets

Get a Cell

Gets a specific cell.

Google Sheets

Perform a Function - Responder

Returns processed data as a result of the INTEGROMAT function. Sheets Add-On required.

Google Sheets

Update a Cell

Updates a specific cell.

Google Sheets

Update a Row

Updates a row.

Slack

Add a Star

Adds a star to an item (message, file, channel or DM) on behalf of the authenticated user.

Slack

Archive a Channel

Archives a channel.

Slack

Complete a Reminder

Completes a reminder.

Slack

Create a Channel

Creates a channel.

Slack

Create a Message

Creates a message.

Slack

Create a Reminder

Creates a reminder.

Slack

Create a Text File

Creates a text file.

Slack

Delete a File

Deletes a file.

Slack

Delete a Message

Removes a message.

Slack

Delete a Reminder

Deletes a reminder.

Slack

Download a File

Downloads a file.

Slack

Get a File

Returns information about a file in your team.

Slack

Get a Channel

Returns information about a workspace channel.

Slack

Get a Private Channel Message

Returns a message with a given ID from a specified private channel.

Slack

Get a Public Channel Message

Returns a message with a given ID from a specified public channel.

Slack

Get a Reminder

Returns information about a reminder.

Slack

Get a User

Returns information about a member of a workspace.

Slack

Invite Users

Invites 1-30 users to a public or private channel.

Slack

Join a Channel

Joins to an existing channel.

Slack

Kick a User

Removes a user from a channel.

Slack

Leave a Channel

Leaves a channel.

Slack

Make an API Call

Performs an arbitrary authorized API call.

Slack

Remove a Star

Removes a star from an item (message, file, channel, private group, or DM) on behalf of the authenticated user.

Slack

Search for User

Retrieves a single user by looking them up by their registered email address.

Slack

Set a Status

Update a user's current status.

Slack

Set the Purpose of a Channel

Changes the purpose of a channel.

Slack

Set the Topic of a Channel

Changes the topic of a channel.

Slack

Unarchive a Channel

Unarchives a channel.

Slack

Update a Message

Updates a message.

Slack

Upload a File

Creates or uploads a file.

Searches

Google Sheets

Get Range Values

Gets a range content.

Google Sheets

List Sheets

Gets a list of all sheets in a spreadsheet.

Google Sheets

Search Rows

Returns results matching the given criteria.

Google Sheets

Search Rows (Advanced)

Returns results matching the given criteria. This module doesn't return a row number.

Slack

List Files

Returns a list of files within the team.

Slack

List Channels

Returns a list of all channels in a workspace.

Slack

List Members in Channel

Retrieve members of a channel.

Slack

List Reminders

Lists all reminders created by or for a given user.

Slack

List Replies

Retrieves a thread of messages posted to a conversation.

Slack

List Users

Returns a list of all users in the workspace.

Slack

Search for Message

Returns messages matching a search query.

Integrate Google Sheets, Slack with these services