AutomationMart
Home/Browse/AI auto-save Gmail receipts to Google Sheets + Google Drive
n8n

AI auto-save Gmail receipts to Google Sheets + Google Drive

n8nn8n12 modulesv1.0
GmailGoogle SheetsOpenAIGoogle Drive

Who is this for? This workflow is ideal for: - For freelancers, business owners, and finance teams who receive receipts via Gmail - Automatically logs expenses for tax, - bookkeeping and year-end audits What problem is this workflow solving? When tax season hits, missing receipts create panic. This workflow keeps everything in one place. It uses AI to extract details from Gmail attachments, logs them in a Google Sheet, and stores the PDFs in Google Drive. No digging. No copying. Just everythin

At a glance

AI auto-save Gmail receipts to Google Sheets + Google Drive is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Gmail, Google Sheets, OpenAI, Google Drive. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Gmail, Google Sheets, OpenAI, Google Drive
Modules
12
Price
Free
Version
v1.0
AI auto-save Gmail receipts to Google Sheets + Google Drive workflow diagram

About this workflow

Who is this for? This workflow is ideal for: - For freelancers, business owners, and finance teams who receive receipts via Gmail - Automatically logs expenses for tax, - bookkeeping and year-end audits What problem is this workflow solving? When tax season hits, missing receipts create panic. This workflow keeps everything in one place. It uses AI to extract details from Gmail attachments, logs them in a Google Sheet, and stores the PDFs in Google Drive. No digging. No copying. Just everything where it should be. How it works? 1. Apply the label receipt to any incoming Gmail email. Do not mark it as read. 2. On a schedule (e.g. daily at 8:00 AM), the workflow triggers. 3. It searches for unread emails with the label receipt. 4. For each matching email, it downloads the attached receipt file. 5. It extracts text content from the receipt file. 6. It uploads the original receipt file to a specified folder in Google Drive. 7. It merges the extracted text with email metadata. 8. It sends this combined data to OpenAI. OpenAI extracts structured fields: - date - merchant - category - description - subtotal - tax - total 9. The extracted data is appended as a new row in the specific Google Sheet. 10. Finally, the email is marked as read to prevent it from being processed again. How to set up? 1. Connect these services in your n8n credentials: - Gmail (OAuth2) - Google Drive - Google Sheets - OpenAI 2. Configure the Google Drive upload: - In the “Upload File” node, select the target folder where you want receipt PDFs stored. 3. Set your execution schedule: - Open the “Schedule Trigger” node and choose when it should run (default is once daily at 8:00 AM). 4. Choose your Google Sheet and tab: - In the “Append to Google Sheet” node, select your document and tab - Ensure the sheet contains these columns: Date, Merchant, Category, Description, Subtotal, Tax, Total. How to customize this workflow to your needs? - Change the Gmail label or search filter to match your needs. - Modify the OpenAI schema to extract additional fields like currency, project, or notes.

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

Create OpenAI-compatible API using GitHub models for free AI access

This n8n template shows you how to connect Github's Free Models to your existing n8n AI workflows. Whilst it is possible to use HTTP nodes to access Github Models, The aim of this template is to use it with existing n8n LLM nodes - saves the trouble of refactoring! Please note, Github states their model APIs are not intended for production usage! If you need higher rate limits, you'll need to use a paid service. How it works The approach builds a custom OpenAI compatible API around the Github M

Free

Generate content with ChatGPT from Google Sheets range values and update the row

Automatically generate content using ChatGPT from Google Sheets range values and update the rows. Streamline data processing and content creation with this powerful integration.

Free

Create workflow inventory dashboard with n8n API and Google Sheets

This workflow provides a powerful way to automatically document and maintain an inventory of all your n8n workflows in a Google Sheet. By running on a schedule or manually, it fetches details about every workflow on your instance, processes the key information, and then populates a spreadsheet. This creates a centralized, up-to-date dashboard for auditing, monitoring, and understanding your automation landscape. Who is this for? This workflow is ideal for n8n administrators, developers, and team

Free

Generate LinkedIn posts and AI images from web pages with Airtop and GPT-4

Use Case Turn any web page into a compelling LinkedIn post — complete with an AI-generated image. This automation is ideal for sharing content like blog posts, case studies, or product updates in a polished and engaging format. What This Automation Does Given a page URL and optional user instructions, this automation: - Scrapes the content of the webpage - Uses AI to write a clear, educational, and LinkedIn-optimized post - Generates a brand-aligned visual that matches the content - Send

Free

Create ClickUp tasks from new emails in Gmail

Automatically create new tasks in ClickUp every time you receive a new Gmail email.

Free

Create & approve POV videos with AI, ElevenLabs & multi-posting (TikTok/IG/YT)

POV Video Creator: Automating TikTok-Style Instagram Video Automation, Approval, and Multi-Platform Posting Using AI, ElevenLabs, Google Sheets, and Social Media APIs Description What Problem Does This Solve? 🎥 This workflow automates the creation, rendering, approval, and posting of TikTok-style POV (Point of View) videos to Instagram, with cross-posting to Facebook and YouTube. It eliminates manual video production, approval delays, and inconsistent posting schedules. It ensures high-quality c

Free

Repurpose RSS blog posts into social content with OpenAI, Sheets, Gmail and Slack

Quick Overview This workflow runs daily, pulls the latest post from an RSS feed, and uses OpenAI to repurpose it into an SEO blog rewrite, a LinkedIn post, and an X/Twitter thread, then logs the drafts to Google Sheets, creates a Gmail draft, and posts a preview to Slack. How it works 1. Runs every 24 hours on a schedule. 2. Loads your RSS feed URL, audience, and brand voice settings and fetches the latest items from the RSS feed. 3. Keeps only the newest feed item to avoid processing multiple p

Free

Convert HTML to PDF and return via webhook using CustomJS API

n8n Workflow: HTML to PDF Generator This n8n workflow converts HTML content into a styled PDF and returns it as a response via a webhook. The workflow receives HTML input, processes it using CustomJS's PDF toolkit, and sends back the resulting PDF to the original webhook requester. @custom-js/n8n-nodes-pdf-toolkit Features: - Webhook Trigger: Accepts incoming requests with HTML content. - HTML to PDF Conversion: Uses CustomJS to transform HTML into a PDF. - Response: Sends the generated PDF back

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