Track new box office releases from BrowserAct to Google Sheets & Telegram
Related Templates
Readme
Input
Brief
Automated movie tracker! This workflow monitors box office data, uses AI to filter out duplicates against your Google Sheets history, and sends formatted HTML updates on new releases directly to Telegram.
What does Box Office Trifecta do?
This workflow acts as an automated movie tracker that monitors box office data and manages your personal database. It functions by:
- Fetching Data: Runs on a schedule to scrape the latest movie stats using BrowserAct.
- Context Loading: Retrieves your existing movie history from Google Sheets to identify what you've already tracked.
- AI Processing: An AI Agent (OpenRouter) compares new data against your history to remove duplicates and formats valid entries into Telegram-friendly HTML.
- Database & Alerting: Appends new movie details to Google Sheets and sends a notification to your Telegram chat.
What data can you scrape from IMDB ?
This template is designed to scrape and process:
- Movie Details: Name, Cast, and Summary.
- Financial Stats: Budget, Opening Weekend revenue, and Gross Worldwide earnings.
- Links: Direct URLs to the movie profiles or booking pages.
How to use Box Office Trifecta ?
- Credentials: Connect BrowserAct, Google Sheets, OpenRouter, and Telegram in n8n.
- BrowserAct Setup: Ensure the "Box Office Trifecta" template is saved in your account.
- Google Sheet: Create a sheet with headers:
Name,Budget,Opening_Weekend,Gross_Worldwide,Cast,Link,Summary. - Configure Nodes: Select your spreadsheet in the "Get row(s)" and "Append row" nodes.
- Telegram: Enter your Chat ID in the notification node and activate the workflow.
Why scrape IMDB ?
Scraping box office data allows you to:
- Track Trends: Stay updated on which movies are performing best financially without checking websites manually.
- Automate Archiving: Build a comprehensive database of movie statistics in Google Sheets automatically.
- Instant Updates: Get notified the moment new box office numbers are released.
Customization Options:
- Filter Logic: Modify the Scriptwriter prompt to only track movies with specific criteria (e.g., Budget > $100M).
- Enrich Data: Add an HTTP Request node to fetch movie posters.
- Change Platform: Swap the Telegram node for Discord or Slack if preferred.
Requirements:
- BrowserAct (with "Box Office Trifecta" template).
- Google Sheets & Telegram accounts.
- OpenRouter credentials.
