AI Powered Web Scraping with Jina, Google Sheets and OpenAI : the EASY way
n8n template #2552Summary
Use templatePurpose 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: Web Scraping: Uses the Jina AI service to scrape website data and convert it into LLM-friendly text. Information Extraction: Employs an AI node to extract specific book details (title, price, availability, image URL, product URL) from the scraped data. Data Splitting: Splits the extracted information into individual book entries. Google Sheets Integration: Automatically populates a Google Sheets spreadsheet with the structured book data. Step by step setup: Set up Jina AI service: Sign up for
Hand off to your agent
Prompt
Help me set up the n8n workflow "AI Powered Web Scraping with Jina, Google Sheets and OpenAI : the EASY way" (https://n8n.io/workflows/2552). It uses: Google Sheets, HTTP Request, OpenAI Chat Model, Information Extractor. Import the template JSON into my n8n instance, list every credential I need to create, and walk me through testing it.
Paste into Claude Code and it will do the rest.
Apps and nodes
Similar workflows
NameViews
- Scrape Trustpilot Reviews with DeepSeek, Analyze Sentiment with OpenAI11K
- Real Estate Intelligence Tracker with Bright Data & OpenAI7,538
- Explore n8n Nodes in a Visual Reference Library5,197
- TrustPilot SaaS Product Review Tracker with Bright Data & OpenAI822
- Automate Customer Support with Gmail, Google Sheets, ERP Data & GPT-4o AI778
- Automated Local Lead Finder & Cold Email Sender with Apify, AI, and Gmail498
- Real-time Extract of Job, Company, Salary Details via Bright Data MCP & OpenAI401
- Create Song Lyric Documents and Spotify Playlists for Singers with Google Docs265