How to Automatically Add Slack Information to Google Sheets!
How to Integrate Applications
・
2025-04-17
How to Automatically Add Slack Information to Google Sheets!
c.yamada
Managing handwritten data, such as survey results and handwritten notes used in business meetings, can be quite challenging, can't it? To address this issue, you can use AI to capture handwritten data, transcribe it, and convert it into text data! By converting it into text data, you can significantly streamline your operations, making it incredibly convenient.
In this article, we will introduce the benefits of using AI features to extract text from images and provide examples of automation, along with a step-by-step guide on how to create an actual flow bot. If you're looking to improve work efficiency or facilitate smooth information sharing, be sure to give it a try!
Recommended for:
- Those considering improving work efficiency with Google Drive and Google Sheets.
- Those who register document contents saved in Google Drive into Google Sheets.
- Those who want to accurately add the contents of files saved in Google Drive to Google Sheets.
For those who want to try it right away:
In this article, we will introduce how to integrate using the no-code tool "Yoom." No complicated settings or operations are required, making it easy for non-engineers to achieve. You can start immediately using the template below, so be sure to give it a try!
Have you ever just looked at a file attached to Slack and then lost it in the stream of logs, making it hard to find again? Moreover, with the free plan, there is a viewing limit, so you can't check the contents later. However, manually downloading all the files sent daily and immediately sorting them is tedious and low on the task priority list. To solve this issue, I created a flow bot using the Yoom service to manage information sent to Slack in a spreadsheet. Let's link Slack and Google Spreadsheets so you can check Slack information anytime later!
Recommended for
Those who want to centrally manage information with Slack and Google Spreadsheets
Business users who want to streamline file and message searches
Those who want to reduce app switching and improve work efficiency
Project managers who want to keep past logs and share them among teams
Beginners who want to start business automation without API knowledge
For those who want to try it immediately
This article introduces how to link using the no-code tool "Yoom". No complicated settings or operations are required, and even non-engineers can easily achieve it. You can start right away with the template below, so please give it a try!
[About Yoom]
Steps to Automatically Transfer Slack Posts to a Spreadsheet
Preparing Google Spreadsheet
First, prepare a spreadsheet to add Slack messages. Here's how I set it up this time.
It's quite simple. But this level of simplicity makes it easy to view, right? It's recommended to make the spreadsheet with clear items like message, attachment, and URL, as it makes setting up the flowbot easier.
Creating Yoom Workflow
Once the spreadsheet is ready, the next step is to actually create a flowbot in Yoom. Let's start with "My App Integration."
Please integrate the spreadsheet in the same way. Registering Google-related apps is super easy and can be done in no time, so rest assured.
Once the My App Integration is complete, click "Try it" on the banner below.
You will see "Template has been copied", so click "OK".
Workflow Setup Details in Yoom
Using the template, a flowbot named "[Copy] When a message is posted on a Slack channel, add the content to Google Sheets" will be automatically created in My Projects in the menu.
The template provides the framework, so you only need to change the internal settings.
Slack Settings
Press edit at the top right and click on "When a new message is posted to a channel" with the Slack icon.
↓
This time, since we want to manage files, we changed the app trigger title to "When a file is posted to a channel". Feel free to customize it!
↓
Select the account information to link with Slack.
↓
From the trigger action dropdown, select "When a file is posted to a channel" and proceed.
↓
Choose the channel ID.
When a message with a file is sent to the selected channel, it will be added to the spreadsheet. It's recommended to choose a channel where you can send test messages without any issues.
↓
Send a test message. This time, we sent a message, file, and URL as shown below.
Make sure to send all three: message, file, and URL.
↓
Click the test button, and if successful, register the output. If you're wondering "What's that?", just follow the instructions, and you'll be fine. Honestly, I'm not entirely sure myself.
Click Add to add the values to be retrieved.
↓
You'll see a string of English text that might give you a headache, but find "url_private_download" and click the + mark.
This will be the sought-after file download URL that always flows in the logs. You won't miss it anymore.
↓
Next, consider cases where a website URL or spreadsheet URL is attached, and click the URL output to save regular URLs that are not files.
↓
Press Save to finish the Slack settings. Surprisingly easy, right?
Google Sheets Settings
Click "Add Record" with the spreadsheet icon.
↓
Select the account information to link, and choose "Add Record" as the action to execute.
↓
Enter the spreadsheet ID where Slack information will be added, select the sheet from the tab name, and determine the table range. This time, we chose A1:C!
↓
Press Next, and "Values of the record to be added" will appear.
These values are based on the created spreadsheet, so it's easier to set up the flowbot if you make the spreadsheet with clear items like message, attachment, and URL.
↓
Here, select the "Output" that was added earlier.
It will appear like the screen, so choose the relevant ones.
Message = Message Content
Attached File = url_private_download
URL = url
Data Transmission Test from Slack to Google Sheets
After selecting the output, press the test button just below.
And what a surprise!!! The message sent to Slack earlier has been added to the spreadsheet!!
Now you won't miss downloading files and have to search through logs.
Don't forget to press the save button!
Change the Test Channel to the Actual Channel
If you registered a test channel, change it to the channel you will actually use!
Click "When a new message is posted to a channel" with the Slack icon.
↓
The first page is already set up, so proceed to the next.
↓
Choose the channel ID.
When a message with a file is sent to the selected channel, it will be added to the spreadsheet, so choose the relevant channel.
Finish by pressing Save!
You don't need to press the test button! Well done.
Other Automation Examples with Slack and Google Sheets
Besides the flow introduced this time, you can achieve various business automations by using Slack and Google Sheets APIs. All can be used with simple settings, so if you find something interesting, give it a try!
Example of Automation Using Slack
Notify Slack of Gmail emails that match specific conditions in the body or title
By sharing email content on Slack, information sharing across the team will become smoother, enhancing collaboration. Additionally, it eliminates the need to regularly check Gmail for emails, which can improve work efficiency.
Notify Slack when an event is created in Google Calendar
Events in Google Calendar are automatically notified to Slack, allowing you to stay updated smoothly. Receiving schedule notifications on Slack makes it easier to coordinate with other tasks.
Notify Slack when a new lead is registered in Salesforce
You can automatically display lead information without accessing the chat tool. It helps in always sharing the latest information with team members.
Automation Example Using Google Sheets
Create a Folder in Google Drive When a Row is Added in Google Sheets
The timing of folder creation becomes consistently accurate, allowing for efficient data organization. This enables you to quickly find the necessary files, potentially improving the speed of your operations.
Add information added to NotionDB to Google Sheets as well
The newly added information is automatically stored in the Google Sheets database, which helps prevent missing or overlooked information. Additionally, since the trigger is activated by registration or update to the Notion database, you can create advanced flows such as using creation or update dates to branch registration and update routes and notify Google Chat.
Retrieve reports from Meta Ads (Facebook) daily and record them in Google Sheets
This eliminates the hassle of manual report creation and supports speedy and accurate data-driven decision-making. Additionally, it contributes to the improvement of marketing strategies by maintaining data consistency and accuracy.
Benefits and Use Cases of Integrating Slack with Google Sheets
1. Streamlined Information Search through Centralized Data Management
By integrating Slack with Google Sheets, messages and files posted across different channels are consolidated into a single spreadsheet.
This eliminates the need to go back through logs across multiple channels when searching for necessary information or files later, thus improving the efficiency of information retrieval. This is particularly effective for tasks that require retaining past documents and messages, especially since the free plan of Slack has a log viewing limit. This integration will also enable smooth responses to inquiries from superiors.
2. Smooth File Sharing and Task Management among Multiple People
Combining Slack channels that are viewable only by specific members with Google Sheets shared among a large group makes file and task management easier.
For example, when an important file is posted, it is automatically saved to the spreadsheet, allowing necessary members to check the content in the spreadsheet without needing to switch apps. This enhances operational collaboration efficiency and prevents overlooking important information.
3. Enhanced Business Transparency through Automatic Recording of Information Based on Specific Conditions
By transcribing the content of new messages or files posted on Slack to Google Sheets, information is systematically accumulated.
This automatic integration is also convenient for managing important files like contracts, estimates, and reports. Having a log of Slack messages on the spreadsheet is useful for later team reviews or sharing information with other departments. Additionally, this record can help improve business transparency and facilitate project progress reviews by allowing for easy retrospection.
Automation of Tasks Achievable with Templates
Yoom, which can integrate with various apps and allows for centralized management, offers a variety of templates.
This time, it was a relatively simple flow bot creation, but having templates for simple tasks truly enables immediate automation. It's best to keep using templates and try various things! Create flow bots and make time with AI!
The person who wrote this article
c.yamada
I'm in charge of marketing at Yoom.
While automating my own work with Yoom, I am publishing useful blogs to spread the convenience of Yoom to the world.
I have zero programming knowledge, but I succeeded in reducing the time required to zero by automating report creation with Yoom, which used to take about 1 hour every day.
Conventional RPA can only automate simple repetitive tasks, and the setup process was very complicated. With “hyperautomation,” which combines various technologies such as AI, API, RPA, and OCR, it is possible to automate many tasks that could not be realized until now more easily than before.
Most tools simply connect one app to another, leaving the complex tasks to you. Yoom goes much further: From document creation and browser automation to OCR and generative AI, Yoom handles it all seamlessly in one platform.
Why settle for basic integrations? Streamline your entire workflow with Yoom’s powerful hyperautomation.
.avif)
.png)
.png)
