AI Powered Web Scraping with Jina, Google Sheets and OpenAI : the EASY way

n8n template #2552

Summary

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: 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

How to set it up

Open template #2552 on n8n.io and click Use for free, or copy the template JSON and paste it onto an empty canvas in n8n.
Create 2 credentials under Credentials → Add credential: Google Sheets, OpenAI Chat Model. Then open each of those nodes and pick the credential.
Check the model in the OpenAI Chat Model node. The template may point at a model your account can't use; swap it for one you have access to.
Click Execute workflow and step through each node's output to confirm the data looks right.
Toggle the workflow to Active so its trigger runs on its own.

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

Google Sheets HTTP Request OpenAI Chat Model Information Extractor

Questions

Yes. Derek Cheung published it free on n8n.io as a verified creator, and it has 44K views. It runs on n8n Cloud or a self-hosted n8n instance.

Google Sheets, OpenAI Chat Model. The other 2 nodes are built into n8n.

Similar workflows

NameViews