AutomationMart
Home/Browse/Add new incoming emails to a Google Sheets spreadsheet as a new row
n8n

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

n8nn8n2 modulesv1.0
GmailGoogle SheetsOutlook

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

At a glance

Add new incoming emails to a Google Sheets spreadsheet as a new row is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Gmail, Google Sheets, Outlook. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Gmail, Google Sheets, Outlook
Modules
2
Price
Free
Version
v1.0
Add new incoming emails to a Google Sheets spreadsheet as a new row workflow diagram

About this workflow

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. 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? Start with us.

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

Trigger new emails in Gmail and upload files to Google Drive

Automatically upload files to Google Drive when new emails arrive in Gmail, streamlining your file management and email organization.

Free

TikTok post scraper via keywords | Bright Data + Sheets integration

TikTok Post Scraper via Keywords | Bright Data + Sheets Integration 📝 Workflow Description Automatically scrapes TikTok posts based on keyword search using Bright Data API and stores comprehensive data in Google Sheets for analysis and monitoring. --- 🔄 How It Works This workflow operates through a simple, automated process: - Keyword Input: User submits search keywords through a web form - Data Scraping: Bright Data API searches TikTok for posts matching the keywords -

Free

Track LLM token costs per customer using the Langchain code node

Note: This template only works for self-hosted n8n. This n8n template demonstrates how to use the Langchain code node to track token usage and cost for every LLM call. This is useful if your templates handle multiple clients or customers and you need a cheap and easy way to capture how much of your AI credits they are using. How it works In our mock AI service, we're offering a data conversion API to convert Resume PDFs into JSON documents. A form trigger is used to allow for PDF upload and th

Free

Send custom email notifications for new rows added in Google Sheets

Automatically send personalized email notifications whenever a new row is added in Google Sheets using Custom MailHook and Google Sheets integration.

Free

Food menu update notifier

An intelligent food menu update notification system that automatically detects changes in your restaurant's special menu and sends personalized notifications to customers via multiple channels - WhatsApp, Email, and SMS. This workflow ensures your customers are always informed about new dishes, price changes, and menu availability in real-time. What's the Goal? - Automatically monitor special menu updates from Google Sheets - Detect menu changes and generate alert messages using AI - Send mu

Free

Filter rows in Google Sheets and send data via HTTP action

Automatically filter rows in Google Sheets based on specific criteria and send the filtered data via HTTP action for seamless data integration.

Free

AI-powered lead enrichment with Explorium MCP & Telegram

AI-Powered Lead Enrichment with Explorium MCP & Telegram Who it's for Sales reps, agencies, and growth teams who want to turn basic company info into qualified leads with automated research . Perfect for B2B prospecting. What it does This workflow lets you send a company name or domain via Telegram, and instantly returns: ✅ Enriched company profile (industry, size, tech, pain points) ✅ A clean, structured JSON — ready for your CRM or sales tools How it works 💬 Send company info to your Telegram

Free

Find LinkedIn professionals with Google Search and Airtable

Find LinkedIn Professionals with Google Search and Airtable Who is this for? This workflow is perfect for sales professionals, recruiters, business development teams, and marketers who need to build targeted prospect lists from LinkedIn. Whether you're looking for specific job titles, industry professionals, or experts in particular locations, this template automates the tedious process of manual LinkedIn searching. [Follow me for more](

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free