prospect-wiki Add Your Business
Jeeva Keerakatti

Jeeva Keerakatti

verified UI & UX Developer

Prospect Wiki Intern at Prospect Wiki, , , None

Chittoor, Andhra Pradesh, India

https://jeeva-k323.github.io/jeeva-portfolio/
View Profile 0 Viewed

Profile last updated - 27 Mar 2026

Category:AI Agents Industry:Design & Creative

Data Scraping using AI

This Workflow helps to get information using Google Gemini AI .


Code Block
JASON
{ "name": "Data Scraping using AI", "nodes": [ { "parameters": { "promptType": "define", "text": "=Provide the official company name, website URL, phone number, Industry and full address for the company: \"{{ $json[\"Company Name\"] }}\".\nRespond only in valid JSON without code fences, without markdown, without explanations.\nFormat exactly as:\n{\n \"name\": \"string or null\",\n \"Industry\": \"string or null\",\n \"url\": \"string or null\",\n \"phone\": \"string or null\",\n \"address\": \"string or null\"\n}\nIf unknown, return null for the field.\n", "options": {} }, "type": "@n8n/n8n-nodes-langchain.agent", "typeVersion": 2.1, "position": [ 1392, -864 ], "id": "ff28d087-efc1-4daa-b8e0-7b9289bc2ef0", "name": "AI Agent", "alwaysOutputData": false }, { "parameters": { "options": {} }, "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini", "typeVersion": 1, "position": [ 1464, -640 ], "id": "d016ced1-7d1c-4d9f-b0d5-e748722b68b8", "name": "Google Gemini Chat Model", "credentials": { "googlePalmApi": { "id": "XYWY8qJpCHeJhkEV", "name": "Google Gemini(PaLM) Api account" } } }, { "parameters": { "formTitle": "Data Request", "formFields": { "values": [ { "fieldLabel": "Company Name", "placeholder": "Search" } ] }, "options": {} }, "type": "n8n-nodes-base.formTrigger", "typeVersion": 2.2, "position": [ 1168, -864 ], "id": "1a579360-5adf-4f90-92f4-713999c78415", "name": "On form submission", "webhookId": "137919f4-32e6-48cf-8533-6fe8e9ac1b81" }, { "parameters": { "operation": "append", "documentId": { "__rl": true, "value": "1uelihPsgrEJDSibCmjBSTCwEiue9E5Gr_VyL4wXemCc", "mode": "list", "cachedResultName": "Company Info", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1uelihPsgrEJDSibCmjBSTCwEiue9E5Gr_VyL4wXemCc/edit?usp=drivesdk" }, "sheetName": { "__rl": true, "value": "gid=0", "mode": "list", "cachedResultName": "Sheet1", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1uelihPsgrEJDSibCmjBSTCwEiue9E5Gr_VyL4wXemCc/edit#gid=0" }, "columns": { "mappingMode": "autoMapInputData", "value": {}, "matchingColumns": [], "schema": [ { "id": "name", "displayName": "name", "required": false, "defaultMatch": false, "display": true, "type": "string", "canBeUsedToMatch": true, "removed": false }, { "id": "Industry", "displayName": "Industry", "required": false, "defaultMatch": false, "display": true, "type": "string", "canBeUsedToMatch": true, "removed": false }, { "id": "url", "displayName": "url", "required": false, "defaultMatch": false, "display": true, "type": "string", "canBeUsedToMatch": true, "removed": false }, { "id": "address", "displayName": "address", "required": false, "defaultMatch": false, "display": true, "type": "string", "canBeUsedToMatch": true, "removed": false }, { "id": "contact", "displayName": "contact", "required": false, "defaultMatch": false, "display": true, "type": "string", "canBeUsedToMatch": true, "removed": false } ], "attemptToConvertTypes": false, "convertFieldsToString": false }, "options": {} }, "type": "n8n-nodes-base.googleSheets", "typeVersion": 4.6, "position": [ 1968, -864 ], "id": "5da760bd-1547-4620-82f3-c35368ab78f3", "name": "Append row in sheet", "credentials": { "googleSheetsOAuth2Api": { "id": "VouTxRdZOibVdLDu", "name": "Google Sheets account" } } }, { "parameters": { "jsCode": "// Get AI output string\nlet raw = $input.item.json.output || \"\";\n\n// Remove markdown code fences if present\nraw = raw.replace(/```json|```/g, \"\").trim();\n\n// Try to parse JSON\nlet data;\ntry {\n data = JSON.parse(raw);\n} catch (e) {\n data = {};\n}\n\n// Build the clean object\nconst result = {\n name: data.name || null,\n Industry: data.Industry || null,\n url: data.url || null,\n address: data.address || null,\n contact: data.phone || null\n};\n\n// Return as JSON so it shows as separate columns in Table view\nreturn [ { json: result } ];\n" }, "type": "n8n-nodes-base.code", "typeVersion": 2, "position": [ 1744, -864 ], "id": "bb390e0e-59bc-4f07-a5a5-47f836ddd69d", "name": "Code" }, { "parameters": { "documentId": { "__rl": true, "value": "1xuEmKO1Z11KD3tahHUmklmCFAHTbITs7_LeZeLTWdu4", "mode": "list", "cachedResultName": "Input", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1xuEmKO1Z11KD3tahHUmklmCFAHTbITs7_LeZeLTWdu4/edit?usp=drivesdk" }, "sheetName": { "__rl": true, "value": "gid=0", "mode": "list", "cachedResultName": "Sheet1", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1xuEmKO1Z11KD3tahHUmklmCFAHTbITs7_LeZeLTWdu4/edit#gid=0" }, "options": {} }, "type": "n8n-nodes-base.googleSheets", "typeVersion": 4.6, "position": [ 1168, -308 ], "id": "887fcadf-4cde-4e2b-83f2-7c522413299e", "name": "Get row(s) in sheet", "credentials": { "googleSheetsOAuth2Api": { "id": "VouTxRdZOibVdLDu", "name": "Google Sheets account" } } }, { "parameters": { "promptType": "define", "text": "=Provide the official company name, website URL, phone number, and full address for the company:{{ $json['Company Name'] }} .\nRespond only in valid JSON without code fences, without markdown, without explanations.\nFormat exactly as:\n{\n \"name\": \"string or null\",\n \"url\": \"string or null\",\n \"phone\": \"string or null\",\n \"address\": \"string or null\"\n}\nIf unknown, return null for the field.\n", "options": {} }, "type": "@n8n/n8n-nodes-langchain.agent", "typeVersion": 2.1, "position": [ 1392, -308 ], "id": "de8dfed0-631c-4685-b39e-a9fd4b7ff19a", "name": "AI Agent1", "alwaysOutputData": false, "executeOnce": false, "retryOnFail": false, "notesInFlow": false, "onError": "continueRegularOutput" }, { "parameters": { "jsCode": "const items = $input.all();\n\nconst result = items.map((item) => {\n let raw = item.json.output || \"\";\n raw = raw.replace(/```json|```/g, \"\").trim();\n\n let data;\n try {\n data = JSON.parse(raw);\n } catch (e) {\n data = {};\n }\n\n return {\n json: {\n name: data.name || null,\n url: data.url || null,\n industry: data.industry || null,\n annual_revenue: data.annual_revenue || null,\n number_of_employees: data.number_of_employees || null,\n address: data.address || null,\n contact: data.phone || null,\n linkedin: data.linkedin || null,\n },\n };\n});\n\nreturn result;\n" }, "type": "n8n-nodes-base.code", "typeVersion": 2, "position": [ 2320, -308 ], "id": "5e9f5a52-98a7-45c8-9025-3916b66851bd", "name": "Code1" }, { "parameters": { "operation": "append", "documentId": { "__rl": true, "value": "1PhOieENyhXGlafn7lGi7ducpAvb_3C7HUGkR83g59PY", "mode": "list", "cachedResultName": "Output", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1PhOieENyhXGlafn7lGi7ducpAvb_3C7HUGkR83g59PY/edit?usp=drivesdk" }, "sheetName": { "__rl": true, "value": "gid=0", "mode": "list", "cachedResultName": "Sheet1", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1PhOieENyhXGlafn7lGi7ducpAvb_3C7HUGkR83g59PY/edit#gid=0" }, "columns": { "mappingMode": "defineBelow", "value": { "Company Name": "={{ $json.name }}", "Website": "={{ $json.url }}", "Address": "={{ $json.address }}", "Industry": "={{ $json.industry }}", "Annual Revenue": "={{ $json.annual_revenue }}", "Number Of Employees": "={{ $json.number_of_employees }}", "Contact": "={{ $json.contact }}", "LinkedIn": "={{ $json.linkedin }}" }, "matchingColumns": [], "schema": [ { "id": "Company Name", "displayName": "Company Name", "required": false, "defaultMatch": false, "display": true, "type": "string", "canBeUsedToMatch": true }, { "id": "Website", "displayName": "Website", "required": false, "defaultMatch": false, "display": true, "type": "string", "canBeUsedToMatch": true }, { "id": "Industry", "displayName": "Industry", "required": false, "defaultMatch": false, "display": true, "type": "string", "canBeUsedToMatch": true, "removed": false }, { "id": "Annual Revenue", "displayName": "Annual Revenue", "required": false, "defaultMatch": false, "display": true, "type": "string", "canBeUsedToMatch": true, "removed": false }, { "id": "Number Of Employees", "displayName": "Number Of Employees", "required": false, "defaultMatch": false, "display": true, "type": "string", "canBeUsedToMatch": true, "removed": false }, { "id": "Address", "displayName": "Address", "required": false, "defaultMatch": false, "display": true, "type": "string", "canBeUsedToMatch": true }, { "id": "Contact", "displayName": "Contact", "required": false, "defaultMatch": false, "display": true, "type": "string", "canBeUsedToMatch": true, "removed": false }, { "id": "LinkedIn", "displayName": "LinkedIn", "required": false, "defaultMatch": false, "display": true, "type": "string", "canBeUsedToMatch": true, "removed": false } ], "attemptToConvertTypes": false, "convertFieldsToString": false }, "options": {} }, "type": "n8n-nodes-base.googleSheets", "typeVersion": 4.6, "position": [ 2544, -308 ], "id": "0bacc826-7084-4057-bd50-e595b8118854", "name": "Append row in sheet1", "credentials": { "googleSheetsOAuth2Api": { "id": "VouTxRdZOibVdLDu", "name": "Google Sheets account" } } }, { "parameters": { "promptType": "define", "text": "=Provide the official company information for: {{ $json['Company Name'] }}.\n\nRules:\n- Only return the HEADQUARTERS address of the company (not branch or random locations).\n- Phone number must be the official company contact number.\n- Annual revenue must be based on publicly available information (Google, company website, LinkedIn, Crunchbase, etc.). Do not guess.\n- If the information cannot be verified, return null.\n- Do not generate or assume information.\n\nRespond only in valid JSON without code fences, markdown, or explanations.\n\nFormat exactly as:\n\n{\n \"name\": \"string or null\",\n \"url\": \"string or null\",\n \"industry\": \"string or null\",\n \"phone\": \"string or null\",\n \"annual_revenue\": \"string or null\",\n \"number_of_employees\": \"string or null\",\n \"address\": \"Headquarters address only or null\",\n \"linkedin\": \"string or null\"\n}", "options": {} }, "id": "0fa1fe21-46a1-4802-9827-32f89d5b7a67", "name": "AI Agent Key2", "type": "@n8n/n8n-nodes-langchain.agent", "typeVersion": 2, "position": [ 1968, -432 ] }, { "parameters": { "options": {} }, "id": "489f3365-0e8f-462c-a475-dc92496d863e", "name": "Gemini Key2", "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini", "typeVersion": 1, "position": [ 2040, -208 ], "credentials": { "googlePalmApi": { "id": "g5rnEcfmVNtcnjN7", "name": "Google Gemini(PaLM) Api account 2" } } }, { "parameters": { "options": {} }, "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini", "typeVersion": 1, "position": [ 1464, -84 ], "id": "e0af27b9-ac2c-4f8b-940b-a838416b22de", "name": "Google Gemini Chat Model1", "credentials": { "googlePalmApi": { "id": "XYWY8qJpCHeJhkEV", "name": "Google Gemini(PaLM) Api account" } } }, { "parameters": { "conditions": { "options": { "caseSensitive": true, "leftValue": "", "typeValidation": "strict", "version": 3 }, "conditions": [ { "id": "4df97778-bed5-4926-8c68-9bf72ea70a42", "leftValue": "={{ $json.output }}", "rightValue": "Null", "operator": { "type": "string", "operation": "equals" } }, { "id": "a1043eae-4166-48ec-adc7-e1d601672f91", "leftValue": "", "rightValue": "", "operator": { "type": "string", "operation": "equals", "name": "filter.operator.equals" } } ], "combinator": "or" }, "options": {} }, "type": "n8n-nodes-base.if", "typeVersion": 2.3, "position": [ 1744, -308 ], "id": "0858e4d4-8748-49c4-8d1e-e3784fa84602", "name": "If" }, { "parameters": { "conditions": { "conditions": [ { "leftValue": "={{ !$json.output || $json.output.length < 20 }}", "operator": { "type": "boolean", "operation": "isTrue" } } ] }, "options": {} }, "type": "n8n-nodes-base.if", "typeVersion": 2, "position": [ 1792, 176 ], "id": "f242deff-0ce2-48cb-afa1-1df8742e79da", "name": "If (Check AI Fail)" }, { "parameters": { "jsCode": "const items = $input.all();\n\nreturn items.map(item => {\n let raw = item.json.output || \"\";\n raw = raw.replace(/```json|```/g, \"\").trim();\n\n let data;\n try {\n data = JSON.parse(raw);\n } catch {\n data = {};\n }\n\n return {\n json: {\n name: data.name || null,\n url: data.url || null,\n industry: data.industry || null,\n annual_revenue: data.annual_revenue || null,\n number_of_employees: data.number_of_employees || null,\n address: data.address || null,\n contact: data.phone || null,\n linkedin: data.linkedin || null\n }\n };\n});" }, "type": "n8n-nodes-base.code", "typeVersion": 2, "position": [ 2368, 176 ], "id": "ceae4b53-6a69-452a-9260-bec73fd7c496", "name": "Parse JSON" }, { "parameters": { "operation": "append", "documentId": { "__rl": true, "value": "1PhOieENyhXGlafn7lGi7ducpAvb_3C7HUGkR83g59PY", "mode": "list", "cachedResultName": "Output", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1PhOieENyhXGlafn7lGi7ducpAvb_3C7HUGkR83g59PY/edit?usp=drivesdk" }, "sheetName": { "__rl": true, "value": "gid=0", "mode": "list", "cachedResultName": "Sheet1", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1PhOieENyhXGlafn7lGi7ducpAvb_3C7HUGkR83g59PY/edit#gid=0" }, "columns": { "mappingMode": "defineBelow", "value": { "Company Name": "={{ $json.name }}", "Website": "={{ $json.url }}", "Address": "={{ $json.address }}", "Industry": "={{ $json.industry }}", "Annual Revenue": "={{ $json.annual_revenue }}", "Number Of Employees": "={{ $json.number_of_employees }}", "Contact": "={{ $json.contact }}", "LinkedIn": "={{ $json.linkedin }}" }, "matchingColumns": [], "schema": [ { "id": "Company Name", "displayName": "Company Name", "required": false, "defaultMatch": false, "display": true, "type": "string", "canBeUsedToMatch": true }, { "id": "Website", "displayName": "Website", "required": false, "defaultMatch": false, "display": true, "type": "string", "canBeUsedToMatch": true }, { "id": "Industry", "displayName": "Industry", "required": false, "defaultMatch": false, "display": true, "type": "string", "canBeUsedToMatch": true }, { "id": "Annual Revenue", "displayName": "Annual Revenue", "required": false, "defaultMatch": false, "display": true, "type": "string", "canBeUsedToMatch": true }, { "id": "Number Of Employees", "displayName": "Number Of Employees", "required": false, "defaultMatch": false, "display": true, "type": "string", "canBeUsedToMatch": true }, { "id": "Address", "displayName": "Address", "required": false, "defaultMatch": false, "display": true, "type": "string", "canBeUsedToMatch": true }, { "id": "Contact", "displayName": "Contact", "required": false, "defaultMatch": false, "display": true, "type": "string", "canBeUsedToMatch": true }, { "id": "LinkedIn", "displayName": "LinkedIn", "required": false, "defaultMatch": false, "display": true, "type": "string", "canBeUsedToMatch": true } ], "attemptToConvertTypes": false, "convertFieldsToString": false }, "options": {} }, "type": "n8n-nodes-base.googleSheets", "typeVersion": 4.6, "position": [ 2592, 176 ], "id": "2798a9ec-e78e-437d-a04b-8cadca1e5004", "name": "Append to Sheet", "credentials": { "googleSheetsOAuth2Api": { "id": "VouTxRdZOibVdLDu", "name": "Google Sheets account" } } }, { "parameters": { "documentId": { "__rl": true, "value": "1xuEmKO1Z11KD3tahHUmklmCFAHTbITs7_LeZeLTWdu4", "mode": "list", "cachedResultName": "Input", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1xuEmKO1Z11KD3tahHUmklmCFAHTbITs7_LeZeLTWdu4/edit?usp=drivesdk" }, "sheetName": { "__rl": true, "value": "gid=0", "mode": "list", "cachedResultName": "Sheet1", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1xuEmKO1Z11KD3tahHUmklmCFAHTbITs7_LeZeLTWdu4/edit#gid=0" }, "options": {} }, "type": "n8n-nodes-base.googleSheets", "typeVersion": 4.6, "position": [ 1216, 176 ], "id": "a8c0b4cb-7720-43e0-9f04-35ed7f31274e", "name": "Get row(s) in sheet1", "credentials": { "googleSheetsOAuth2Api": { "id": "VouTxRdZOibVdLDu", "name": "Google Sheets account" } } }, { "parameters": { "promptType": "define", "text": "=Provide the official company information for: {{ $json['Company Name'] }}.\n\nRules:\n- Only return the HEADQUARTERS address of the company.\n- Phone number must be official.\n- Revenue must be real (no guessing).\n- If unknown return null.\n\nRespond only JSON:\n{\n \"name\": \"string or null\",\n \"url\": \"string or null\",\n \"industry\": \"string or null\",\n \"phone\": \"string or null\",\n \"annual_revenue\": \"string or null\",\n \"number_of_employees\": \"string or null\",\n \"address\": \"string or null\",\n \"linkedin\": \"string or null\"\n}", "options": {} }, "type": "@n8n/n8n-nodes-langchain.agent", "typeVersion": 2, "position": [ 1440, 176 ], "id": "89dec765-48a1-4e1e-b290-4b4d6b4ca384", "name": "AI Agent2" }, { "parameters": { "promptType": "define", "text": "=Provide the official company information for: {{ $json['Company Name'] }}.\n\nSTRICT RULES:\n- Only HQ address\n- Only real phone\n- Only verified revenue\n- No guessing\n- Return null if unsure\n\nJSON only:\n{\n \"name\": \"string or null\",\n \"url\": \"string or null\",\n \"industry\": \"string or null\",\n \"phone\": \"string or null\",\n \"annual_revenue\": \"string or null\",\n \"number_of_employees\": \"string or null\",\n \"address\": \"string or null\",\n \"linkedin\": \"string or null\"\n}", "options": {} }, "type": "@n8n/n8n-nodes-langchain.agent", "typeVersion": 2, "position": [ 2016, 300 ], "id": "69dcf1d2-3b76-4a5f-871c-8ec1373b3e69", "name": "AI Agent Key" }, { "parameters": { "options": {} }, "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini", "typeVersion": 1, "position": [ 1512, 400 ], "id": "fa511f63-de23-4cfc-9fcb-7fbb724843a5", "name": "Google Gemini Chat Model2", "credentials": { "googlePalmApi": { "id": "XYWY8qJpCHeJhkEV", "name": "Google Gemini(PaLM) Api account" } } }, { "parameters": { "options": {} }, "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini", "typeVersion": 1, "position": [ 2088, 524 ], "id": "eee51401-1766-4c36-8755-c6fb8b9f98f3", "name": "Google Gemini Chat Model3", "credentials": { "googlePalmApi": { "id": "g5rnEcfmVNtcnjN7", "name": "Google Gemini(PaLM) Api account 2" } } } ], "pinData": {}, "connections": { "Google Gemini Chat Model": { "ai_languageModel": [ [ { "node": "AI Agent", "type": "ai_languageModel", "index": 0 } ] ] }, "On form submission": { "main": [ [ { "node": "AI Agent", "type": "main", "index": 0 } ] ] }, "AI Agent": { "main": [ [ { "node": "Code", "type": "main", "index": 0 } ] ] }, "Code": { "main": [ [ { "node": "Append row in sheet", "type": "main", "index": 0 } ] ] }, "Get row(s) in sheet": { "main": [ [ { "node": "AI Agent1", "type": "main", "index": 0 } ] ] }, "AI Agent1": { "main": [ [ { "node": "If", "type": "main", "index": 0 } ] ] }, "Code1": { "main": [ [ { "node": "Append row in sheet1", "type": "main", "index": 0 } ] ] }, "Gemini Key2": { "ai_languageModel": [ [ { "node": "AI Agent Key2", "type": "ai_languageModel", "index": 0 } ] ] }, "AI Agent Key2": { "main": [ [ { "node": "Code1", "type": "main", "index": 0 } ] ] }, "Google Gemini Chat Model1": { "ai_languageModel": [ [ { "node": "AI Agent1", "type": "ai_languageModel", "index": 0 } ] ] }, "If": { "main": [ [ { "node": "Code1", "type": "main", "index": 0 } ], [ { "node": "AI Agent Key2", "type": "main", "index": 0 } ] ] }, "If (Check AI Fail)": { "main": [ [ { "node": "Parse JSON", "type": "main", "index": 0 } ], [ { "node": "AI Agent Key", "type": "main", "index": 0 } ] ] }, "Parse JSON": { "main": [ [ { "node": "Append to Sheet", "type": "main", "index": 0 } ] ] }, "Get row(s) in sheet1": { "main": [ [ { "node": "AI Agent2", "type": "main", "index": 0 } ] ] }, "AI Agent2": { "main": [ [ { "node": "If (Check AI Fail)", "type": "main", "index": 0 } ] ] }, "AI Agent Key": { "main": [ [ { "node": "Parse JSON", "type": "main", "index": 0 } ] ] }, "Google Gemini Chat Model2": { "ai_languageModel": [ [ { "node": "AI Agent2", "type": "ai_languageModel", "index": 0 } ] ] }, "Google Gemini Chat Model3": { "ai_languageModel": [ [ { "node": "AI Agent Key", "type": "ai_languageModel", "index": 0 } ] ] } }, "active": false, "settings": { "executionOrder": "v1" }, "versionId": "d1edb020-3d87-43c2-9d6d-1e0c40af2d41", "meta": { "templateId": "email_triage_agent_with_gmail", "templateCredsSetupCompleted": true, "instanceId": "3b3d8d494224f1a3eee85c65c1a78ae0c4721b46e8c4a51be8c1b901e28ad8d3" }, "id": "eGdzhcJcD5VpDcez", "tags": [ { "updatedAt": "2025-10-14T16:20:52.231Z", "createdAt": "2025-10-14T16:20:52.231Z", "id": "lRIA9KENnUa3szLH", "name": "AI" } ] }



Location for : Listing Title