Send Feedback from Google Sheets to Mattermost

This workflow triggers on a specific cron schedule (September 28th at 5 PM) to fetch session data from a Google Sheets spreadsheet, including session names, Mattermost channel IDs, and feedback form links. It then posts a formatted message to the designated Mattermost channel, notifying @channel about the session and providing a direct link to the feedback form. The message is rich with bold text, attachments, and dynamic content pulled from the sheet.

Benefits include hands-free automation of post-event feedback collection, ensuring timely reminders without manual intervention. It saves time for event organizers by integrating Sheets for data management with Mattermost for team communication, reducing errors in link sharing and channel selection.

Use cases: Perfect for conferences like n8nConf, workshops, or internal training sessions. Customize the cron for recurring events, update the sheet with new sessions, and scale for multiple events. Requires Google Sheets OAuth and Mattermost API credentials. Simple 3-node setup makes it easy to adapt for other notification needs.