+3
AI Powered Web Scraping with Jina, Google Sheets and OpenAI : the EASY way
Published 3 days ago
Created by
Derek Cheung
Categories
Template description
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 a Jina AI account and obtain an API key.
-
Configure the HTTP Request node:
- Enter the Jina AI URL with the target website.
- Add the API key to the request headers for authentication.
-
Set up the Information Extractor node:
- Use Claude AI to generate a JSON schema for data extraction.
- Upload a screenshot of the target website to Claude AI.
- Ask Claude AI to suggest a JSON schema for extracting required information.
- Copy the generated schema into the Information Extractor node.
-
Configure the Split node:
- Set it up to separate the extracted data into individual book entries.
-
Set up the Google Sheets node:
- Create a Google Sheets spreadsheet with columns for title, price, availability, image URL, and product URL.
- Configure the node to map the extracted data to the appropriate columns.
Share Template
More AI workflow templates
AI agent chat
This workflow employs OpenAI's language models and SerpAPI to create a responsive, intelligent conversational agent. It comes equipped with manual chat triggers and memory buffer capabilities to ensure seamless interactions.
To use this template, you need to be on n8n version 1.50.0 or later.
n8n Team
+7
Scrape and summarize webpages with AI
This workflow integrates both web scraping and NLP functionalities. It uses HTML parsing to extract links, HTTP requests to fetch essay content, and AI-based summarization using GPT-4o. It's an excellent example of an end-to-end automated task that is not only efficient but also provides real value by summarizing valuable content.
Note that to use this template, you need to be on n8n version 1.50.0 or later.
n8n Team
+5
AI agent that can scrape webpages
⚙️🛠️🚀🤖🦾
This template is a PoC of a ReAct AI Agent capable of fetching random pages (not only Wikipedia or Google search results).
On the top part there's a manual chat node connected to a LangChain ReAct Agent. The agent has access to a workflow tool for getting page content.
The page content extraction starts with converting query parameters into a JSON object. There are 3 pre-defined parameters:
url** – an address of the page to fetch
method** = full / simplified
maxlimit** - maximum length for the final page. For longer pages an error message is returned back to the agent
Page content fetching is a multistep process:
An HTTP Request mode tries to get the page content.
If the page content was successfuly retrieved, a series of post-processing begin:
Extract HTML BODY; content
Remove all unnecessary tags to recude the page size
Further eliminate external URLs and IMG scr values (based on the method query parameter)
Remaining HTML is converted to Markdown, thus recuding the page lengh even more while preserving the basic page structure
The remaining content is sent back to an Agent if it's not too long (maxlimit = 70000 by default, see CONFIG node).
NB:
You can isolate the HTTP Request part into a separate workflow.
Check the Workflow Tool description, it guides the agent to provide a query string with several parameters instead of a JSON object.
Please reach out to Eduard is you need further assistance with you n8n workflows and automations!
Note that to use this template, you need to be on n8n version 1.19.4 or later.
Eduard
