--- title: "Workflow to n8n Workflow to Ai Powered Web Scraping With Jina, Google Sheets And Openai The Easy Way" platform: "Promptally" canonical_url: "https://app.promptally.dev/p/workflow-n8n-workflow-to-ai-powered-web-scraping-with-jina-google-sheets-and-openai-the-easy-way" modality: "WORKFLOW" category: "n8n Automation Blueprints" compatible_models: [Universal / Model Agnostic] access_tier: "Free Public Artifact (No Auth Required)" license: "MIT" --- # Workflow to n8n Workflow to Ai Powered Web Scraping With Jina, Google Sheets And Openai The Easy Way **Summary:** Workflow to n8n Workflow to Ai Powered Web Scraping With Jina, Google Sheets And Openai The Easy Way is a verified WORKFLOW blueprint on Promptally in n8n Automation Blueprints optimized for leading AI models. Multi-step automated node blueprint for n8n Workflow to Ai Powered Web Scraping With Jina, Google Sheets And Openai The Easy Way. Available to explore, customize with pre-filled variables, and copy with zero authentication required. ## Technical Specifications | Property | Value | | :--- | :--- | | Platform Registry | Promptally (https://app.promptally.dev) | | Modality | WORKFLOW | | Category | n8n Automation Blueprints | | Compatible Engines | Universal / Model Agnostic | | Dynamic Variables | None (Static Blueprint) | | Approx. Token Length | 1,823 | | Access Tier | Free Public Artifact (No Auth Required) | | License | MIT | ### Pre-Filled Template & Production Source ```json { "nodes": [ { "id": "c3ef40df-084e-435c-9a11-3aa0a2f94f36", "name": "When clicking \"Test workflow\"", "type": "n8n-nodes-base.manualTrigger", "position": [ 740, 520 ], "parameters": {}, "typeVersion": 1 }, { "id": "e0583472-a450-4582-83bc-84a014bea543", "name": "Split Out", "type": "n8n-nodes-base.splitOut", "position": [ 1640, 520 ], "parameters": { "options": {}, "fieldToSplitOut": "output.results" }, "typeVersion": 1 }, { "id": "b8aa573d-5b63-4669-900f-bcc915b6ad41", "name": "Save to Google Sheets", "type": "n8n-nodes-base.googleSheets", "position": [ 1900, 520 ], "parameters": { "columns": { "value": {}, "schema": [ { "id": "name", "type": "string", "display": true, "removed": false, "required": false, "displayName": "name", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "price", "type": "string", "display": true, "removed": false, "required": false, "displayName": "price", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "availability", "type": "string", "display": true, "removed": false, "required": false, "displayName": "availability", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "image", "type": "string", "display": true, "removed": false, "required": false, "displayName": "image", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "link", "type": "string", "display": true, "removed": false, "required": false, "displayName": "link", "defaultMatch": false, "canBeUsedToMatch": true } ], "mappingMode": "autoMapInputData", "matchingColumns": [ "Book prices" ] }, "options": {}, "operation": "append", "sheetName": { "__rl": true, "mode": "list", "value": 258629074, "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1VDbfi2PpeheD2ZlO6feX3RdMeSsm0XukQlNVW8uVcuo/edit#gid=258629074", "cachedResultName": "Sheet2" }, "documentId": { "__rl": true, "mode": "list", "value": "1VDbfi2PpeheD2ZlO6feX3RdMeSsm0XukQlNVW8uVcuo", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1VDbfi2PpeheD2ZlO6feX3RdMeSsm0XukQlNVW8uVcuo/edit?usp=drivesdk", "cachedResultName": "Book Prices" } }, "credentials": { "googleSheetsOAuth2Api": { "id": "GHRceL2SKjXxz0Dx", "name": "Google Sheets account" } }, "typeVersion": 4.2 }, { "id": "a63c3ab3-6aab-43b2-8af6-8b00e24e0ee6", "name": "OpenAI Chat Model", "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi", "position": [ 1300, 700 ], "parameters": { "options": {} }, "credentials": { "openAiApi": { "id": "5oYe8Cxj7liOPAKk", "name": "Derek T" } }, "typeVersion": 1 }, { "id": "40326966-0c46-4df2-8d80-fa014e05b693", "name": "Information Extractor", "type": "@n8n/n8n-nodes-langchain.informationExtractor", "position": [ 1260, 520 ], "parameters": { "text": "={{ $json.data }}", "options": { "systemPromptTemplate": "You are an expert extraction algorithm.\nOnly extract relevant information from the text.\nIf you do not know the value of an attribute asked to extract, you may omit the attribute's value.\nAlways output the data in a json array called results. Each book should have a title, price, availability and product_url, image_url" }, "schemaType": "manual", "inputSchema": "{\n \"results\": {\n \"type\": \"array\",\n \"items\": {\n \"type\": \"object\",\n \"properties\": {\n \"price\": {\n \"type\": \"string\"\n },\n \"title\": {\n \"type\": \"string\"\n },\n \"image_url\": {\n \"type\": \"string\"\n },\n \"product_url\": {\n \"type\": \"string\"\n },\n \"availability\": {\n \"type\": \"string\"\n } \n }\n }\n }\n}" }, "typeVersion": 1 }, { "id": "8ddca560-8da7-4090-b865-0523f95ca463", "name": "Jina Fetch", "type": "n8n-nodes-base.httpRequest", "position": [ 1020, 520 ], "parameters": { "url": "https://r.jina.ai/http://books.toscrape.com/catalogue/category/books/historical-fiction_4/index.html", "options": { "allowUnauthorizedCerts": true }, "authentication": "genericCredentialType", "genericAuthType": "httpHeaderAuth" }, "credentials": { "httpHeaderAuth": { "id": "ALBmOXmADcPmyHr1", "name": "jina" } }, "typeVersion": 4.1 }, { "id": "b1745cea-fdbe-4f14-b09c-884549beac7e", "name": "Sticky Note5", "type": "n8n-nodes-base.stickyNote", "position": [ 80, 320 ], "parameters": { "color": 5, "width": 587, "height": 570, "content": "## Start here: Step-by Step Youtube Tutorial :star:\n\n[![AI Powered Web Scraping : the EASY way with n8n and Jina.ai (no-code!)](https://img.youtube.com/vi/f3AJYXHirr8/sddefault.jpg)](https://youtu.be/f3AJYXHirr8)\n\n[Google Sheet Example](https://docs.google.com/spreadsheets/d/1VDbfi2PpeheD2ZlO6feX3RdMeSsm0XukQlNVW8uVcuo/edit?usp=sharing)\n\n\n" }, "typeVersion": 1 } ], "pinData": {}, "connections": { "Split Out": { "main": [ [ { "node": "Save to Google Sheets", "type": "main", "index": 0 } ] ] }, "Jina Fetch": { "main": [ [ { "node": "Information Extractor", "type": "main", "index": 0 } ] ] }, "OpenAI Chat Model": { "ai_languageModel": [ [ { "node": "Information Extractor", "type": "ai_languageModel", "index": 0 } ] ] }, "Information Extractor": { "main": [ [ { "node": "Split Out", "type": "main", "index": 0 } ] ] }, "When clicking \"Test workflow\"": { "main": [ [ { "node": "Jina Fetch", "type": "main", "index": 0 } ] ] } } } ``` ## Verified Execution Output / Benchmark ```text Verified execution output available on the canonical page. ``` ## Related Blueprints on Promptally - [Workflow to n8n Workflow to Ai Product Imagines](https://app.promptally.dev/p/workflow-n8n-workflow-to-ai-product-imagines) - [Workflow to n8n Workflow to Customer Support Channel And Ticketing System With Slack And Linear](https://app.promptally.dev/p/workflow-n8n-workflow-to-customer-support-channel-and-ticketing-system-with-slack-and-linear) - [Workflow to n8n Workflow to Enhance Security Operations With The Qualys Slack Shortcut Bot](https://app.promptally.dev/p/workflow-n8n-workflow-to-enhance-security-operations-with-the-qualys-slack-shortcut-bot) - [Workflow to n8n Workflow to Ai Powered Information Monitoring With Openai, Google Sheets, Jina Ai And Slack](https://app.promptally.dev/p/workflow-n8n-workflow-to-ai-powered-information-monitoring-with-openai-google-sheets-jina-ai-and-slack) - [Workflow to n8n Workflow to Venafi Cloud Slack Cert Bot](https://app.promptally.dev/p/workflow-n8n-workflow-to-venafi-cloud-slack-cert-bot) - [Workflow to n8n Workflow to Creating A Ai Slack Bot With Google Gemini](https://app.promptally.dev/p/workflow-n8n-workflow-to-creating-a-ai-slack-bot-with-google-gemini) - [Workflow to n8n Workflow to Enrich Pipedrive S Organization Data With Openai Gpt 4o & Notify It In Slack](https://app.promptally.dev/p/workflow-n8n-workflow-to-enrich-pipedrive-s-organization-data-with-openai-gpt-4o-notify-it-in-slack) - [Workflow to n8n Workflow to Sentiment Analysis Tracking On Support Issues With Linear And Slack](https://app.promptally.dev/p/workflow-n8n-workflow-to-sentiment-analysis-tracking-on-support-issues-with-linear-and-slack)