$5 · Support the community

Daily MySQL Row Digest, Delivered to Discord

Every morning, n8n pulls the day's MySQL rows, summarizes them, and has Discord post a message to a Discord channel — a clean daily digest with zero manual work.

difficulty Beginnersetup 30 minresult A hands-off n8n workflow where every relevant MySQL row automatically reaches Discord — post a message to a Discord channel.
  1. 1

    Fetch MySQL data

    Add an HTTP Request node (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 a Schedule Trigger before it if this recipe runs on a timer, or a Webhook node if MySQL can push events directly.

  2. 2

    Shape the data with a Set node

    Add a Set node after the fetch step to pull out the fields you need — e.g. id, title (or name), status, and updated_at from the MySQL row. This keeps the rest of the workflow clean and readable.

  3. 3

    Send it to Discord

    Add an HTTP Request node, set Method to POST, and paste your Discord channel webhook URL. Set Body Content Type to JSON with a content field built from the Set-node fields.

  4. 4

    Activate and test

    Click Activate in the top-right corner. Trigger a real row in MySQL (or run the workflow manually against existing data) and confirm it lands correctly in Discord. 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 Discord 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.

About this recipe. Recipes on FlowRecipesHub are written for business owners, not developers, and are tested before publishing — how recipes get made. Some ingredient links are affiliate links that cost you nothing — full disclosure.