CoinGecko crypto price forecasting pipeline with Gemini AI, Decodo, and Gmail
Automated Crypto Forecast Pipeline using Decodo and Gmail Sign Up for Decodo HERE for discount This template scrapes CoinGecko pages for selected coins, converts metrics into clean JSON, stores them in an n8n Data Table, generates 24-hour direction forecasts with Gemini, and emails a concise report. Who’s it for? Crypto watchers who want automated snapshots, forecasts, and a daily email—without managing a full data stack. How it works 30-min schedule loops coins, scrapes CoinGecko (Decodo), parses metrics, and upserts to Data Table. 18:00 schedule loads last 48h data. Gemini estimates next-24h direction windows. Email is rendered (HTML + plain text) and sent. How to set up Add Decodo, Gmail, and Gemini credentials. Open Configure Coins to edit tickers. Set Data Table ID. Replace recipient email. (Self-host only) Community node Decodo required. @decodo/n8n-nodes-decodo (community)
By Fahmi FahrezaSearch Skool community posts with Claude and Google Docs analysis
How it works Form Trigger accepts a question and optional settings (folder ID, search depth) Cookie Validation checks if Skool session is still active BuildId Extraction dynamically extracts Skool's build ID from homepage Keyword Extraction uses Claude Haiku to extract 1-2 search keywords Multi-Page Search fetches 1-10 pages of Skool search results Post Aggregation collects all posts with content and comments AI Analysis uses Claude Sonnet to analyze posts and answer your question Google Doc Report creates a detailed research document in your Drive HTML Response returns a beautiful summary page Key Features Auto BuildId Detection - No manual updates when Skool changes Cookie Expiration Handling - Clear error messages when session expires Configurable Search Depth - Search 1-10 pages (default: 5) Token Protection - Limits content to control API costs Dual AI Models - Haiku for keywords (cheap), Sonnet for analysis (powerful) Set up steps Time required: 10-15 minutes Get your Skool session cookie from browser DevTools Get an Anthropic API key from console.anthropic.com Set up Google Docs OAuth2 credential in n8n Create a Google Drive folder for research docs Update the Config node with your values: COOKIE - Your Skool session cookie ANTHROPICAPIKEY - Your Claude API key DEFAULTFOLDERID - Your Google Drive folder ID COMMUNITY - Your Skool community slug Who is this for? Members of Skool communities searching past discussions Community managers researching common questions Anyone building knowledge bases from Skool content Estimated costs Per search: $0.02-0.10 (Claude Haiku + Sonnet) Skool cookies expire every 7-14 days (requires refresh) --- 🏷️ Suggested Tags skool, community, search, ai, claude, anthropic, google-docs, research, knowledge-base, form
By Nitin Garg