Scrape, Structure, and Store News Data using Decodo, Gemini AI and Google Sheets
Sign up for Decodo HERE for Discount
Automatically scrape, structure, and log forum or news content using Decodo and Google Gemini AI. This workflow extracts key details like titles, URLs, authors, and engagement stats, then appends them to a Google Sheet for tracking and analysis.
Who’s it for? Ideal for data journalists, market researchers, or AI enthusiasts who want to monitor trending topics across specific domains.
How it works
Trigger: Workflow runs on schedule.
Data Setup: Defines forum URLs and geolocation.
Scraping: Extracts raw text data using the Decodo API.
AI Extraction: Gemini parses and structures the scraped text into clean JSON.
Data Storage: Each news item is appended or updated in Google Sheets.
Logging: Records scraping results for monitoring and debugging.
How to set up
Add your Decodo, Google Gemini, and Google Sheets credentials in n8n.
Adjust the forum URLs, geolocation, and Google Sheet ID in the Workflow Config node.
Set your preferred trigger interval in Schedule Trigger.
Activate and monitor from the n8n dashboard.
Related Templates
Track Expenses by Parsing Telegram Transaction Messages to Google Sheets
Overview This n8n workflow template automatically parses incoming Telegram transaction messages and logs structured dat...
Automated Work Attendance with Location Triggers
his workflow automates time tracking using location-based triggers. How it works Trigger: It starts when you enter or e...
Send Daily Weather Forecasts from OpenWeatherMap to Telegram with Smart Formatting
🌤️ Daily Weather Forecast Bot A comprehensive n8n workflow that fetches detailed weather forecasts from OpenWeatherMap...
🔒 Please log in to import templates to n8n and favorite templates
Workflow Visualization
Loading...
Preparing workflow renderer
Comments (0)
Login to post comments