Connect Gmail with Google Sheets
Workflow Description
Advanced automation template connecting Gmail with Google Sheets, capturing incoming emails and automatically logging extracted data into spreadsheets with conditional filtering and custom processing logic for complex workflows.
How it works
- 1.Trigger automation on new incoming emails using Gmail integration
- 2.Apply conditional filters and custom logic to process email data
- 3.Extract and map email fields to Google Sheets columns automatically
- 4.Execute additional workflows or merge data from multiple sources as needed
Use cases
- Automatically log customer inquiries and order confirmations from email into organized spreadsheets
- Create audit trails of important business communications with auto-tagging and categorization
- Build real-time data pipelines from email to business intelligence and CRM systems
Requirements
- Active Gmail account with authorization for email access
- Google Cloud project with enabled Gmail and Google Sheets APIs
Service Value
Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.
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