Log new Gmail messages automatically in Google Sheets

🧑‍💻 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 1. In n8n → Credentials → New → Gmail OAuth2 2. Log in with your Gmail account & approve access 3. Attach this credential to the Get new messages node in the workflow

2️⃣ Connect Google Sheets 1. Copy this [Google Sheet template](https://docs.google.com/spreadsheets/d/1t5VXtbo9g7SvGDPmeZok4HG1K-WI1PS0DNBylzmhVwg/edit?usp=drivesdk) into your own Drive 2. In n8n → Credentials → New → Google Sheets (OAuth2) → log in with your Google account & save 3. 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