Daily MySQL Row Digest, Delivered to Slack
Every morning, n8n pulls the day's MySQL rows, summarizes them, and has Slack post an alert to a Slack channel — a clean daily digest with zero manual work.
- 1
Fetch MySQL data
Add an
HTTP Requestnode (or the native MySQL node if you have credentials set up) and point it at the MySQL API. Run on a daily Schedule Trigger and fetch recent rows. Add aSchedule Triggerbefore it if this recipe runs on a timer, or aWebhooknode if MySQL can push events directly. - 2
Shape the data with a Set node
Add a
Setnode after the fetch step to pull out the fields you need — e.g.id,title(orname),status, andupdated_atfrom the MySQL row. This keeps the rest of the workflow clean and readable. - 3
Send it to Slack
Add a
Slacknode set to operationSend Message. Connect your workspace, choose theChannel, and build the messageTextfrom the Set-node fields. - 4
Activate and test
Click
Activatein the top-right corner. Trigger a real row in MySQL (or run the workflow manually against existing data) and confirm it lands correctly in Slack. Once verified, this runs hands-off.
Frequently asked questions
Do I need to code anything?
No. n8n is a visual, drag-and-drop builder. You connect your MySQL and Slack accounts, map the fields, and activate — no code required.
Where do I get my MySQL API credentials?
In your MySQL account settings, look for "API", "Developers" or "Integrations" and generate an API key or token. Paste it into n8n's HTTP Request node (as a header or credential) or the native MySQL node if one is available.
Can this run on a schedule instead of in real time?
Yes — swap the trigger for a `Schedule Trigger` set to whatever interval fits (every 15 minutes, hourly, daily). The rest of the workflow stays the same.
Keep every recipe free
FlowRecipesHub is free and always will be. If a workflow saved you time, chip in what you like — it helps us keep the lights on and build the next batch of automations for everyone.
Secure checkout via Paddle · one-time, no account needed
