Extract Gmail metadata to Google Sheets

Extract Gmail Metadata to Google Sheets

This n8n template shows how to fetch new emails from a Gmail account, extract key metadata (sender name, email, subject, and message body), and append each email as a new row in a Google Sheet for record-keeping or follow-up workflows.

Good to Know

Gmail API Quotas: Gmail’s API has usage limits—make sure your application stays under 2500 read requests per day or implement exponential backoff on rate limit errors.

OAuth Credentials: You’ll need to configure OAuth2 credentials in n8n to authenticate with Gmail.

Sheet Structure: Prepare your Google Sheet with columns: Timestamp, Sender Name, Sender Email, Subject, Message.

How It Works

Gmail Trigger: Watches for new emails matching your search criteria (e.g., is:unread).

Extract Metadata: A Function node reads the incoming payload and pulls:

Name and Email from headers or body text

Subject from common subject fields

Message from body, text, or snippet

Timestamp from current system time

Append to Sheet: The Google Sheets node appends each processed email as a row in your target spreadsheet.

How to Use

Import the Template: Click "Use Template" in your n8n instance.

Configure Credentials:

Gmail OAuth2: Set up your Gmail account credentials in n8n.

Google Sheets: Authorize with your Google account and select the spreadsheet.

Adjust Search Criteria: Modify the Gmail Trigger to filter specific labels or queries.

Activate and Test: Enable the workflow and send a test email.

Verify Sheet: Check your Google Sheet for new rows with the extracted email data.

Requirements

n8n@latest

Gmail OAuth2 Credentials

Google Sheets API enabled in your Google Cloud project

Customizing This Workflow

Additional Fields: Extend the Function node to capture attachments, threads, or labels.

Notification Flow: Add Slack or email nodes to notify your team of important messages.

Data Enrichment: Integrate with NLP or sentiment analysis APIs to annotate messages.