{ "name": "CoinGecko crypto price forecasting pipeline with Gemini AI, Decodo, and Gmail", "nodes": [ { "id": "6aa0dcfa-48ed-463c-a477-18d970159127", "name": "Convert Output to JSON", "type": "n8n-nodes-base.code", "position": [ 3936, 400 ] }, { "id": "c33b813f-1080-4ead-909c-510a62cd9a1f", "name": "Insert Data", "type": "n8n-nodes-base.dataTable", "position": [ 3360, 80 ] }, { "id": "e68cc6d1-7067-4f27-963e-ae546d82ecbb", "name": "Structured Output Parser", "type": "@n8n/n8n-nodes-langchain.outputParserStructured", "position": [ 3472, 1200 ] }, { "id": "ede4f2a4-084c-4ace-8655-b4801946c501", "name": "Make it JSON", "type": "n8n-nodes-base.code", "position": [ 3120, 976 ] }, { "id": "5968e872-3bdc-4228-90a4-b49122bb230d", "name": "Schedule: Every 30m (Scrape & Log)", "type": "n8n-nodes-base.scheduleTrigger", "position": [ 2368, 272 ] }, { "id": "271dac9c-6d3d-473e-9ea5-652f09709603", "name": "Configure Coins", "type": "n8n-nodes-base.set", "position": [ 2688, 272 ] }, { "id": "3a1bc486-dcc4-4de4-81dc-af2d3c0e89b8", "name": "Build Coin Items", "type": "n8n-nodes-base.code", "position": [ 2912, 272 ] }, { "id": "0e5eb149-788c-4729-b497-061b3a1566ad", "name": "For Each Coin", "type": "n8n-nodes-base.splitInBatches", "position": [ 3136, 272 ] }, { "id": "2c60c81f-c105-485b-b50b-56c12b500384", "name": "Scrape CoinGecko (Decodo)", "type": "@decodo/n8n-nodes-decodo.decodo", "position": [ 3360, 272 ] }, { "id": "747ff368-e50e-475c-96ab-aa29cc6cdffd", "name": "Parse Coin Metrics (LLM)", "type": "@n8n/n8n-nodes-langchain.agent", "position": [ 3584, 272 ] }, { "id": "3b93b5fb-16d6-4019-bffc-c8d5dd697d9c", "name": "Gemini for Parsing", "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini", "position": [ 3648, 496 ] }, { "id": "562a5273-912e-425f-93e2-5ec458e5df9c", "name": "Load Data Last 48h", "type": "n8n-nodes-base.dataTable", "position": [ 2896, 976 ] }, { "id": "cff81961-78d3-4379-9bfe-5f08c7911772", "name": "Forecast Next 24h (LLM)", "type": "@n8n/n8n-nodes-langchain.agent", "position": [ 3344, 976 ] }, { "id": "ad61fea0-50a3-40fa-ae06-02791229cd7a", "name": "Build Email (HTML + Text)", "type": "n8n-nodes-base.code", "position": [ 3696, 976 ] }, { "id": "7b0e3303-83a7-4c7c-9bb3-30c70b53cd61", "name": "Send Email (Gmail)", "type": "n8n-nodes-base.gmail", "position": [ 3920, 976 ] }, { "id": "6c19a46b-4b61-4ad4-93a1-2290245f2abc", "name": "Gemini for Forecast", "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini", "position": [ 3344, 1200 ] }, { "id": "fd345994-c880-4f85-8a40-47fce172067a", "name": "Sticky Note2", "type": "n8n-nodes-base.stickyNote", "position": [ 3552, -80 ], "parameters": { "width": 400, "height": 304, "content": "Map fields to your Data Table schema. Keep numbers as pure numeric types.\n\nThe data type you must implement to your Data Table:\n\n{\n\"coin\": string,\n\"ts\": string,\n\"price\": number,\n\"change_1h\": number,\n\"" } }, { "id": "4a55d976-22ad-4472-9067-7c2b908907a2", "name": "Sticky Note4", "type": "n8n-nodes-base.stickyNote", "position": [ 2288, 176 ], "parameters": { "width": 272, "height": 256, "content": "Ensure your instance timezone matches your expectations; schedule uses server time." } }, { "id": "a4df8330-2abe-4e5b-9be3-a008560e1451", "name": "Recipient Email + Timezone", "type": "n8n-nodes-base.set", "position": [ 2672, 976 ] }, { "id": "7c64ce06-c4d3-429d-84fc-547c405bbabb", "name": "Sticky Note3", "type": "n8n-nodes-base.stickyNote", "position": [ 2144, 800 ], "parameters": { "width": 2080, "height": 640, "content": "## Forecast Email Automation (Daily 18:00)\nThis flow loads the last 48h of crypto data, generates 24h price movement forecasts using Gemini LLM, and sends a formatted HTML email report to the configur" } }, { "id": "6944c78b-ffd1-4d24-8a54-ed97b2b2c89d", "name": "Sticky Note5", "type": "n8n-nodes-base.stickyNote", "position": [ 2144, -224 ], "parameters": { "width": 2080, "height": 944, "content": "## CoinGecko Scraper & Data Logger (Every 30m)\nThis flow scrapes live cryptocurrency data from CoinGecko at regular 30-minute intervals and stores it in the Data Table for historical tracking and fore" } }, { "id": "2ef7a728-db5b-4554-9b73-7d74d8d52d8a", "name": "Schedule: 18:00 Daily (Forecast Email)", "type": "n8n-nodes-base.scheduleTrigger", "position": [ 2464, 976 ] }, { "id": "d4395fd8-0fe4-4fb5-ac92-7221c886e0c3", "name": "Sticky Note6", "type": "n8n-nodes-base.stickyNote", "position": [ 1408, -48 ], "parameters": { "width": 592, "height": 672, "content": "## Automated Crypto Forecast Pipeline using Decodo and Gmail\n\nSign Up for Decodo [HERE](https://visit.decodo.com/discount) for discount\n\nThis template scrapes CoinGecko pages for selected coins, conve" } }, { "id": "5a1706fb-f834-4aa6-b7fa-728ef5398fb6", "name": "Sticky Note7", "type": "n8n-nodes-base.stickyNote", "position": [ 2608, 160 ], "parameters": { "width": null, "height": 272, "content": "Edit coin values (e.g., bitcoin, ethereum, solana). Use CoinGecko slugs.\n\nhttps://www.coingecko.com/" } }, { "id": "5cf76592-2370-4c62-94ef-d886a470a0fd", "name": "Sticky Note9", "type": "n8n-nodes-base.stickyNote", "position": [ 2416, -1040 ], "parameters": { "width": 1360, "height": 800, "content": "@[youtube](PDc0MwcicDQ)\n" } } ], "connections": { "Make it JSON": { "main": [ [ { "node": "Forecast Next 24h (LLM)", "type": "main", "index": 0 } ] ] }, "For Each Coin": { "main": [ [ { "node": "Insert Data", "type": "main", "index": 0 } ], [ { "node": "Scrape CoinGecko (Decodo)", "type": "main", "index": 0 } ] ] }, "Configure Coins": { "main": [ [ { "node": "Build Coin Items", "type": "main", "index": 0 } ] ] }, "Build Coin Items": { "main": [ [ { "node": "For Each Coin", "type": "main", "index": 0 } ] ] }, "Gemini for Parsing": { "ai_languageModel": [ [ { "node": "Parse Coin Metrics (LLM)", "type": "ai_languageModel", "index": 0 } ] ] }, "Load Data Last 48h": { "main": [ [ { "node": "Make it JSON", "type": "main", "index": 0 } ] ] }, "Gemini for Forecast": { "ai_languageModel": [ [ { "node": "Forecast Next 24h (LLM)", "type": "ai_languageModel", "index": 0 } ] ] }, "Convert Output to JSON": { "main": [ [ { "node": "For Each Coin", "type": "main", "index": 0 } ] ] }, "Forecast Next 24h (LLM)": { "main": [ [ { "node": "Build Email (HTML + Text)", "type": "main", "index": 0 } ] ] }, "Parse Coin Metrics (LLM)": { "main": [ [ { "node": "Convert Output to JSON", "type": "main", "index": 0 } ] ] }, "Structured Output Parser": { "ai_outputParser": [ [ { "node": "Forecast Next 24h (LLM)", "type": "ai_outputParser", "index": 0 } ] ] }, "Build Email (HTML + Text)": { "main": [ [ { "node": "Send Email (Gmail)", "type": "main", "index": 0 } ] ] }, "Scrape CoinGecko (Decodo)": { "main": [ [ { "node": "Parse Coin Metrics (LLM)", "type": "main", "index": 0 } ] ] }, "Recipient Email + Timezone": { "main": [ [ { "node": "Load Data Last 48h", "type": "main", "index": 0 } ] ] }, "Schedule: Every 30m (Scrape & Log)": { "main": [ [ { "node": "Configure Coins", "type": "main", "index": 0 } ] ] }, "Schedule: 18:00 Daily (Forecast Email)": { "main": [ [ { "node": "Recipient Email + Timezone", "type": "main", "index": 0 } ] ] } } }