Quick overview
Quick overview This workflow collects a business type and location via an n8n form, searches Google Maps results using SearchAPI, parses key business details, and appends the enriched leads to a Google Sheets spreadsheet. How it works Receives a form submission where the user selects a Business Type and Location. Builds a Google Maps search query (for example, “{Business Type} in {Location}”) and generates a unique run ID timestamp. Queries SearchAPI’s Google Maps engine to retrieve matching local business results. Extracts and normalizes lead fields like name, category, address, phone, website, rating, review count, price range, Maps URL, and Place ID, and adds metadata such as run ID and scrape time. Appends the resulting lead rows to a specified Google Sheets worksheet. Setup Add a SearchAPI credential (API key) and ensure the request uses the google_maps resource. Add a Google Sheets OAuth2 credential. Select the target Google Sheets document and sheet tab in the Google Sheets append step. Customize the form’s Business Type and Location dropdown options to match your prospecting needs. An n8n automation workflow template by Snehasish Konger.
Snehasish Konger
web
free
Others in the same category, ranked by how often they are opened.
