Automate daily signup stats from PostgreSQL to Slack, Teams & Telegram
How it works 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 2...
Template notes
How it works 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.
Step-by-step
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 createdat timestamp column.
Report Preparation
- The Prepare Report Message node formats the results into a structured message: