Back to Templates

Automate Daily Signup Stats from PostgreSQL to Slack, Teams & Telegram

Created by

Created by: Avkash Kakdiya || itechnotion

Avkash Kakdiya

Last update

Last update 25 days ago

Categories

Share


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 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.

Why use this?

  • 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.