Extract Gmail Metadata to Google Sheets

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 compliance, sales follow-up, customer support tracking, or data analysis without manual copying. It saves hours of repetitive work, reduces errors, and integrates seamlessly into larger automations like notifications or CRM syncing. Gmail API quotas are respected with notes on limits and backoff strategies.

Use cases: Sales teams tracking leads from inbound emails, support desks archiving tickets, marketers monitoring campaign responses, or personal productivity for inbox zero with external records. Customize by adjusting search criteria, adding fields, or chaining to other workflows.

Setup is straightforward: Import template, configure Gmail and Google Sheets OAuth2 credentials, prepare sheet structure, tweak trigger query, activate, and test with a sample email.