Cold Outreach Automation: Scrape Local Leads with Dumpling AI & Call via Vapi
    100%
    Automation
    0(0 reviews)
    866 downloads

    Cold Outreach Automation: Scrape Local Leads with Dumpling AI & Call via Vapi

    NM

    Curated by n8n Markets team

    Last updated: March 8, 2026

    ### Who is this for? This template is for sales teams, agencies, or local service providers who want to quickly generate cold outreach lists and automatically call local businesses with a Vapi AI assistant. It’s perfect for automating cold calls from scraped local listings with no manual dialing or research. --- ### What problem is this workflow solving? Finding leads and initiating outreach calls can be time-consuming. This workflow automates the process: it scrapes business listings from Google Maps using Dumpling AI, extracts phone numbers, filters out incomplete data, formats the numbers, and uses Vapi to make outbound AI-powered calls. Every call is logged in Google Sheets for follow-up and tracking. --- ### What this workflow does 1. Starts manually and pulls search queries (e.g., "plumbers in Austin") from Google Sheets. 2. Sends each query to Dumpling AI’s Google Maps scraping endpoint. 3. Splits the returned business data into individual leads. 4. Extracts key info like business name, website, and phone number. 5. Filters to only keep leads with valid phone numbers. 6. Formats phone numbers for Vapi dialing (adds +1). 7. Calls each business using Vapi AI. 8. Logs each successful call in a Google Sheet. --- ### Setup 1. Google Sheets Setup - Create a sheet with business search queries in the first column (e.g., `best+restaurants+in+Chicago`) - Make sure the tab name is set and authorized in your credentials. - Connect your Google Sheets account in the `Get Search Keywords from Google Sheets` node. 2. Dumpling AI Setup - Go to [dumplingai.com](https://www.dumplingai.com/) - Generate an API Key and connect it as a header token in the `Scrape Google Map Businesses using Dumpling AI` node 3. Vapi Setup - Sign into [Vapi](https://vapi.ai) and create an assistant - Get your `assistantId` and `phoneNumberId` - Insert these into the JSON payload of the `Initiate Vapi AI Call to Business` node - Add your Vapi API key to the credentials section 4. Call Logging - Create another tab in your sheet (e.g., “leads”) with these headers: - `company name` - `phone number` - `website` - This will be used in the `Log Called Business Info to Sheet` node --- ### How to customize this workflow to your needs - Modify the business search terms in your Google Sheet to target specific industries or locations. - Add filters to exclude certain businesses based on ratings, keywords, or location. - Update your Vapi assistant script to match the type of outreach or pitch you’re using. - Add additional integrations (e.g., CRM logging, Slack notifications, follow-up emails). - Change the trigger to run on a schedule or webhook instead of manually. --- ### Nodes and Functions Breakdown - `Start Workflow Manually`: Initiates the automation manually for testing or controlled runs. - `Get Search Keywords from Google Sheets`: Reads search phrases from the spreadsheet. - `Scrape Google Map Businesses using Dumpling AI`: Sends each search query to Dumpling AI and receives matching local business data. - `Split Each Business Result`: Breaks the returned array of businesses into individual records for processing. - `Extract Business Name, Phone and website`: Extracts title, phone, and website from each business record. - `Filter Valid Phone Numbers Only`: Ensures only entries with a phone number move forward. - `Format Phone Number for Calling`: Adds a +1 country code and strips non-numeric characters. - `Initiate Vapi AI Call to Business`: Uses the business name and number to initiate a Vapi AI outbound call. - `Log Called Business Info to Sheet`: Appends business details into a Google Sheet for tracking. --- ### Notes - You must have valid API keys and authorized connections for Dumpling AI, Google Sheets, and Vapi. - Make sure to handle API rate limits if you're running the workflow on large datasets. - This workflow is optimized for US-based leads (+1 country code); adjust the formatting node if calling internationally.

    What's Included

    • Complete n8n workflow template with 0 nodes. Ready to import and customize.

    Requirements

    n8n instance (self-hosted or cloud). credentials.

    How to Use

    1. Download the workflow JSON 2. Import into your n8n instance 3. Configure credentials for 4. Activate and enjoy automation

    How to import this template into n8n

    1. Download the workflow JSON file from this page.
    2. In n8n, open Workflows, create a new workflow and choose Import from File.
    3. Open each node that shows a warning and connect your own credentials.
    4. Run the workflow once manually to check the output before you activate it.
    Included in Pro
    • Importable n8n workflow JSON file
    • Download with Builder Pro or Agency Unlimited
    • Built for n8n v1.0++
    • Setup time: 5-15 min

    Included in Builder Pro — $19/mo, 4,177 premium workflows

    Before you activate

    Templates are reviewed before they are listed. Test with your own credentials and data before running it in production.

    Updated Mar 2026
    v1.0
    SSL
    Secure
    GDPR

    100% Secure Checkout

    Refund requests within 7 days of a new subscription

    Reviews

    0

    No reviews yet

    See all 0 reviews ↓
    —

    0 reviews

    5★
    0
    4★
    0
    3★
    0
    2★
    0
    1★
    0

    No reviews yet.

    Questions & Answers

    0

    Log in to ask a question.

    No questions yet. Be the first to ask!

    People Also Bought