← All N8N workflows
Data & databasesCodeExecute Workflow TriggerFilterGoogle SheetsHTTP Request

Generate Leads with Google Maps - AlexK1919

Configured with Execute Workflow Trigger, Filter, Google Sheets, HTTP Request, and additional nodes. Review the connections and setup before adapting this template.

Workflow preview
TriggerWhen clicking "ExecuteWorkflow"Manual TriggerTriggerRun workflow everyhoursSchedule TriggerTriggerExecute WorkflowTriggerExecute Workflow TriggerRoutingCheck Max Retries1IfRoutingStop and Error1Stop And ErrorWeb / APIGMaps APIHTTP RequestData storeUpdate Status toSuccessGoogle SheetsData storeAdd rows in GoogleSheetsGoogle SheetsTransformSet Row NumberEdit FieldsTransformSet ZipEdit FieldsTransformSet Place IDEdit FieldsCodeExponential BackoffCodeTransformRemove DuplicatesRemove DuplicatesWaitWaitWaitRoutingCheck Max RetriesIfRoutingStop and ErrorStop And ErrorCodeExponential Backoff1CodeWaitWait1WaitTransformSettingsEdit FieldsData storeGS - Get SubcategoryGoogle SheetsTransformSubcategoryEdit FieldsData storeGS - Get Zip CodesGoogle SheetsCodePlace ArrayCodeRoutingLoop ZipsLoop Over ItemsRoutingLoop SubcatsLoop Over ItemsData storeGS - Get StatusGoogle SheetsRoutingCheck Max Retries2IfRoutingStop and Error2Stop And ErrorCodeExponential Backoff2CodeWaitWait2WaitTransformLimitLimitTransformZipsEdit FieldsRoutingFilter ZipsFilterRoutingFilter SubcategoriesFilterRoutingIf EmptyIfTransformSplit OutSplit Out

Node categories in this workflow

  • Trigger
  • Routing
  • Web / API
  • Data store
  • Transform
  • Code
  • Wait

Icons describe general node roles, inferred from node types. Inspect the parameters for the configured action.

Drag to pan; use + and − to zoom. Reconstructed from the exported node positions; nothing runs here. Dashed lines represent non-main connections. Full node names and notes appear below.

How it works

The exported workflow contains the following configured nodes. Their connections are shown above; inspect the JSON for the complete logic, expressions, and external actions.

Workflow node names, types, and operations
NodeCategoryTypeOperation
When clicking "Execute Workflow"TriggerManual TriggerSee node parameters
Run workflow every hoursTriggerSchedule TriggerSee node parameters
Execute Workflow TriggerTriggerExecute Workflow TriggerSee node parameters
Check Max Retries1RoutingIfSee node parameters
Stop and Error1RoutingStop And ErrorSee node parameters
GMaps APIWeb / APIHTTP RequestPOST
Update Status to SuccessData storeGoogle Sheetsupdate
Add rows in Google SheetsData storeGoogle SheetsappendOrUpdate
Set Row NumberTransformEdit FieldsSee node parameters
Set ZipTransformEdit FieldsSee node parameters
Set Place IDTransformEdit FieldsSee node parameters
Exponential BackoffCodeCodeSee node parameters
Remove DuplicatesTransformRemove DuplicatesSee node parameters
WaitWaitWaitSee node parameters
Check Max RetriesRoutingIfSee node parameters
Stop and ErrorRoutingStop And ErrorSee node parameters
Exponential Backoff1CodeCodeSee node parameters
Wait1WaitWaitSee node parameters
SettingsTransformEdit FieldsSee node parameters
GS - Get SubcategoryData storeGoogle SheetsSee node parameters
SubcategoryTransformEdit FieldsSee node parameters
GS - Get Zip CodesData storeGoogle SheetsSee node parameters
Place ArrayCodeCodeSee node parameters
Loop ZipsRoutingLoop Over ItemsSee node parameters
Loop SubcatsRoutingLoop Over ItemsSee node parameters
GS - Get StatusData storeGoogle SheetsSee node parameters
Check Max Retries2RoutingIfSee node parameters
Stop and Error2RoutingStop And ErrorSee node parameters
Exponential Backoff2CodeCodeSee node parameters
Wait2WaitWaitSee node parameters
LimitTransformLimitSee node parameters
ZipsTransformEdit FieldsSee node parameters
Filter ZipsRoutingFilterSee node parameters
Filter SubcategoriesRoutingFilterSee node parameters
If EmptyRoutingIfSee node parameters
Split OutTransformSplit OutSee node parameters

Setup

  1. Download the JSON and import it into an isolated n8n instance. Leave the workflow inactive.
  2. Connect your own credentials through n8n’s credential store. Replace REPLACE_WITH_* values with your resource identifiers.
  3. Inspect API destinations, Code nodes, database queries, file paths, and outbound actions.
  4. Run with synthetic data and harmless destinations. Enable triggers only after checking the actual outputs.

Requirements

An n8n instance with the listed node types and compatible versions. Service-connected workflows may require accounts, credentials, or paid APIs.

Credential types declared in the source

  • googleOAuth2Api
  • googleSheetsOAuth2Api

Workflow notes

AlexK1919

AlexK1919

I’m Alex Kim, an AI-Native Workflow Automation Architect Building Solutions to Optimize your Personal and Professional Life.

About Me

https://beacons.ai/alexk1919

Products Used

Google Maps API via Google Cloud Account

Sticky Note15

In the Google Sheets document, set the subcategories you'd like to search for

Set the URL of your Google Sheets document

Set the Zip Code sheet name

Generate Leads with Google Maps - AlexK1919

Generate Leads with Google Maps - AlexK1919

Purpose and structure

This folder contains the Generate Leads with Google Maps - AlexK1919 workflow. Its executable nodes use code, executeWorkflowTrigger, filter, googleSheets, httpRequest, if, limit, manualTrigger, removeDuplicates, scheduleTrigger, set, splitInBatches, splitOut, stopAndError, wait. The table and connection map below are derived from the JSON, not an inferred guarantee of behavior.

Setup

Import inactive. Configure your own credentials and replace REPLACE_WITH_* values. Review external destinations and Code nodes before running.

Entry points

When clicking "Execute Workflow", Run workflow every hours, Execute Workflow Trigger

Verification

Sanitized source candidate; not runtime-tested. This overview is generated from node metadata. Read the folder README for the connection map, credential types, and license.

Attribution

https://github.com/Zie619/n8n-workflows/blob/94007c1445d9258a7da116646b79473e7c7c3282/workflows/Stopanderror/1823_Stopanderror_Wait_Create_Webhook.json MIT; preserve source notices.

Canvas section labels

These name areas of the original canvas; they do not include explanatory instructions.

  • Settings
  • Triggers
  • Google Maps API
  • Data Prep

More in Data & databases