# AI powered web scraping with Jina, Google Sheets and OpenAI : the EASY way

> 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 website data and convert it into LLM-friendly text. 2. Information Extraction: Employs an AI node to extract specific book details (title, price, availability, image URL, product URL) from the scraped data. 3. Data Splitting: Splits the extracted information into individual book entries. 4. Google Sheets Integration: Automatically populates a Google Sheets spreadsheet with the structured book data. Step by step setup: 1. Set up Jina AI service: - Sign up for a Jina AI account and obtain an API key. 2. Configure the HTTP Request node: - Enter the Jina AI URL with the target website. - Add the API key to the request headers for authentication. 3. Set up the Information Extractor node: - Use Claude AI to generate a JSON schema for data ext

- **Domain**: `n8n-workflow-2552.n8n.io`
- **Provider**: n8n.io (https://n8n.io)
- **Kind**: workflow
- **Category**: web
- **Live-responds (last probe)**: None
- **Signed card**: False
- **Streaming**: False
- **Quality score**: 40%

## URLs
- Agent card: https://n8n.io/workflows/2552
- Page (HTML): https://agenstry.com/agents/n8n-workflow-2552.n8n.io
- Documentation: https://n8n.io/workflows/2552