Quick Guide: Logging Slack Messages to Excel using Make.com
![Quick Guide: Logging Slack Messages to Excel using Make.com](/content/images/size/w1200/2024/06/Screenshot-2024-06-05-143055.png)
Follow these steps to set up an automated scenario that logs Slack messages to an Excel sheet every 15 minutes on Make.com.
Steps:
- Log In and Create a Scenario
- Log in to your Make.com account.
- Click "Create a new scenario."
- Add Slack - Watch Messages Module
- Search and select "Slack" > "Watch Messages."
- Configure:
- Connection: Select or add your Slack connection.
- Channel: Choose the Slack channel.
- Limit: Set to 100.
- Click "OK."
![slack module added](https://blog.thinkbot.agency/content/images/2024/06/image-20.png)
- Set Scheduler
- Click the clock icon to set the scenario schedule to every 15 minutes.
![scheduler](https://blog.thinkbot.agency/content/images/2024/06/image-21.png)
- Add Array Aggregator Module
- Add an "Array Aggregator" module.
- Set "Source Module" to the Slack Watch Messages module.
- Map the fields:
- Type:
message
- User:
user
- Date:
date
- Type:
- Click "OK."
![array aggregator with mapped values](https://blog.thinkbot.agency/content/images/2024/06/image-19.png)
- Add Array Iterator Module
- Add an "Iterator" module.
- Set the input array to
{{3.array}}
. - Click "OK."
![iterator module added with array as input](https://blog.thinkbot.agency/content/images/2024/06/image-18.png)
- Add Microsoft Excel - Add a Table Row Module
- Add a "Microsoft Excel" > "Add a Table Row" module.
- Configure:
- Connection: Select or add your Microsoft Excel connection.
- Workbook: Select the path (e.g.,
/Documents/log thing.xlsx
). - Worksheet: Choose
Sheet1
. - Table: Choose
Table1
.
- Map the fields:
- Column 0:
{{3.array[].type}}
- Column 1:
{{3.array[].date}}
- Column 2:
{{3.array[].user}}
- Column 0:
- Click "OK."
![excel module added](https://blog.thinkbot.agency/content/images/2024/06/image-17.png)
- Save and Run
- Click "Save."
- Click "Run Once" to test the scenario.
- If it works, switch the scenario on to run every 15 minutes.
You're done! Your Make.com scenario will now log new Slack messages into your Excel sheet automatically every 15 minutes. This scenario could be easily modified to fit many different situations or expanded to log different platforms. Any questions or inquiries email or Upwork.