Automated system that tracks upcoming investor concalls from Screener.in, extracts dial-in numbers from PDFs, and syncs everything to Google Sheets + Calendar.
Zero manual work. Runs daily at 7 AM IST.
- π Scrapes 100 upcoming concalls from Screener.in
- π Extracts phone numbers from PDF announcements (92% success rate)
- π Auto-updates Google Sheet with all concall details
- π Creates Google Calendar events with reminders
- π¨ Color codes calls by watchlist (My Stonks β Tomato, Core Watchlist β Flamingo/Tangerine/Banana)
- π My Stonks events auto-sync to main calendar
- π§ Email notifications on success/failure
- βοΈ Runs automatically via GitHub Actions (even if your laptop is off)
- Google Sheet: View Concalls
Every day at 7 AM IST:
βββββββββββββββββββ
β Screener.in β
ββββββββββ¬βββββββββ
βΌ
βββββββββββββββββββ
β Scrape 100 β
β Concalls β
ββββββββββ¬βββββββββ
βΌ
βββββββββββββββββββ
β Download PDFs β
β Extract Phones β
ββββββββββ¬βββββββββ
βΌ
ββββββ΄βββββ
βΌ βΌ
βββββββββ ββββββββββββ
β Sheet β β Calendar β
βββββββββ ββββββββββββ
βΌ
βββββββββββββββββββ
β Email Summary β
βββββββββββββββββββ
- Python + Selenium (web scraping)
- pdfplumber (PDF extraction)
- Google Sheets API
- Google Calendar API
- GitHub Actions (automation)
You must provide your own credentials. This repo contains no stored credentials.
- Screener.in Account - Create your own account at screener.in
- Google Service Account - Create via Google Cloud Console with Sheets, Drive, and Calendar APIs enabled
- GitHub Secrets - Add these to your forked repo:
SCREENER_USERNAME- Your Screener.in emailSCREENER_PASSWORD- Your Screener.in passwordGOOGLE_CREDENTIALS_BASE64- Base64-encoded service account JSONEMAIL_USERNAME/EMAIL_PASSWORD- Gmail app password for notifications
This entire project was built in 3 hours using Claude Code with zero prior coding experience.
MIT
Built by @AnishA_Moonka