n8n Gmail Trigger: Log Labeled Emails to Google Sheets

Log Gmail emails with the Email-Logger label into Google Sheets—automatically

This n8n workflow polls your Gmail for new messages tagged with label:Email-Logger, extracts key email details, and continuously logs them into a Google Sheets tab—deduplicated by Gmail message ID to keep your sheet clean.

What this workflow does

• Checks Gmail every minute for up to 20 new messages matching the search query label:Email-Logger.
• Extracts core fields from each email, including:
  • Gmail message ID and thread ID
  • Received time
  • Sender and Reply-To addresses
  • Subject
  • A short text preview
• Appends or updates rows in Google Sheets using message_id as the unique key, so duplicates are avoided.
• Writes values as raw text into the Emails sheet.

Use cases

• Track inbound communication: label important threads and maintain a structured log in Google Sheets for reporting or follow-ups.
• Operational auditing: capture sender, subject, and timestamps for emails that meet your labeling rules.
• Automation testing and monitoring: verify that specific Gmail messages trigger downstream processes while still keeping a human-readable record.

Technical details

• n8n Gmail Trigger (polling/lookup behavior) to find messages with label:Email-Logger
• Code node to normalize key fields (message/thread IDs, timestamps, addresses, subject, preview)
• Google Sheets integration to write into the Emails tab

Setup

• Connect your Gmail credentials and create/apply the Email-Logger label (manually or via a Gmail filter).
• Connect Google Sheets, set the spreadsheet ID, and ensure there is a tab named Emails with columns including message_id.
• Activate the workflow to start logging labeled emails continuously.