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
Automated SEO Performance Collection from Google Search Console to NocoDB
Problem Monitoring SEO performance from Google Search Console (GSC) manually is repetitive and prone to human error. Fo...
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...
Lookup IP Geolocation Details with IP-API.com via Webhook
This n8n template enables you to instantly retrieve detailed geolocation information for any given IP address by simply ...
🔒 Please log in to import templates to n8n and favorite templates
Workflow Visualization
Loading...
Preparing workflow renderer
Comments (0)
Login to post comments