Quick Guide: Logging Slack Messages to Excel using Make.com

Follow these steps to set up an automated scenario that logs Slack messages to an Excel sheet every 15 minutes on Make.com.

Steps:

1. Log In and Create a Scenario
   • Log in to your Make.com account.
   • Click "Create a new scenario."
2. 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."

1. Set Scheduler
   • Click the clock icon to set the scenario schedule to every 15 minutes.

1. 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
   • Click "OK."

1. Add Array Iterator Module
   • Add an "Iterator" module.
   • Set the input array to {{3.array}}.
   • Click "OK."

1. 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}}
   • Click "OK."

1. 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.