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 complia