This workflow automatically pulls daily signup stats from your PostgreSQL database and shares them with your team across multiple channels. Every morning, it counts the number of new signups in the last 24 hours, formats the results into a concise report, and posts it to Slack, Microsoft Teams, and Telegram. This ensures your entire team stays updated on customer growth without manual queries or reporting.
Daily Trigger & Data Fetching
The Daily Report Trigger runs at 9:00 AM each day.
The Fetch Signup Count node queries the customers table in PostgreSQL.
It calculates the number of new signups in the last 24 hours using the created_at timestamp column.
Report Preparation
The Prepare Report Message node formats the results into a structured message:
Report date
Signup count
A clear summary line:
Daily Signup Report – New signups in the last 24h: X
Multi-Channel Delivery
The prepared message is sent to multiple platforms simultaneously:
Slack
Microsoft Teams
Telegram
This ensures all teams receive the update in their preferred communication tool.
Automates daily customer growth reporting.
Eliminates manual SQL queries and report sharing.
Keeps the whole team aligned with real-time growth metrics.
Delivers updates across Slack, Teams, and Telegram at once.
Provides simple, consistent reporting every day.