🧑💻 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)?