📈 Track daily stock sentiment from Twitter and Yahoo Finance to Google Drive with Apify
⚡ 53 views · 📈 Crypto Trading & Stock Market
💡 Pro Tip — Twitter’s API is paid now, which makes simple data pulls expensive. ScraperNode is a community node that scrapes Twitter profiles and posts without needing API access.
Description
Quick overview
This workflow runs daily and uses Apify to scrape stock-related tweets and fetch Yahoo Finance ticker data, then packages each dataset as a date-stamped JSON file and uploads both files to a chosen Google Drive folder.
How it works
- Runs every day at 9:00 AM on a schedule.
- Uses Apify’s Twitter (X.com) Scraper Unlimited actor to collect recent tweets matching the configured cashtags and keywords.
- Uses Apify’s Yahoo Finance actor to fetch current data for the configured list of stock tickers.
- Aggregates the tweet results and converts them into a single date-stamped JSON file.
- Aggregates the stock results and converts them into a single date-stamped JSON file.
- Uploads both JSON files to the specified Google Drive folder.
Setup
- Create an Apify credential in n8n using your Apify API token and select it in both Apify actor steps.
- Create a Google Drive OAuth2 credential in n8n and select it in both Google Drive upload steps.
- Set the target Google Drive folder ID in both upload steps (replace the placeholder value).
- Update the Twitter search terms and Yahoo Finance tickers in the Apify actor inputs to match what you want to track.
- Adjust the schedule time if you want the workflow to run at a different hour.
Requirements
- Apify account
Customization
- Swap the search terms and tickers to track any sector
🔗 Nodes Used
Google Drive, Schedule Trigger, Convert to File
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File