← All N8N workflows
Data & databasesCodeFilterGoogle SheetsHTTP RequestIf

Adjust frequency to your own needs

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

Workflow preview
TriggerWhen clicking "ExecuteWorkflow"Manual TriggerCodeExtract next startvalueCodeCodeMerge all values fromSERPAPICodeCodeTransform data in theright formatCodeData storeAdd rows in GoogleSheetsGoogle SheetsWeb / APISERPAPI - Scrape GoogleMaps URLHTTP RequestTransformRemove duplicate itemsItem ListsTransformSplit out itemsItem ListsRoutingRemove empty valuesFilterData storeGoogle Sheets - Getsearches to scrapGoogle SheetsTransformExtract keyword andlocation from URLEdit FieldsTriggerRun workflow everyhoursSchedule TriggerData storeUpdate Status toSuccessGoogle SheetsData storeUpdate Status to ErrorGoogle SheetsRoutingContinue IF Loop iscompleteIf

Node categories in this workflow

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

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
Extract next start valueCodeCodeSee node parameters
Merge all values from SERPAPICodeCodeSee node parameters
Transform data in the right formatCodeCodeSee node parameters
Add rows in Google SheetsData storeGoogle SheetsappendOrUpdate
SERPAPI - Scrape Google Maps URLWeb / APIHTTP RequestSee node parameters
Remove duplicate itemsTransformItem ListsremoveDuplicates
Split out itemsTransformItem ListsSee node parameters
Remove empty valuesRoutingFilterSee node parameters
Google Sheets - Get searches to scrapData storeGoogle SheetsSee node parameters
Extract keyword and location from URLTransformEdit FieldsSee node parameters
Run workflow every hoursTriggerSchedule TriggerSee node parameters
Update Status to SuccessData storeGoogle Sheetsupdate
Update Status to ErrorData storeGoogle Sheetsupdate
Continue IF Loop is completeRoutingIfSee 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

  • googleSheetsOAuth2Api
  • serpApi

Workflow notes

Copy my template and connect it to n8n

Copy my template and connect it to n8n

Template link: https://docs.google.com/spreadsheets/d/REPLACE_WITH_DOCUMENT_ID/edit?usp=sharing

Add your SERPAPI API Key

Add your SERPAPI API Key

Start a free trial at serpapi.com and get your API key in "Your account" section

Read Me

Read Me

This workflow allows to scrape Google Maps data in an efficient way using SerpAPI.

You'll get all data from Gmaps at a cheaper cost than Google Maps API.

Add as input, your Google Maps search URL and you'll get a list of places with many data points such as:

  • phone number
  • website
  • rating
  • reviews
  • address

And much more.

Full guide to implement the workflow is here:

https://lempire.notion.site/Scrape-Google-Maps-places-with-n8n-b7f1785c3d474e858b7ee61ad4c21136?pvs=4

Adjust frequency to your own needs

Adjust frequency to your own needs

Purpose and structure

This folder contains the Adjust frequency to your own needs workflow. Its executable nodes use code, filter, googleSheets, httpRequest, if, itemLists, manualTrigger, scheduleTrigger, set. 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

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/Code/0391_Code_Filter_Create_Scheduled.json MIT; preserve source notices.

Canvas section labels

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

  • Adjust frequency to your own needs
  • Click on Execute Workflow to run the workflow manually

More in Data & databases