How to Notify Slack When a Row is Updated in Google Sheets

Step 2: Set Triggers and Actions

‍This time, we will use the template provided above.
Once you open the template page, click Try this template.
If you are using Yoom, please log in, and if you are new, please register.
As you proceed, the template will be copied to your workspace.
You can also change the name of the template.
Click on My Projects on the left to see the template you just copied.
Click the ellipsis (...) on the right and select Edit.

This time, there are two steps.
Let's set it up together!

First, let's prepare the Google Spreadsheet.
This time, we have prepared the following items and responses.
It's an image of managing the progress of application content.

Now, let's set up the app trigger.
Select "When a row is updated".
Check the account information to be linked.
Keep the action as it is and proceed to the next step.
On the next screen, set the following items.
Please note that there is a limit to the range of tables that can be set for each plan.
For details, please refer to the setting method in the image.

• Trigger Interval: You can choose from intervals of 5 minutes, 10 minutes, 15 minutes, 30 minutes, and 60 minutes.
  ※ The selection of intervals varies depending on the plan.
• Spreadsheet ID and Sheet ID: Please select from the candidates.

• Table Range (Start): If you want the table range to be from A to H, specify "A".
• Table Range (End): If you want the table range to be from A to H, specify "H".
• Column with Unique Values: Select the column name that contains unique values, such as email addresses or IDs, which do not duplicate within the column (the column that becomes the unique key). Example: A
• Column to Detect Updates: Specify the column name to detect updates.
  When the value in the specified column is updated, the flow bot will be activated. Example: D

Test → Save if the test is successful.
Next, click Send a message to the channel.
Again, check the account information to be linked.
Keep the action as it is and proceed to the next step.
On the next screen, set the following items.

• Channel ID to Post: You can select from the candidates.
  The channel ID will be something like "C02U49NMLQ4".
  ※ Please refer to here to add Yoom in the "Integration" section of the relevant channel in advance.

• Message: This time, we quoted the output and set it as follows.
  By writing <@Member ID>, you can also add a mention.

Once selected, test it.
Let's take a look at Slack.

You can see the message properly!
Finally, turn on the app trigger to complete.
Thank you for your hard work.
Even I, who am not familiar with programming, was able to do it!

Other Automation Examples Using Google Sheets and Slack

In addition to the integrations introduced today, various automations can be achieved by utilizing the APIs of Google Sheets and Slack.

If you find something interesting, please give it a try!

‍‍Automation Examples Integrating Google Sheets and Slack

You can set up notifications in Slack when a row is added in Google Sheets or retrieve records from Google Sheets that match today's date and notify Slack. Additionally, it's possible to integrate so that when a row is added in Google Sheets, it is summarized with Gemini and notified to Slack.

Automation Example Using Google Sheets

Register Survey Results Received by Email into Google Sheets

Automatically register survey results received via Gmail or Outlook into Google Sheets.

Use OCR to Read Documents Stored in Cloud Storage and Add Them to Google Sheets

When files are uploaded to services like Google Drive or Dropbox, the content is read using OCR functionality and automatically added to Google Sheets.

Issue documents based on Google Sheets information

Automatically create documents such as Google Docs based on the content registered in Google Sheets.

Automation Example Using Slack

Notify Slack of Inquiry Details

Automatically notify Slack of inquiry details sent via Google Forms or Gmail.

Notify Slack when a request is approved in the workflow

Automatically notify Slack when a request is approved in systems like Notion, Dropbox.

Add content posted on Slack to other apps

Automatically add content posted on Slack to apps like Notion and Microsoft Excel.

Benefits of Integrating Google Sheets with Slack

By integrating the two, you can easily share information and potentially reduce errors that may occur from manual processes.

Benefit 1: Easy and Smooth Information Sharing

By automatically notifying Slack of updates in Google Sheets, the entire team can access the latest information.
<span class="mark-yellow">Since you only need to check Slack notifications, there's no need to repeatedly check Google Sheets for updates, which can improve overall work efficiency.</span>

Benefit 2: Reduction of Manual Work and Error Prevention

Automating manual notification tasks can prevent human errors and improve the accuracy of operations.
<span class="mark-yellow">This automation can be particularly beneficial when dealing with large amounts of data or frequent updates.</span>
By eliminating the need for manual sharing tasks, you can allocate the time saved to other important tasks.

Summary

This time, we introduced a "Flowbot that notifies Slack when a row is updated in Google Sheets."
It might be a convenient flow for those who manage information in Google Sheets but find it cumbersome to check manually.
With notifications sent to Slack every time there's a change in information, you can save the hassle of checking and avoid manual input errors.
While we used Slack to receive messages this time, you can also change it to your preferred app.
With Yoom, you can easily integrate apps without coding, reducing manual work and achieving smooth information sharing.
Take this opportunity to utilize Yoom and advance your business automation.