Add new incoming emails to a Google Sheets spreadsheet as a new
This n8n workflow automates the process of capturing and storing incoming email details in a structured spreadsheet format, such as Google Sheets or Excel. W...
🔌 Nodes & Integrations Used (2)
📖 Implementation & Setup Guide
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".
**What This Does:** This node listens for new incoming emails in your Gmail inbox. ## Step 2: Store Email Data in Google Sheets
- Click on "Add Node" and search for "Google Sheets" (or Microsoft Excel, if applicable)
- Under Authentication, connect your Google account
- Select the target Spreadsheet and Sheet Name where the data will be stored
- Set the Operation to "Append Row"
- Map the extracted email data to the correct columns.
- Click "Execute Node" to test and verify data storage
- Click "Save"
**What This Does:** This node automatically adds a new row for each incoming email, ensuring a structured and searchable email log. ## Final Step Attach both node and execute the workflow.
Who’s behind this?
WeblineIndia’s [AI development team](https://www.weblineindia.com/ai-development.html).
We've delivered 3500+ software projects across 25+ countries since 1999. From no-code automations to complex AI systems — our AI team builds tools that drive results.
Looking to [hire AI developers](https://www.weblineindia.com/hire-ai-developers.html)? Start with us.
⚡ How to import this workflow into n8n:
- Click the Direct Download JSON button above to save
Add_new_incoming_emails_to_a_Google_Sheets_spreadsheet_as_a_new.json. - Log in to your n8n Cloud or self-hosted n8n instance.
- In your workflow canvas, click the menu in top-right and select Import from File (or paste the JSON directly).
- Configure your credentials (e.g. API keys, database URLs) in the corresponding node settings.
- Click Execute Workflow to test and switch to Active!
Related Email & Outreach Workflows
View All in Email & Outreach →Abandoned cart recovery for Shopify via Gmail Google Sheets T
Who is this for? This template is ideal for solo store owners, eCommerce marketers, automation beginners, or anyone using Shopify and Gmail who wants to reco...
Add new leads in Lemlist from Airtable
This workflow allows you to add new leads in Lemlist from Airtable. !workflow-screenshot Airtable node: This node lists all the emails that are stored in you...
Add Subscriber and Send Email Campaign
Production-ready n8n automation template for Add Subscriber and Send Email Campaign built by AhiXLight. Seamlessly connects Sendy with 3 configured nodes.
Add new contacts from HubSpot to the email list in Mailchimp
This workflow adds new HubSpot contacts to the Mailchimp email list. Prerequisites - HubSpot account and HubSpot credentials - Mailchimp account and Mailchim...