Log New Gmail Messages Automatically in Google Sheets

Description

🧑‍💻 Description
This workflow automatically fetches new Gmail messages since the last run and appends them into a Google Sheet with their ID, snippet, and timestamp.

It’s designed for professionals, small business owners, and operations teams who need a simple way to keep an ongoing log of emails, build lightweight CRMs, or power downstream automations like email tracking, reporting, or follow-up reminders.

⚙️ Setup Instructions for Gmail → Google Sheets Email Log

1️⃣ Connect Gmail
In n8n → Credentials → New → Gmail OAuth2
Log in with your Gmail account & approve access
Attach this credential to the Get new messages node in the workflow

2️⃣ Connect Google Sheets
Copy this Google Sheet template into your own Drive
In n8n → Credentials → New → Google Sheets (OAuth2) → log in with your Google account & save
In the workflow, select your Spreadsheet ID and Worksheet (Sheet1 by default) in the Google Sheets nodes

🧠 How Email Logging Automation Works
Get Current Emails** → Reads the last logged messages from Google Sheets
Get Max Date** → Finds the most recent email timestamp
Combine** → Passes the last timestamp and today’s date together
Get New Messages** → Fetches all new Gmail messages after the last logged date
Add Emails to Sheets** → Appends message ID, snippet, and date to the sheet

🎛️ Customization Guidance
Filter by Sender or Subject** → Modify the Gmail query to only log messages from specific addresses or with certain keywords.
Track Labels** → Add Gmail labels to your sheet to separate categories (e.g., “Leads,” “Support,” “Invoices”).
Auto-Reply** → Extend with an additional Gmail node to send automated responses to new messages.
Send Alerts** → Add a Slack or Email node to ping your team whenever a new email is logged.
Analytics** → Use Google Sheets formulas or connect to BI tools to analyze trends like response times or sender frequency.

📬 Contact
Need advanced customization (e.g., multi-inbox tracking, CRM integration, or automated follow-ups)?

📧 [email protected]
🔗 Robert Breen
🌐 ynteractive.com