Developer & DevOps

Connect Google Sheets with Gmail

32 nodes 2 1 Automatic trigger
Download

Workflow Description

ربط Google Sheets مع Gmail

Service Value

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

Apps Used

Google Sheets Gmail Twitter/X

Details

Trigger Automatic trigger
Nodes 32
Apps 3
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 (32)

/

Update last contacted time

Google Sheets

#1

Set message template

Set

#2

Email sequence

Set

#3

Fill message placeholders

Code

#4

Compose message

Set

#5

Get previous message threads

Gmail

#6

Get thread details

Gmail

#7

Classify threads

Code

#8

Next message due?

Filter

#9

Sticky Note2

Sticky Note

#10

Execute Workflow Trigger

Execute Workflow Trigger

#11

Replying?

If

#12

Send new message

Gmail

#13

Call message send sub-workflow

Execute Workflow

#14

Prepare reply params

Set

#15

Prepare first message params

Set

#16

Sticky Note4

Sticky Note

#17

Call message send sub-workflow1

Execute Workflow

#18

To email?

Filter

#19

Decode messages

Code

#20

Decode placeholder values

Code

#21

Package placeholder values

Code

#22

Settings

Set

#23

Reply to message

Gmail

#24

Get emails

Google Sheets

#25

Sticky Note5

Sticky Note

#26

Sticky Note6

Sticky Note

#27

Sticky Note7

Sticky Note

#28

Every hour

Schedule Trigger

#29

Sticky Note3

Sticky Note

#30

Don't email on weekends

Filter

#31

Sticky Note8

Sticky Note

#32