Connect Gmail with Google Sheets
Workflow Description
ربط Gmail مع Google Sheets
Service Value
Ready-made workflow template for automation delivery and service execution.
Apps Used
Details
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (46)
When clicking ‘Test workflow’
Manual Trigger
Get list of owners
HTTP Request
Get list of clients for owner
HTTP Request
Sticky Note1
Sticky Note
If
If
Edit
Set
Increment Page
Set
Split Out1
Split Out
Merge al the entries
Code
If linkedin url is empty
If
if new post
If
Get list of clients
Execute Workflow
When Executed by Another Workflow
Execute Workflow Trigger
Get last post
Execute Workflow
Gmail
Gmail
Search for user by link
HTTP Request
Do nothing
No Op
Merge profileURL
Code
Set last_post
Set
Set last_position
Set
if new position
If
Set data here
Set
Sticky Note
Sticky Note
Change this for testing
Filter
Create entry with email
Google Sheets
Get rows from document
Google Sheets
Search for user profile by names
HTTP Request
Profile URL not found?
If
Set the profile URL
Set
Set the profile URL1
Set
Update last post
Google Sheets
Updates last position
Google Sheets
Set post_updated
Set
Set position_updated
Set
Generate the email text
Code
Merge on email
Merge
Split Out owners
Split Out
Get current owner
Filter
Sticky Note2
Sticky Note
Sticky Note3
Sticky Note
Sticky Note4
Sticky Note
Sticky Note5
Sticky Note
Sticky Note6
Sticky Note
Sticky Note7
Sticky Note
Sticky Note10
Sticky Note
Sticky Note8
Sticky Note