Developer & DevOps

Capture Gmail messages and log them automatically to Google Sheets

46 nodes 295 156 Automatic trigger
Download

Workflow Description

Automates email processing by monitoring Gmail for new messages, extracting key data fields, and automatically inserting them into a Google Sheets spreadsheet. Includes conditional logic, filtering options, and data consolidation from multiple sources.

How it works

  1. 1.Trigger automation when a new email arrives in Gmail
  2. 2.Extract and process email content and key data fields
  3. 3.Write extracted email data to rows in Google Sheets
  4. 4.Apply conditional filters to identify relevant messages
  5. 5.Merge data from multiple sources when necessary
  6. 6.Execute additional workflows for further processing

Use cases

  • Archive inquiry details and contact information from incoming emails automatically
  • Centralize important notifications and alerts in a single tracking spreadsheet
  • Document project-related emails by filtering on keywords and sender information

Requirements

  • Active Gmail account with full API access permissions
  • Google Workspace account or Google Sheets with edit permissions
  • Basic understanding of email data structure and required fields for extraction

Service Value

Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.

Apps Used

Twitter/X Gmail Google Sheets

Details

Trigger Automatic trigger
Nodes 46
Apps 3
Views 295
Downloads 156

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 (46)

/

When clicking ‘Test workflow’

Manual Trigger

#1

Get list of owners

HTTP Request

#2

Get list of clients for owner

HTTP Request

#3

Sticky Note1

Sticky Note

#4

If

If

#5

Edit

Set

#6

Increment Page

Set

#7

Split Out1

Split Out

#8

Merge al the entries

Code

#9

If linkedin url is empty

If

#10

if new post

If

#11

Get list of clients

Execute Workflow

#12

When Executed by Another Workflow

Execute Workflow Trigger

#13

Get last post

Execute Workflow

#14

Gmail

Gmail

#15

Search for user by link

HTTP Request

#16

Do nothing

No Op

#17

Merge profileURL

Code

#18

Set last_post

Set

#19

Set last_position

Set

#20

if new position

If

#21

Set data here

Set

#22

Sticky Note

Sticky Note

#23

Change this for testing

Filter

#24

Create entry with email

Google Sheets

#25

Get rows from document

Google Sheets

#26

Search for user profile by names

HTTP Request

#27

Profile URL not found?

If

#28

Set the profile URL

Set

#29

Set the profile URL1

Set

#30

Update last post

Google Sheets

#31

Updates last position

Google Sheets

#32

Set post_updated

Set

#33

Set position_updated

Set

#34

Generate the email text

Code

#35

Merge on email

Merge

#36

Split Out owners

Split Out

#37

Get current owner

Filter

#38

Sticky Note2

Sticky Note

#39

Sticky Note3

Sticky Note

#40

Sticky Note4

Sticky Note

#41

Sticky Note5

Sticky Note

#42

Sticky Note6

Sticky Note

#43

Sticky Note7

Sticky Note

#44

Sticky Note10

Sticky Note

#45

Sticky Note8

Sticky Note

#46

Similar Templates

Trigger automated workflows from webhooks with conditional routing

18 nodes

Receive Telegram messages and log them to spreadsheets

21 nodes

Receive Events and Send Mattermost Notifications

3 nodes

Sync Notion Content to Webflow with Slack Notifications

29 nodes

Automate Posts to X with Custom Triggers

8 nodes

Launch custom workflows manually through Discourse

4 nodes