Cron Automate: Schedule Messages from Google Sheets

Target Audience

• Project Managers: Looking to automate feedback collection from team events.
• HR Professionals: Seeking to gather employee feedback efficiently after sessions or training.
• Team Leaders: Wanting to ensure team engagement and improve future sessions based on feedback.
• Data Analysts: Interested in analyzing feedback data collected from Google Sheets and shared via Mattermost.

Problem Solved

This workflow automates the process of collecting feedback after scheduled events by:

• Eliminating Manual Efforts: Automatically retrieves session data from Google Sheets.
• Streamlining Communication: Sends out feedback requests to team members via Mattermost, ensuring timely responses.
• Enhancing Engagement: Encourages team members to share their thoughts and experiences with minimal effort.

Workflow Steps

1. Scheduled Trigger: The workflow is triggered at 5:00 PM on September 28th each year, ensuring timely feedback collection.
2. Data Retrieval: It connects to Google Sheets to retrieve the range Sessions!A:D, which includes session details and feedback links.
3. Message Preparation: A personalized message is created for Mattermost, addressing the channel and including session-specific details like the session name and feedback form link.
4. Sending Feedback Requests: The prepared message is sent to the specified Mattermost channel, prompting team members to provide their feedback.