AI powered web scraping with Jina, Google Sheets and OpenAI : the EASY way
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 6 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets and OpenAI Chat Model. It also calls r.jina.ai over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Jina Fetch (HTTP Request): calls r.jina.ai
- Information Extractor: extracts structured fields from text with AI, with model: OpenAI Chat Model
- Split Out: splits a list into separate items
- Save to Google Sheets (Google Sheets): append
Services it uses
HTTP calls to: r.jina.ai
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (6)
- Manual Trigger
n8n-nodes-base.manualTrigger - Split Out
n8n-nodes-base.splitOut - Google Sheets
n8n-nodes-base.googleSheets - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Information Extractor
@n8n/n8n-nodes-langchain.informationExtractor - HTTP Request
n8n-nodes-base.httpRequest
From the author
Purpose of workflow: The purpose of this workflow is to automate scraping of a website, transforming it into a structured format, and loading it directly into a Google Sheets spreadsheet. How it works: 1. Web Scraping: Uses the Jina AI service to scrape…