When a message is posted on Slack, add it to Google Sheets and send a notification via email if it contains specific phrases.
When a message is posted on Slack, add it to Google Sheets and send a notification via email if it contains specific phrases.
Launch this workflow to connect
Slack &
Google Sheets
!
■Overview
This flow adds messages posted on Slack to Google Sheets and sends email notifications if specific phrases are included.
By using Yoom, you can easily integrate apps without programming.
■Recommended for
1. People who use Slack for work
・Those who utilize Slack as a primary communication tool within their team
・Those who want to sync Slack message content with other tools for analysis and search
2. People who use Google Sheets for work
・Those who want to consolidate information from other tools into Google Sheets for organization and management
・Those who want to reduce the effort of manual entry and lighten their workload
3. People who use email for work
・Those who use email notifications to prevent missing important information
■Benefits of using this template
Messages posted in the specified Slack channel are automatically synced to Google Sheets.
Additionally, if the message body contains words indicating urgency, you will be notified by email.
By eliminating the need for manual entry, the burden on the person in charge is reduced, leading to improved accuracy in information sharing.
■Notes
・Please integrate Slack and Google Sheets with Yoom.
・Branching is a feature (operation) available with the Mini Plan or higher. If you are on the Free Plan, the operations set in the flow bot will result in an error, so please be careful.
・Paid plans such as the Mini Plan offer a 2-week free trial. During the free trial, you can use restricted apps and features (operations).
・Triggers can be set to activate at intervals of 5, 10, 15, 30, or 60 minutes.
・Please note that the shortest activation interval varies depending on the plan.
Check Out Similar Templates!
Activate the flow bot at the end of each month and notify Slack.
This is a flow bot that automatically activates at the end of each month and sends notifications via Slack. This flow bot can perform various automated processes through the flows added after the branch on the right side. For example, you can use it for various purposes such as monthly invoice issuance, aggregation processing to spreadsheets, or regular data backup processing.
Add inquiry content from Slack to Google Sheets
When an inquiry comes to Slack, it is registered in Google Sheets. By integrating Slack and Google Sheets, you can eliminate the hassle of operating individual apps and repeatedly entering data, allowing for smoother business operations. Records can be easily added to Google Sheets automatically, preventing any omissions or leaks in information management.
Analyze Slack post messages with Gemini and send warnings for inappropriate remarks.
The workflow involves real-time analysis of Slack messages using Gemini, automatically sending a warning message when inappropriate language is detected. This helps maintain healthy team communication and enables swift response when issues arise.
Automatically retrieve the product rankings from the in-house product category every day and notify via Slack.
Every day, this flow automatically retrieves the product rankings for our company's listed categories and sends notifications to Slack. By using this flow, you can automatically receive the necessary information daily. This eliminates the need for manual data collection, thereby improving work efficiency and contributing to increased productivity.
See more
About the Apps
Templates using
Slack
This is a flow bot that automatically activates at the end of each month and sends notifications via Slack. This flow bot can perform various automated processes through the flows added after the branch on the right side. For example, you can use it for various purposes such as monthly invoice issuance, aggregation processing to spreadsheets, or regular data backup processing.
This is a business workflow that automatically adds content posted in a Slack channel as comments to tasks in Wrike. This reduces manual task updates and improves project management efficiency.
When an inquiry comes to Slack, it is registered in Google Sheets. By integrating Slack and Google Sheets, you can eliminate the hassle of operating individual apps and repeatedly entering data, allowing for smoother business operations. Records can be easily added to Google Sheets automatically, preventing any omissions or leaks in information management.
Templates using
Google Sheets
A workflow to generate invoices using Google Sheets with the information entered in the form, and send them after approval.
Once the billing information is filled out in the form, an invoice will be generated using the Google Spreadsheet invoice template. After that, it will undergo approval by the person in charge, and an email will be sent.
This is a flow for adding order information to WooCommerce when a row is added in Google Sheets. This flow significantly reduces manual effort and saves the time previously spent on registration, allowing you to focus on more important tasks and improving productivity.
You can add a new tab to a Google Spreadsheet at the beginning of each month. By being able to add a new sheet to a specific Google Spreadsheet at the start of each month, you can avoid forgetting to add sheets and prevent unnecessary rework.
About the apps you use
Slack
Yoom allows you to utilize Slack's API without any coding. By integrating Yoom with Slack, you can freely connect various SaaS with Slack and receive all kinds of notifications on Slack. Additionally, it is possible to trigger a bot when a message is sent to Slack.
see detailsTemplates
This is a flow bot that automatically activates at the end of each month and sends notifications via Slack. This flow bot can perform various automated processes through the flows added after the branch on the right side. For example, you can use it for various purposes such as monthly invoice issuance, aggregation processing to spreadsheets, or regular data backup processing.
Activate the flow bot at the end of each month and notify Slack.
This is a business workflow that automatically adds content posted in a Slack channel as comments to tasks in Wrike. This reduces manual task updates and improves project management efficiency.
Add a comment to a Wrike task when a post is made in a Slack channel.
When an inquiry comes to Slack, it is registered in Google Sheets. By integrating Slack and Google Sheets, you can eliminate the hassle of operating individual apps and repeatedly entering data, allowing for smoother business operations. Records can be easily added to Google Sheets automatically, preventing any omissions or leaks in information management.
Add inquiry content from Slack to Google Sheets
Google Sheets
At Yoom, you can utilize the Google Sheets API without any coding. By integrating Sheets with Yoom, you can automate data entry into spreadsheets and automatically create documents based on spreadsheet templates. Additionally, you can sync spreadsheet information with Yoom's database for various applications.
see detailsTemplates
A workflow to generate invoices using Google Sheets with the information entered in the form, and send them after approval.
Once the billing information is filled out in the form, an invoice will be generated using the Google Spreadsheet invoice template. After that, it will undergo approval by the person in charge, and an email will be sent.
A workflow to generate invoices using Google Sheets with the information entered in the form, and send them after approval.
This is a flow for adding order information to WooCommerce when a row is added in Google Sheets. This flow significantly reduces manual effort and saves the time previously spent on registration, allowing you to focus on more important tasks and improving productivity.
Add order information to WooCommerce when a row is added in Google Sheets.
You can add a new tab to a Google Spreadsheet at the beginning of each month. By being able to add a new sheet to a specific Google Spreadsheet at the start of each month, you can avoid forgetting to add sheets and prevent unnecessary rework.
Add a new tab to the Google Spreadsheet at the beginning of each month.
No-Code API Actions
Executable API actions
Flowbot triggers
When a message is posted to a channel
When a file is posted to a channel
When a message is posted to a channel (Webhook)
When a reaction is added to a message (Webhook)
When a user is mentioned in a channel
When a message containing specified text is posted to a channel
When your Slack app is mentioned (Webhook)
When mentioned in a channel (multiple users)
When a message containing specified text is posted to a channel (Regular expression)
When a new channel is created (Webhook)
When a message is posted in a thread (Webhook)
When mentioned in a channel (multiple users & user groups)
When a reaction is removed from a message (Webhook)
When a row is added
When a row is updated
Flowbot operations
Send message to channel
Send direct message
Get member IDs in a channel
Create channel
Invite members to channel
Get user group list
Post message to thread
Archive channel
Get messages in a thread
List public channels
Remove a member from a private channel
Find user by email address
Get user info
Get a specific message
Get message link
Delete message
Get users in a user group
Get reactions for a message
Flowbot triggers
When a message is posted to a channelWhen a file is posted to a channelWhen a message is posted to a channel (Webhook)When a reaction is added to a message (Webhook)When a user is mentioned in a channelWhen a message containing specified text is posted to a channelWhen your Slack app is mentioned (Webhook)When mentioned in a channel (multiple users)When a message containing specified text is posted to a channel (Regular expression)When a new channel is created (Webhook)When a message is posted in a thread (Webhook)When mentioned in a channel (multiple users & user groups)When a reaction is removed from a message (Webhook)
Flowbot operations
Send message to channelSend direct messageGet member IDs in a channelCreate channelInvite members to channelGet user group listPost message to threadArchive channelGet messages in a threadList public channelsRemove a member from a private channelFind user by email addressGet user infoGet a specific messageGet message linkDelete messageGet users in a user groupGet reactions for a messageCreate a user groupList channel messagesSend a message to a channel with attachmentsList rows in a listCreate listUpdate listGet a specific list rowRemove list access
Flowbot triggers
When a row is addedWhen a row is updated
Flowbot operations
Set a value in a cellGet valuesClear valuesCreate a new spreadsheetCopy a sheet (tab)Add a new sheet (tab)Delete Sheet (Tab)Replace valuesUpdate Sheet NameDelete RowsGet Spreadsheet InfoGet sheet namesApply a formula to a rangeEnter values in a rangeEmbed an image in a cellSort by specific columnHide a sheetAdd a note to the specified cellsInsert columnsDelete columnsWrite values to multiple columnsMore inspiration for you
Discover step-by-step guides for automating your work using the apps featured in this workflow!
