Add new incoming emails to a Google Sheets spreadsheet as a new row

This n8n workflow automates the process of capturing and storing incoming email details in a structured spreadsheet format, such as Google Sheets or Excel. Whenever a new email is received, the workflow extracts key details—including the sender’s email, subject, email body, and optional attachments—and logs them as a new row in the spreadsheet.

You can customise this workflow to extract additional details, filter emails based on specific criteria, or send notifications when new entries are added.

Pre-conditions & Requirements

Before setting up this workflow, ensure that:

- You have access to the email provider (e.g., Gmail, Outlook, or IMAP-supported email services). - The Gmail Node must be enabled in n8n. - You must authenticate n8n with Google OAuth2 to access your inbox. - Ensure that the Gmail API is enabled in the Google Cloud Console. - You have an existing Google Sheet where data will be stored. - The Google Sheets API is enabled. - You authenticate n8n with your Google account.

Steps

Step 1: Add the Gmail Trigger Node

- Click on "Add Node" and search for "Gmail". - Select "Gmail Trigger" and click to add it. - Under Authentication, click "Create New" and authenticate with your Google account. (If you have already connected your Google account, simply select it.) - In the Trigger Event field, select "Message Received". - Under Filters, you can specify: - Label/Mailbox: If you want to listen to emails from a specific folder (optional). - From Address: If you only want to receive emails from specific senders (optional). - Click "Execute Node" to test the connection. - Click "Save".