{"product_id":"n8n-workflow-auto-transport-lead-scraper-us-with-serpapi","title":"n8n Workflow: Auto Transport Lead Scraper (US) with SerpAPI","description":"\u003ch3\u003eAuto Transport Lead Scraper (US) for n8n — SerpAPI + Google Sheets + AI Outreach\u003c\/h3\u003e\n\u003cp\u003eTurn your “auto transport” lead sourcing into a daily automated pipeline. This n8n workflow pulls US business leads by state and keyword from Google Maps via \u003cstrong\u003eSerpAPI\u003c\/strong\u003e, enriches them with a website contact email, generates an outreach message with \u003cstrong\u003eOpenAI\u003c\/strong\u003e, and appends everything to your \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e in one go.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily at 7:00 AM\u003c\/strong\u003e using a schedule trigger.\u003c\/li\u003e\n  \u003cli\u003eReads the \u003cstrong\u003e“States”\u003c\/strong\u003e tab from Google Sheets and keeps only rows marked \u003cstrong\u003eActive\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eFor each active state, expands your configured \u003cstrong\u003ekeywords\u003c\/strong\u003e into queries formatted like \u003cstrong\u003e{keyword} in {state}\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eCalls \u003cstrong\u003eSerpAPI (Google Maps engine)\u003c\/strong\u003e for each query, logs any SerpAPI errors to an \u003cstrong\u003e“Errors”\u003c\/strong\u003e tab, and splits returned local results into individual lead items.\u003c\/li\u003e\n  \u003cli\u003eNormalizes each lead (name, phone, website, address, state, keyword), filters out incomplete entries, and removes duplicates using a \u003cstrong\u003ename+phone\u003c\/strong\u003e dedupe key.\u003c\/li\u003e\n  \u003cli\u003eIf a lead has a website, fetches the \u003cstrong\u003e\/contact\u003c\/strong\u003e page and extracts the \u003cstrong\u003efirst valid email\u003c\/strong\u003e from the page HTML.\u003c\/li\u003e\n  \u003cli\u003eUses \u003cstrong\u003eOpenAI\u003c\/strong\u003e to generate a concise \u003cstrong\u003eB2B outreach email\u003c\/strong\u003e per lead, then appends lead details, the extracted contact email, and the AI email to the \u003cstrong\u003e“Leads”\u003c\/strong\u003e tab.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eDaily lead generation for \u003cstrong\u003eauto transport\u003c\/strong\u003e sales or partnerships using n8n automation.\u003c\/li\u003e\n  \u003cli\u003eBuilding a continuously updated outreach list in Google Sheets with enrichment and deduplication.\u003c\/li\u003e\n  \u003cli\u003eOps-friendly monitoring via an \u003cstrong\u003eErrors\u003c\/strong\u003e sheet whenever SerpAPI returns issues.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Google Sheets, SerpAPI (Google Maps engine), OpenAI.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow components (nodes):\u003c\/strong\u003e set, code, wait, filter, split out, sticky note.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup required:\u003c\/strong\u003e Google Sheets OAuth credentials, spreadsheet IDs for \u003cem\u003eStates\/Leads\/Errors\u003c\/em\u003e, a SerpAPI API key, and OpenAI credentials.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45862250774707,"sku":"N8N-18311","price":16.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/7pX5Lypk3nyKGNwI6Egfe_rj5wE1Gd.png?v=1786957937","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-auto-transport-lead-scraper-us-with-serpapi","provider":"N8N Commerce","version":"1.0","type":"link"}