Automated Weekly Virtual Coffee Chat Organizer
detail.loadingPreview
This n8n workflow fully automates your team's weekly virtual coffee chats. It intelligently groups employees into random teams, announces these groups via Mattermost, and sends personalized Google Calendar invites with a video conferencing link, fostering seamless team connection.
About This Workflow
Boost team morale and connection with this powerful n8n workflow designed to automate your weekly virtual coffee breaks. Every Monday morning, the workflow springs to life, first greeting your team on Mattermost. It then intelligently pulls a list of active participants from your designated Mattermost channel. A custom Function node takes center stage, expertly shuffling participants and dividing them into balanced groups, ensuring no one is left out with a single-person group. Finally, it broadcasts the newly formed groups on Mattermost and simultaneously dispatches personalized Google Calendar invitations, complete with a video conferencing link, to each group member. Say goodbye to manual coordination and hello to effortless team bonding!
Key Features
- Automated Weekly Scheduling: Triggers reliably every Monday morning at 10 AM, ensuring consistent team interaction.
- Intelligent Group Randomization: Randomly shuffles participants and forms balanced groups (defaulting to 3 members), preventing awkward single-person groups for better engagement.
- Seamless Mattermost Integration: Announces weekly groups directly to your team's specified Mattermost channel, keeping everyone informed.
- Google Calendar Invite Creation: Automatically generates and sends personalized calendar invites with integrated video conferencing links (e.g., Google Meet) to each group.
- Scalable Team Engagement: Easily manage virtual coffee chats for teams of any size, fostering connections across the organization.
How To Use
- Configure Credentials:
- Set up your Mattermost API credentials for the "Greetings," "Employees in coffee chat channel," and "Announce groups" nodes.
- Set up your Google Calendar OAuth2 API credentials for the "Send calendar invites" node.
- Specify Mattermost Channel:
- In the "Greetings" node, replace
Enter Your Channel IDwith the actual ID of your Mattermost channel where announcements will be made and users are fetched from. - Verify the "Announce groups" node's
channelIdparameter is correctly linked or updated.
- In the "Greetings" node, replace
- Set Google Calendar:
- In the "Send calendar invites" node, replace
Enter Your Google Calendarwith the name of the Google Calendar you want to use for creating events.
- In the "Send calendar invites" node, replace
- Adjust Grouping Logic (Optional):
- Open the "Divide into groups" Function node. You can modify the
ideal_group_sizevariable (default is 3) to suit your preferred group size.
- Open the "Divide into groups" Function node. You can modify the
- Set Calendar Event Times:
- In the "Send calendar invites" node, update the
startandenddate/time parameters to reflect your desired coffee chat duration and timing. Note: The current snippet uses hardcoded past dates; remember to update these to dynamic expressions or appropriate future times relative to the trigger. For example, use aDate & Timenode to dynamically set the event times relative to the workflow execution.
- In the "Send calendar invites" node, update the
- Activate Workflow: Once configured, activate the "Weekly trigger on monday" node to start automating your team's coffee chats.
Apps Used
Workflow JSON
{
"id": "02534783-0764-4a0a-848b-97a4292a97ec",
"name": "Automated Weekly Virtual Coffee Chat Organizer",
"nodes": 18,
"category": "Operations",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 02534783-0764...
About the Author
AI_Workflow_Bot
LLM Specialist
Building complex chains with OpenAI, Claude, and LangChain.
Statistics
Related Workflows
Discover more workflows you might like
Universal CSV to JSON API Converter
Effortlessly transform CSV data into structured JSON with this versatile n8n workflow. Integrate it into any application as a custom API endpoint, supporting various input methods including file uploads and raw text.
Instant WooCommerce Order Notifications via Telegram
When a new order is placed on your WooCommerce store, instantly receive detailed notifications directly to your Telegram chat. Stay on top of your e-commerce operations with real-time alerts, including order specifics and a direct link to view the order.
On-Demand Microsoft SQL Query Execution
This workflow allows you to manually trigger and execute any SQL query against your Microsoft SQL Server database. Perfect for ad-hoc data lookups, administrative tasks, or quick tests, giving you direct control over your database operations.