Daily Stock Sentiment & Yahoo Finance Data to Google Drive (n8n)

Daily Stock Sentiment + Yahoo Finance Data to Google Drive (n8n)

Automate your market data pipeline: this n8n workflow runs every day at 9:00 AM, pulls recent stock-related tweets via Apify, fetches Yahoo Finance ticker data, saves both as date-stamped JSON files, and uploads them to your chosen Google Drive folder.

What this workflow does

• Scheduled run: Executes daily at 9:00 AM using an n8n Schedule Trigger.
• Twitter/X data collection (Apify): Uses Apify’s Twitter (X.com) Scraper Unlimited actor to collect recent tweets based on your configured `cashtags` and keywords.
• Yahoo Finance data retrieval (Apify): Uses Apify’s Yahoo Finance actor to fetch current data for the configured list of stock tickers.
• Data packaging: Aggregates the tweet results into a single date-stamped JSON file and aggregates the stock results into a second date-stamped JSON file.
• Google Drive upload: Uploads both JSON files to the specified Google Drive folder (using your folder ID in both upload steps).

Use cases

• Keep a daily archive of stock sentiment (tweets) alongside Yahoo Finance data for backtesting and reporting.
• Build a lightweight pipeline for analysts or SaaS operators who want storage in Google Drive without manual downloads.
• Track any sector by swapping the search terms and tickers in the Apify actor inputs.

Technical details

• n8n nodes: Schedule Trigger, aggregate, sticky note, convert to file, and Google Drive upload steps.
• Apify integration: n8n-nodes-apify (Apify actors for Twitter/X Scraper Unlimited and Yahoo Finance).
• Requirements: An Apify account, plus n8n credentials for Apify API token and Google Drive OAuth2.

This is a practical n8n automation workflow for reliably collecting daily market signals and storing them as structured JSON for downstream analysis.