Automated Daily Stock Market Report with Bright Data, GPT-4.1, Airtable/Gmail
    100%
    Automation
    0(0 reviews)
    172 downloads

    Automated Daily Stock Market Report with Bright Data, GPT-4.1, Airtable/Gmail

    NM

    Curated by n8n Markets team

    Last updated: March 8, 2026

    # ๐Ÿ“˜ Workflow Documentation โ€“ Stock Market Daily Digest ![automatisationrapportboursierquotidienbaptistefort.png](fileId:2661) ## ๐Ÿ‘‹ Introduction Wake up to a clean, analyst-style stock digest in your inboxโ€”top gainers/losers, a readable performance table, 3โ€“5 insights, and upcoming eventsโ€”no spreadsheets, no manual scraping, no copy-paste. This article explains, step by step, how to build a robust, daily, end-to-end automation that collects market data (Bright Data), waits until scraping is done, aggregates results, asks an AI model (OpenAI) to draft a styled HTML email, logs everything to Airtable, and finally sends the report via Gmail. Youโ€™ll find a friendly but technical tour of every single node, so you can rebuild or adapt the same pipeline with confidence. --- ## ๐ŸŽฏ Who is this workflow for? - Investors & traders who want a quick, readable daily summary. - Finance/Product teams building data-driven alerts/digests. - Consultants & agencies sending recurring client updates. - Automation builders prototyping finance ops quickly. --- ## ๐Ÿงฐ Tools youโ€™ll need - Bright Data โ€” dataset triggers & snapshots for reliable web data. - OpenAI (GPT) โ€” to generate a professional HTML digest. - Airtable โ€” store daily rows for history, filters, dashboards. ### Example Airtable Table: `Daily Stocks` | Ticker | Company | Price | Change % | Sentiment | Date | |--------|--------------------------|---------|----------|-----------|---------------------| | AAPL | Apple Inc. | 225.80 | +1.4% | ๐ŸŸข Positive | 2025-09-18 09:00 | | MSFT | Microsoft Corporation | 415.20 | -0.7% | ๐Ÿ”ด Negative | 2025-09-18 09:00 | | NVDA | NVIDIA Corporation | 124.55 | +2.1% | ๐ŸŸข Positive | 2025-09-18 09:00 | | TSLA | Tesla Inc. | 260.00 | -3.0% | ๐Ÿ”ด Negative | 2025-09-18 09:00 | | META | Meta Platforms Inc. | 310.45 | +0.5% | ๐ŸŸก Neutral | 2025-09-18 09:00 | - Gmail โ€” deliver the final HTML email to stakeholders. - n8n โ€” the automation engine that orchestrates every step. > Keep API keys in n8n Credentials (never hard-code secrets). --- ## ๐Ÿ—บ๏ธ Architecture at a glance 1. Schedule fires daily 2. Seed list of tickers 3. Split into one item per stock 4. Prepare keyword for scraping 5. Launch Bright Data job 6. Poll progress with a wait-loop 7. Fetch snapshot data 8. Aggregate for the AI 9. Generate HTML summary (GPT) 10. Save rows to Airtable 11. Send email via Gmail --- # โš™๏ธ Step-by-step โ€” Every node explained ## โฐ Daily Run Trigger (Schedule Trigger) ![baptistefortautomatisationscrapingboursierbrightdata.png](fileId:2658) ### Purpose Start the automation at a precise time each day so nobody needs to push a button. ### Parameters (English) - Trigger Type: `Time Interval` or `Cron` - Every X: `1 Day` (or your preferred cadence) - Timezone: `UTC` (or your own) - Start Time: optional (e.g., `09:00`) --- ## ๐Ÿ“ Set Stock List (Set Node โ€“ SAMPLE DATA) ### Purpose Define the universe of stocks to monitor. This acts as the seed data for scraping. ### Parameters - Values to Set: `Fixed JSON (array of objects)` - Keep Only Set: `true` - Fields per item: `ticker`, `name`, `market_cap` (you may add `sector`, `isin`, etc.) --- ## ๐Ÿ”€ Split Stocks (Split Out) ### Purpose Turn the array into individual items so each ticker is processed independently (scraping, polling, results). ### Parameters - Operation: `Split Out Items` - Field to Split: the array defined in the previous Set node --- ## ๐Ÿท Prepare Stock Keyword (Set Node) ### Purpose Create a `keyword` field (typically equal to `ticker`) for Bright Data discovery. ### Parameters - Values to Set: `Add Field` - Field Name: `keyword` - Value: use an expression referencing the current itemโ€™s ticker (e.g., `` {{ $json.ticker }} ``) --- ## ๐Ÿ•ธ Bright Data Scraper (HTTP Request) ### Purpose Trigger the Bright Data dataset to start collecting information for the `keyword`. Returns a `snapshot_id` to poll later. ### Parameters - Method: `POST` - Endpoint: `https://api.brightdata.com/datasets/v1/trigger` - Authentication: `Authorization: Bearer <token>` (header) - Body Fields: - `dataset_id`: your Bright Data dataset ID - `discover_by`: usually `keyword` - `keyword`: the value prepared above > Add a retry/backoff policy on 429/5xx in node options. --- ## ๐Ÿ”„ Check Scraper Progress (HTTP Request) ![baptistefortautomatisationdigestboursier.png](fileId:2660) ### Purpose Poll Bright Data to see whether the snapshot is `running` or `ready`. ### Parameters - Method: `GET` - Endpoint: `https://api.brightdata.com/datasets/v1/snapshots/{snapshot_id}` - Authentication: `Authorization: Bearer <token>` - Expected Output: a `status` field (`running`, `ready`) --- ## โณ Wait for Data (Wait Node) ### Purpose Pause between progress checks to avoid rate limits and give Bright Data t

    What's Included

    • Complete n8n workflow template with 0 nodes. Ready to import and customize.

    Requirements

    n8n instance (self-hosted or cloud). credentials.

    How to Use

    1. Download the workflow JSON 2. Import into your n8n instance 3. Configure credentials for 4. Activate and enjoy automation

    How to import this template into n8n

    1. Download the workflow JSON file from this page.
    2. In n8n, open Workflows, create a new workflow and choose Import from File.
    3. Open each node that shows a warning and connect your own credentials.
    4. Run the workflow once manually to check the output before you activate it.
    Included in Pro
    • Importable n8n workflow JSON file
    • Download with Builder Pro or Agency Unlimited
    • Built for n8n v1.0++
    • Setup time: 15-30 min

    Included in Builder Pro โ€” $19/mo, 4,177 premium workflows

    Before you activate

    Templates are reviewed before they are listed. Test with your own credentials and data before running it in production.

    Updated Mar 2026
    v1.0
    SSL
    Secure
    GDPR

    100% Secure Checkout

    Refund requests within 7 days of a new subscription

    Dependencies & Requirements

    Gmail
    Communication
    Airtable
    Data

    โš ๏ธ 2 services require credentials. Make sure you have accounts set up before importing.

    Reviews

    0

    No reviews yet

    See all 0 reviews โ†“
    โ€”

    0 reviews

    5โ˜…
    0
    4โ˜…
    0
    3โ˜…
    0
    2โ˜…
    0
    1โ˜…
    0

    No reviews yet.

    Questions & Answers

    0

    Log in to ask a question.

    No questions yet. Be the first to ask!

    People Also Bought