Developer & DevOps

Automate Google Sheets

20 nodes 2 1 Automatic trigger
Download

Workflow Description

أتمتة Google Sheets

Service Value

Ready-made workflow template for automation delivery and service execution.

Apps Used

Google Sheets

Details

Trigger Automatic trigger
Nodes 20
Apps 1
Views 2
Downloads 1

How to Use

  1. 1.Click "Download Template"
  2. 2.Open your n8n dashboard
  3. 3.Go to Workflows > Import from File
  4. 4.Select downloaded file and configure credentials

Nodes Used (20)

/

When clicking "Execute Workflow"

Manual Trigger

#1

Extract next start value

Code

#2

Merge all values from SERPAPI

Code

#3

Transform data in the right format

Code

#4

Add rows in Google Sheets

Google Sheets

#5

SERPAPI - Scrape Google Maps URL

HTTP Request

#6

Remove duplicate items

Item Lists

#7

Split out items

Item Lists

#8

Remove empty values

Filter

#9

Google Sheets - Get searches to scrap

Google Sheets

#10

Extract keyword and location from URL

Set

#11

Sticky Note1

Sticky Note

#12

Run workflow every hours

Schedule Trigger

#13

Sticky Note2

Sticky Note

#14

Sticky Note3

Sticky Note

#15

Update Status to Success

Google Sheets

#16

Update Status to Error

Google Sheets

#17

Sticky Note

Sticky Note

#18

Continue IF Loop is complete

If

#19

Sticky Note4

Sticky Note

#20

Similar Templates

Automated workflow

0 nodes

Remote sensor monitoring via and

6 nodes

Connect OpenAI with Discord

8 nodes

Telegram automation

27 nodes

Automated workflow

2 nodes

Create a customer and add it to a slide in

3 nodes