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. An n8n automation workflow template by Mohammed Abid.
Mohammed Abid
web
free
Others in the same category, ranked by how often they are opened.
