AutomationMart
Home/Browse/Scrape, structure, and store news data using Decodo, Gemini AI and Google Sheets
n8n

Scrape, structure, and store news data using Decodo, Gemini AI and Google Sheets

n8nn8n13 modulesv1.0
Google SheetsGemini

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 1. Trigger: Workflow runs on schedule. 2. Data Setup: Defines

At a glance

Scrape, structure, and store news data using Decodo, Gemini AI and Google Sheets is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Google Sheets, Gemini. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Google Sheets, Gemini
Modules
13
Price
Free
Version
v1.0
Scrape, structure, and store news data using Decodo, Gemini AI and Google Sheets workflow diagram

About this workflow

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 1. Trigger: Workflow runs on schedule. 2. Data Setup: Defines forum URLs and geolocation. 3. Scraping: Extracts raw text data using the Decodo API. 4. AI Extraction: Gemini parses and structures the scraped text into clean JSON. 5. Data Storage: Each news item is appended or updated in Google Sheets. 6. 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.

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

Send aggregated JSON data from a custom webhook to Google Sheets and respond via webhook

Automatically send aggregated JSON data from a custom webhook to Google Sheets, then respond via webhook, streamlining data management and communication.

Free

Zillow property scraper by location via Bright Data & Google Sheets

Google Maps Business Phone Number Scraper Using Bright Data API & Google Sheets Integration This template requires a self-hosted n8n instance to run. An automated workflow that extracts business information including phone numbers from Google Maps using Bright Data's API and saves the data to Google Sheets for easy access and analysis. 📋 Overview This workflow provides an automated solution for extracting business contact information from Google Maps based on location and keyword searches. Perfe

Free

Add Google Sheets rows for new CallTrackingMetrics calls

Every time a new call in CallTrackingMetrics appears, Make will automatically add a Google Sheets row. Here's the [sheet](https://docs.google.com/spreadsheets/d/1gkQeO9_J3jW_rbboc-ysrFgjl_F37vqy2cafR4JoHg0/edit?usp=sharing) used in this scenario.

Free

Auto-Enrich New Leads in Google Sheets with Lusha

Automatically enrich new leads in Google Sheets with Lusha contact data in real-time. Watches for new rows and bulk enriches them with emails, phone numbers, and company information instantly.

Free

Create rows in Google sheets for new Postmark bounced emails

Every time an email is bounced in your Postmark, Make will add rows with information on it in your Google Sheets. This scenario requires your sheet to be configured like (this)[https://docs.google.com/spreadsheets/d/176-YDNnqDU3tLCbw24HuVnUAP5aNm23-mKP9-9mhmHQ/edit?usp=sharing].

Free

Automate restaurant customer service with WhatsApp and Llama AI chatbot

An intelligent WhatsApp-based chatbot designed for restaurants to automate customer interactions related to table bookings, menu inquiries, opening hours, services, and offers. Built using the n8n automation platform and powered by an AI language model, this solution streamlines communication, boosts efficiency, and improves customer satisfaction. Objectives Automate replies to common customer queries on WhatsApp Handle table booking requests with confirmation Provide menu item detail

Free

Document-based chatbot with memory using OpenAI, Pinecone and Google Drive

Who is This For? This is for normal people or people just starting off and wanting to have a AI chatbot that can process data to use when talking to the user. How to Use You will need to have your own OpenRouter (Free) and OpenAI APIs as well as Google Drive, Pinecone, and Airtable. What Do You Want? If you want to have your AI Agent remember the user's preferences even after the session is over then you can keep the Airtable node in, if not you can delete it.

Free

Automated resume review system using OpenAI + Google Sheets

Who is this for? This workflow is ideal for: - HR teams and recruiters seeking to streamline resume screening. - Hiring managers who want quick, summarized candidate insights. - Recruitment agencies handling large volumes of applicant data. - Startups and small businesses looking to automate hiring without complex systems. - AI and automation professionals who want to build smart HR workflows using n8n and OpenAI. What problem is this workflow solving? / Use Case - Manually reviewing resumes is

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free