Communication
Send scheduled database reports to Slack channels from Postgres
12 nodes
269
95
Scheduled trigger
Workflow Description
Automated workflow that retrieves data from Postgres on a schedule, processes it in batches, and delivers formatted messages to Slack channels. Aggregates database information and distributes updates to team members automatically without manual intervention.
How it works
- 1.Query and extract data from specified Postgres tables based on scheduling
- 2.Split query results into manageable batches for processing
- 3.Format and aggregate batch data into readable Slack message content
- 4.Send prepared messages to designated Slack channels or direct messages
- 5.Implement delays between batch sends to respect API rate limits
Use cases
- Deliver daily summaries of sales metrics and operational KPIs to team channels
- Notify team members of database changes or newly created records that require attention
- Distribute query results to different departments or project-specific Slack groups
Requirements
- Active Slack workspace with bot permissions to post in channels
- Postgres database connection with valid credentials and network access
- Defined source table and column selection for data extraction
Service Value
Ready-made workflow template for automation delivery and service execution.
Apps Used
Postgres
Split In Batches
Slack
Details
Trigger
Scheduled trigger
Nodes
12
Apps
3
Views
269
Downloads
95
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (12)
/
Sticky Note2
Sticky Note
Aggregate
Aggregate
PROFILES QUERY
Postgres
BULK DROPCONTACT REQUESTS
HTTP Request
Loop Over Items2
Split In Batches
Split Out
Split Out
Postgres
Postgres
BULK DROPCONTACT DOWNLOAD
HTTP Request
Wait2
Wait
DATA TRANSFORMATION
Code
Slack
Slack
Schedule Trigger
Schedule Trigger