{ "edges": [ { "to": "23b4a321-dc70-4fbd-96a1-b0950240fe69", "from": "681cc6ce-091f-469b-8163-9c50b2c8f0cc", "toPort": "0", "fromPort": "ai_languageModel" }, { "to": "521552f2-cc40-4fc3-b15c-054c5a464148", "from": "681cc6ce-091f-469b-8163-9c50b2c8f0cc", "toPort": "0", "fromPort": "ai_languageModel" }, { "to": "4b5c66c3-04f1-48d5-834d-4e89ad8d749e", "from": "bb3f0936-97c3-4c53-a592-6aa4738f3568", "toPort": "0", "fromPort": "0" }, { "to": "23b4a321-dc70-4fbd-96a1-b0950240fe69", "from": "7bb34639-f55a-4ba6-9017-df87a6cf5660", "toPort": "0", "fromPort": "0" }, { "to": "23b4a321-dc70-4fbd-96a1-b0950240fe69", "from": "521552f2-cc40-4fc3-b15c-054c5a464148", "toPort": "0", "fromPort": "ai_outputParser" }, { "to": "83ce6710-7079-472e-9b2a-61eb7f1ef9bc", "from": "3184e58a-5843-4948-812d-7dc672b7eaca", "toPort": "0", "fromPort": "0" }, { "to": "7bb34639-f55a-4ba6-9017-df87a6cf5660", "from": "bc3bf15f-03fb-4f31-9f53-fac2ef0744ff", "toPort": "0", "fromPort": "0" }, { "to": "19b529c6-c2fd-48ce-ab35-03957d755632", "from": "83ce6710-7079-472e-9b2a-61eb7f1ef9bc", "toPort": "0", "fromPort": "0" }, { "to": "3184e58a-5843-4948-812d-7dc672b7eaca", "from": "23b4a321-dc70-4fbd-96a1-b0950240fe69", "toPort": "0", "fromPort": "0" }, { "to": "bc3bf15f-03fb-4f31-9f53-fac2ef0744ff", "from": "4b5c66c3-04f1-48d5-834d-4e89ad8d749e", "toPort": "0", "fromPort": "0" } ], "nodes": [ { "id": "681cc6ce-091f-469b-8163-9c50b2c8f0cc", "name": "OpenRouter", "type": "llm", "params": { "model": "google/gemini-3-pro-preview", "options": {}, "provider": "openai" }, "position": [ 1520, 368 ] }, { "id": "521552f2-cc40-4fc3-b15c-054c5a464148", "name": "Structured Output", "type": "passthrough", "params": { "mode": "noOp", "autoFix": true, "jsonSchemaExample": "[\n {\n \"movie_name\": \"Avatar: Fire and Ash\",\n \"telegram_message_html\": \"Avatar: Fire and Ash 🔥\\n\\nThe Na'vi face a new threat: the Ash People.\\n\\nCast: Sam Worthington, Zoe Saldaña, Sigourney Weaver\\nOpening: $88,000,000\\n\\n🎬 Watch Trailer\\n\\n#Avatar #NewMovie\",\n \"sheet_data\": {\n \"Name\": \"Avatar: Fire and Ash\",\n \"Budget\": \"$400,000,000\",\n \"Opening_Weekend\": \"$88,000,000\",\n \"Gross_Worldwide\": \"$345,000,000\",\n \"Cast\": \"Sam Worthington, Zoe Saldaña...\",\n \"Link\": \"[https://imdb.com/](https://imdb.com/)...\",\n \"Summary\": \"Jake and Neytiri's family faces new challenges...\"\n }\n }\n]" }, "position": [ 1648, 368 ] }, { "id": "bc3bf15f-03fb-4f31-9f53-fac2ef0744ff", "name": "Retrieve Stored Data", "type": "integration", "params": { "options": { "dataLocationOnSheet": { "values": { "rangeDefinition": "specifyRange" } } }, "service": "googleSheets", "operation": "read", "sheetName": { "__rl": true, "mode": "list", "value": "gid=0", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/159A6tH0vMfwE4w9upGD4C-pZB7P8E8-okS3itzuPP-M/edit#gid=0", "cachedResultName": "Movie history" }, "documentId": { "__rl": true, "mode": "list", "value": "159A6tH0vMfwE4w9upGD4C-pZB7P8E8-okS3itzuPP-M", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/159A6tH0vMfwE4w9upGD4C-pZB7P8E8-okS3itzuPP-M/edit?usp=drivesdk", "cachedResultName": "Box Office Trifecta" } }, "position": [ 992, 160 ] }, { "id": "4b5c66c3-04f1-48d5-834d-4e89ad8d749e", "name": "Extract From IMDB Box Office", "type": "integration", "params": { "type": "WORKFLOW", "service": "browseract", "operation": "run", "workflowId": "7+1234567890", "__originalType": "n8n-nodes-browseract.browserAct", "workflowConfig": { "value": {}, "schema": [ { "id": "input-BoxOffice", "type": "string", "display": true, "removed": true, "required": false, "description": "If left blank, the default value defined in BrowserAct will be used.", "displayName": "BoxOffice", "defaultMatch": true } ], "mappingMode": "defineBelow", "matchingColumns": [ "input-BoxOffice" ], "attemptToConvertTypes": false, "convertFieldsToString": false }, "open_incognito_mode": false }, "position": [ 800, 160 ] }, { "id": "bb3f0936-97c3-4c53-a592-6aa4738f3568", "name": "Run Weekly", "type": "trigger", "params": { "kind": "n8n-nodes-base.scheduleTrigger", "rule": { "interval": [ { "field": "weeks" } ] } }, "position": [ 608, 160 ] }, { "id": "7bb34639-f55a-4ba6-9017-df87a6cf5660", "name": "Merge All Data", "type": "passthrough", "params": { "mode": "aggregate", "options": {}, "aggregate": "aggregateAllItemData" }, "position": [ 1152, 160 ] }, { "id": "23b4a321-dc70-4fbd-96a1-b0950240fe69", "name": "Create posts for Telegram", "type": "llm", "params": { "text": "=Movies Data : {{ $('Extract From IMDB Box Office').first().json.output.string }},,\nGoogle sheet Data : {{ $json.data }}", "prompt": "=Movies Data : {{ $('Extract From IMDB Box Office').first().json.output.string }},,\nGoogle sheet Data : {{ $json.data }}", "options": { "systemMessage": "You are an advanced Data Processing and Content Generation Agent for a movie tracking workflow.\n\n**Your Goal:**\nProcess a raw JSON list of incoming movie data (`input_movies`), filter out duplicates found in the provided database (`existing_movies`), and generate formatted outputs for the remaining new movies.\n\n**Inputs provided to you:**\n1. `input_movies`: A JSON list of movie objects.\n2. `existing_movies`: A list/string of movie names already in the Google Sheet.\n\n**Step-by-Step Instructions:**\n\n1. **Deduplication (Filter):**\n * Compare the \"Name\" of each movie in `input_movies` against `existing_movies`.\n * **IF** the name matches (case-insensitive), **DISCARD** it.\n * **IF** the name is unique, process it as a new movie.\n\n2. **Process New Movies:**\n For each valid new movie, generate a JSON object with two keys:\n\n * **`telegram_message_html`**: Create a post using **Telegram-supported HTML** only (``, ``, ``).\n * **Header:** The Movie Name in `` bold.\n * **Genre/Vibe:** An emoji and short description.\n * **Details:** `` for the Cast list (limit to top 3 names).\n * **Stats:** \"Opening Weekend\" value (if available).\n * **Call to Action:** A clean HTML hyperlink: `🎬 Watch Trailer / View Details`.\n * **Tags:** Hashtags at the bottom.\n * *Constraint:* Ensure all HTML tags are closed properly. Do not use Markdown (`**`).\n\n * **`sheet_data`**: Extract clean data for the Google Sheet.\n * **Parsing:** Extract \"Budget\", \"Opening Weekend\", and \"Gross Worldwide\" from the \"BoxOffice\" string. Use \"N/A\" if missing.\n * **Structure:** Return specific keys: Name, Budget, Opening_Weekend, Gross_Worldwide, Cast, Link, Summary.\n\n3. **Final Output Format:**\n * Return **ONLY** a single valid JSON array containing the processed objects.\n * You have 3000 Max char limitation for telegram API.\n * No conversational text or code block formatting (```json).\n\n**Example Output Structure:**\n[\n {\n \"movie_name\": \"Avatar: Fire and Ash\",\n \"telegram_message_html\": \"Avatar: Fire and Ash 🔥\\n\\nThe Na'vi face a new threat: the Ash People.\\n\\nCast: Sam Worthington, Zoe Saldaña, Sigourney Weaver\\nOpening: $88,000,000\\n\\n🎬 Watch Trailer\\n\\n#Avatar #NewMovie\",\n \"sheet_data\": {\n \"Name\": \"Avatar: Fire and Ash\",\n \"Budget\": \"$400,000,000\",\n \"Opening_Weekend\": \"$88,000,000\",\n \"Gross_Worldwide\": \"$345,000,000\",\n \"Cast\": \"Sam Worthington, Zoe Saldaña...\",\n \"Link\": \"[https://imdb.com/](https://imdb.com/)...\",\n \"Summary\": \"Jake and Neytiri's family faces new challenges...\"\n }\n }\n]" }, "provider": "openai", "promptType": "define", "approximated": true, "systemMessage": "You are an advanced Data Processing and Content Generation Agent for a movie tracking workflow.\n\n**Your Goal:**\nProcess a raw JSON list of incoming movie data (`input_movies`), filter out duplicates found in the provided database (`existing_movies`), and generate formatted outputs for the remaining new movies.\n\n**Inputs provided to you:**\n1. `input_movies`: A JSON list of movie objects.\n2. `existing_movies`: A list/string of movie names already in the Google Sheet.\n\n**Step-by-Step Instructions:**\n\n1. **Deduplication (Filter):**\n * Compare the \"Name\" of each movie in `input_movies` against `existing_movies`.\n * **IF** the name matches (case-insensitive), **DISCARD** it.\n * **IF** the name is unique, process it as a new movie.\n\n2. **Process New Movies:**\n For each valid new movie, generate a JSON object with two keys:\n\n * **`telegram_message_html`**: Create a post using **Telegram-supported HTML** only (``, ``, ``).\n * **Header:** The Movie Name in `` bold.\n * **Genre/Vibe:** An emoji and short description.\n * **Details:** `` for the Cast list (limit to top 3 names).\n * **Stats:** \"Opening Weekend\" value (if available).\n * **Call to Action:** A clean HTML hyperlink: `🎬 Watch Trailer / View Details`.\n * **Tags:** Hashtags at the bottom.\n * *Constraint:* Ensure all HTML tags are closed properly. Do not use Markdown (`**`).\n\n * **`sheet_data`**: Extract clean data for the Google Sheet.\n * **Parsing:** Extract \"Budget\", \"Opening Weekend\", and \"Gross Worldwide\" from the \"BoxOffice\" string. Use \"N/A\" if missing.\n * **Structure:** Return specific keys: Name, Budget, Opening_Weekend, Gross_Worldwide, Cast, Link, Summary.\n\n3. **Final Output Format:**\n * Return **ONLY** a single valid JSON array containing the processed objects.\n * You have 3000 Max char limitation for telegram API.\n * No conversational text or code block formatting (```json).\n\n**Example Output Structure:**\n[\n {\n \"movie_name\": \"Avatar: Fire and Ash\",\n \"telegram_message_html\": \"Avatar: Fire and Ash 🔥\\n\\nThe Na'vi face a new threat: the Ash People.\\n\\nCast: Sam Worthington, Zoe Saldaña, Sigourney Weaver\\nOpening: $88,000,000\\n\\n🎬 Watch Trailer\\n\\n#Avatar #NewMovie\",\n \"sheet_data\": {\n \"Name\": \"Avatar: Fire and Ash\",\n \"Budget\": \"$400,000,000\",\n \"Opening_Weekend\": \"$88,000,000\",\n \"Gross_Worldwide\": \"$345,000,000\",\n \"Cast\": \"Sam Worthington, Zoe Saldaña...\",\n \"Link\": \"[https://imdb.com/](https://imdb.com/)...\",\n \"Summary\": \"Jake and Neytiri's family faces new challenges...\"\n }\n }\n]", "hasOutputParser": true }, "position": [ 1520, 160 ] }, { "id": "3184e58a-5843-4948-812d-7dc672b7eaca", "name": "Split Telegram Post", "type": "passthrough", "params": { "mode": "splitOut", "field": "output", "options": {}, "fieldToSplitOut": "output" }, "position": [ 2144, 160 ] }, { "id": "83ce6710-7079-472e-9b2a-61eb7f1ef9bc", "name": "Store Extracted Data", "type": "integration", "params": { "columns": { "value": { "Cast": "={{ $json.sheet_data.Cast }}", "Link": "={{ $json.sheet_data.Link }}", "Budget": "={{ $json.sheet_data.Budget }}", "Summary": "={{ $json.sheet_data.Summary }}", "movie_name": "={{ $json.sheet_data.Name }}", "telegram_post": "={{ $json.telegram_message_html }}", "Gross_Worldwide": "={{ $json.sheet_data.Gross_Worldwide }}", "Opening_Weekend": "={{ $json.sheet_data.Opening_Weekend }}" }, "schema": [ { "id": "movie_name", "type": "string", "display": true, "required": false, "displayName": "movie_name", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "telegram_post", "type": "string", "display": true, "required": false, "displayName": "telegram_post", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Budget", "type": "string", "display": true, "required": false, "displayName": "Budget", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Opening_Weekend", "type": "string", "display": true, "required": false, "displayName": "Opening_Weekend", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Gross_Worldwide", "type": "string", "display": true, "required": false, "displayName": "Gross_Worldwide", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Cast", "type": "string", "display": true, "required": false, "displayName": "Cast", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Link", "type": "string", "display": true, "required": false, "displayName": "Link", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Summary", "type": "string", "display": true, "required": false, "displayName": "Summary", "defaultMatch": false, "canBeUsedToMatch": true } ], "mappingMode": "defineBelow", "matchingColumns": [], "attemptToConvertTypes": false, "convertFieldsToString": false }, "options": {}, "service": "googleSheets", "operation": "append", "sheetName": { "__rl": true, "mode": "list", "value": "gid=0", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/159A6tH0vMfwE4w9upGD4C-pZB7P8E8-okS3itzuPP-M/edit#gid=0", "cachedResultName": "Movie history" }, "documentId": { "__rl": true, "mode": "list", "value": "159A6tH0vMfwE4w9upGD4C-pZB7P8E8-okS3itzuPP-M", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/159A6tH0vMfwE4w9upGD4C-pZB7P8E8-okS3itzuPP-M/edit?usp=drivesdk", "cachedResultName": "Box Office Trifecta" } }, "position": [ 2368, 160 ] }, { "id": "19b529c6-c2fd-48ce-ab35-03957d755632", "name": "Send Post to Telegram Channel", "type": "integration", "params": { "text": "={{ $('Split Telegram Post').first().json.telegram_post }}", "chatId": "chatId==\"@Your_Telegram_Channel_ID\"", "service": "telegram", "operation": "read", "additionalFields": { "parse_mode": "HTML", "appendAttribution": false } }, "position": [ 2592, 160 ] } ] }

Track new box office releases with BrowserAct, Google Sheets, OpenRouter and Telegram