Cron Automate

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.

Customization Guide

- Changing the Schedule: Modify the cronExpression in the Cron node to adjust the timing of the workflow.
- Updating Google Sheets Range: Change the range parameter in the Google Sheets node to pull different data or additional columns as needed.
- Personalizing Messages: Edit the message and attachments parameters in the Mattermost node to reflect your organization's tone and feedback requirements.
- Channel Selection: Update the channelId parameter to direct messages to a different Mattermost channel based on your team's structure.