Extract Gmail Metadata to Google Sheets
Automates fetching new Gmail emails, extracting sender, subject, body, and metadata, then appending to Google Sheets for record-keeping and analysis.
This n8n workflow fetches new emails from Gmail using a trigger node that watches for unread or specific query-matched messages. It then uses a Function node to parse key metadata including sender name and email from headers, subject line, message body or snippet, and adds a timestamp. Finally, it appends each processed email as a new row in a specified Google Sheet with columns for Timestamp, Sender Name, Sender Email, Subject, and Message.
Benefits include effortless email logging for complia
- Platform
- n8n
- Category
- Language Tools
- Price
- $9.99
- Creator
- Matt Buds
- gmail
- google-sheets
- email-extraction
- data-logging
- automation
- metadata
- trigger
- function-node
- record-keeping
- productivity
How to import this workflow into n8n
- 1Purchase or download the workflow to get the n8n workflow JSON file.
- 2In your n8n instance, open Workflows and choose "Import from File" (or paste the JSON with Ctrl+V on the canvas).
- 3Open each node marked with a credential warning and connect your own accounts and API keys.
- 4Run the workflow once manually to verify the data flow, then toggle it to Active.
Related Language Tools workflows
- Discover High-Value Articles on Reddit for AI Insights$19.99
- Generate Platform-Optimized Social Media Content with GPT-4o$19.99
- Claude 3.7 Extended Thinking AI Agent – Unlock Ultimate Intelligence$19.99
- AI-Powered Asana Task Prioritization with GPT-4 and Pinecone Memory$24.99
- Generate SEO Keyword Search Volume Data Using Google API$12.99
- Automated CV Screening with OpenAI Integration$18.4
More from Matt Buds
Need this deployed? We'll set it up for you.
Our automation experts deploy this workflow in your stack, connect your accounts, and verify it works — or build a custom solution from scratch.