How to Summarise Slack Channel Activity Weekly Reports Using AI Agent with Pabbly Connect

Learn how to automate weekly Slack channel activity summaries using Pabbly Connect and AI. Step-by-step tutorial included. This comprehensive guide reveals exactly how to connect your applications and automate repetitive tasks — accessible for professionals of all technical backgrounds.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To begin summarizing Slack channel activity weekly reports using Pabbly Connect, first, access the Pabbly Connect platform. Open a new tab and type Pabbly.com/connect to reach the landing page.

Here, you will find options to either sign in or sign up for free. If you are a new user, click on the ‘Sign up for free’ button to create an account. Existing users can directly log in. After signing in, you will be directed to the dashboard of Pabbly Connect, where you can start setting up your automation.

2. Creating a New Workflow in Pabbly Connect

Once you are in the Pabbly Connect dashboard, click on the ‘Create Workflow’ button. A dialog box will appear asking for a workflow name. Enter a descriptive name such as ‘Summarize Slack Channel Activity Weekly Reports Using AI Agent’. using Pabbly Connect

After naming your workflow, select a folder to save it. For this automation, choose an appropriate folder like ‘AI Automations’. Click on ‘Create’ to proceed, and you will be taken to a new screen with a blank workflow setup, which includes trigger and action sections.

3. Setting Up the Trigger for Slack Messages

In the trigger section, select ‘Schedule’ as the trigger type. This feature in Pabbly Connect allows you to schedule workflows based on specific time intervals. Choose the option to run the workflow weekly, selecting Friday as the day and 6 PM as the time.

• Select ‘Schedule Workflow’ as the trigger event.
• Set the frequency to ‘Days of the Week’ and choose Friday.
• Specify the time as 6 PM.

After configuring the trigger, click on ‘Save’. This setup ensures that every Friday at 6 PM, the workflow will automatically fetch messages from the specified Slack channel for the week.

4. Fetching Messages from Slack Channel

Next, you will need to set up the action to fetch messages from your Slack channel. In the action step, select ‘Slack’ as the application and choose the action event as ‘Get Channel Messages’. Click on ‘Connect’ to establish a connection with Slack.

You will need to provide your Slack channel ID to fetch messages. Copy the channel ID from your Slack workspace and paste it into the appropriate field in Pabbly Connect. Configure the timestamps to ensure you only retrieve messages from the past week.

• Enter the latest timestamp to fetch messages before this time.
• Set the oldest timestamp to capture messages from the past week.
• Map the timestamps dynamically to ensure they update automatically.

After completing these steps, click on ‘Save and Send Test Request’ to verify that the messages are being fetched correctly from the Slack channel.

5. Summarizing Messages Using AI Agent

Now that you have fetched the Slack messages, the next step is to summarize them using an AI agent. In the action step, select ‘OpenAI’ as the application and choose ‘ChatGPT’ as the action event. Again, click on ‘Connect’ to establish the connection.

You will need to provide an API key to connect with OpenAI. Once connected, specify the AI model you want to use and enter a prompt that instructs the AI to summarize the messages. For example, your prompt could be: ‘Summarize the following Slack messages into a weekly report with key updates, decisions, blockers, and action items.’ Map the fetched messages into this prompt.

Finally, after clicking ‘Save and Send Test Request’, you will receive a summary of the week’s messages. You can then send this summary back to a designated Slack channel using another action step in Pabbly Connect.

Conclusion

This tutorial has guided you through the process of summarizing Slack channel activity weekly reports using Pabbly Connect and an AI agent. By automating this process, you can save time and ensure that important updates are communicated effectively within your team. Implementing these steps will enhance your workflow and keep your team informed.