AutomationMart
Home/Browse/Extract and save invoice data from Google Drive to Sheets with Dumpling AI
n8n

Extract and save invoice data from Google Drive to Sheets with Dumpling AI

n8nn8n7 modulesv1.0
codeextractFromFilegoogleDrivegoogleDriveTriggergoogleSheetshttpRequestsplitOut

Who is this for? This workflow is perfect for operations teams, accountants, e-commerce businesses, or finance managers who regularly process digital invoices and need to automate data extraction and record-keeping. --- What problem is this workflow solving? Manually reading invoice PDFs, extracting relevant data, and entering it into spreadsheets is time-consuming and error-prone. This workflow automates that process—watching a Google Drive folder, extracting structured invoice data using Dumpl

At a glance

Extract and save invoice data from Google Drive to Sheets with Dumpling AI is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects code, extractFromFile, googleDrive, googleDriveTrigger. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
code, extractFromFile, googleDrive, googleDriveTrigger, googleSheets, httpRequest
Modules
7
Price
Free
Version
v1.0
Extract and save invoice data from Google Drive to Sheets with Dumpling AI workflow diagram

About this workflow

Who is this for? This workflow is perfect for operations teams, accountants, e-commerce businesses, or finance managers who regularly process digital invoices and need to automate data extraction and record-keeping. --- What problem is this workflow solving? Manually reading invoice PDFs, extracting relevant data, and entering it into spreadsheets is time-consuming and error-prone. This workflow automates that process—watching a Google Drive folder, extracting structured invoice data using Dumpling AI, and saving the results into Google Sheets. --- What this workflow does 1. Watches a specific Google Drive folder for new invoices. 2. Downloads the uploaded invoice file. 3. Converts the file into a Base64 format. 4. Sends the file to Dumpling AI’s extract-document endpoint with a detailed parsing prompt. 5. Parses Dumpling AI’s JSON response using a Code node. 6. Splits the items array into individual rows using the Split Out node. 7. Appends each invoice item to a preformatted Google Sheet along with the full header metadata (order number, PO, addresses, etc.). --- Setup 1. Google Drive Setup - Create or select a folder in Google Drive and place the folder ID in the trigger node. - Make sure your n8n Google Drive credentials are authorized for access. 2. Google Sheets - Create a Google Sheet with the following headers: Order number, Document Date, Ponumber, Sold to name, Sold to address, Ship to name, Ship to address, Model, Description, Quantity, Unity price, Total price - Paste the Sheet ID and sheet name (Sheet1) into the Google Sheets node. 3. Dumpling AI - Sign up at Dumpling AI - Go to your account settings and generate your API key. - Paste this key into the HTTP header of the Dumpling AI request node. - The endpoint used is: 4. Prompt (already included) - This prompt extracts: order number, document date, PO number, shipping/billing details, and detailed line items (model, quantity, unit price, total). --- How to customize this workflow to your needs - Adjust the Google Sheet fields to fit your invoice structure. - Modify the Dumpling AI prompt if your invoices have additional or different data points. - Add filtering logic if you want to handle different invoice types differently. - Replace Google Sheets with Airtable or a database if preferred. - Use a different trigger like an email attachment if invoices come via email. ---

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

AI-driven lead classification & routing with HighLevel and Azure GPT-4o-mini

Description: Streamline your lead management process with this AI-driven n8n automation template. The workflow fetches opportunities from HighLevel (GHL), enriches them with contact details, and uses Azure OpenAI GPT-4o-mini to analyze each lead’s intent (e.g., Demo Request, Support Query, or Partnership Inquiry). It then automatically routes the lead to the right internal team via email, ensuring instant follow-up and zero delays in response time. Perfect for sales, support, and partnership

Free

Build your own counseling chatbot on LINE to support mental health conversations

Are you looking to create a counseling chatbot that provides emotional support and mental health guidance through the LINE messaging platform ? This guide will walk you through connecting LINE with powerful AI language models like GPT-4 to build a chatbot that supports users in navigating their emotions, offering 24/7 conversational therapy and accessible mental health resources . By leveraging LINE's webhook integration and Azure OpenAI , this template allows you to design a chatbot that is bot

Free

Collect company social media profiles with Extruct AI to Google Sheets

Who’s it for: Sales teams, marketers, and analysts who need to quickly access all the social media and public profile links for any company. How it works / What it does: When you enter a company into the form, this workflow automatically searches for and collects all available links to the company’s social media accounts, review sites, and public profiles from sources like Crunchbase and Zoominfo. All discovered URLs are added directly to your Google Sheet. How to set up: 1. Create an Extruct

Free

Build an IT support assistant chatbot leveraging existing support portal

This n8n template demonstrates how you can leverage existing support site search to power your Support Chatbots and agents. Building a support chatbot need not be complicated! If building and indexing vector stores or duplicating data isn't necessarily your thing, an alternative implementation of the RAG approach is to leverage existing knowledge-bases such as support portals. In this way, document management and maintenance of your support agent is significantly reduced. Disclaimer: This templa

Free

Build an on-premises AI Kaggle competition assistant with Qdrant RAG and Ollama

LLM/RAG Kaggle Development Assistant An on-premises, domain-specific AI assistant for Kaggle (tested on binary disaster-tweet classification), combining LLM, an n8n workflow engine, and Qdrant-backed Retrieval-Augmented Generation (RAG). Deploy via containerized starter kit. Needs high end GPU support or patience. Initial chat should contain guidelines on what to to produce and the challenge guidelines. --- Features - Coding Assistance • "Real"-time Python code recommendations, debugging help,

Free

Scrape high-engagement LinkedIn posts and auto-post with Gemini images

Who's it for This workflow is ideal for: - Content creators who want to replicate successful LinkedIn strategies - Social media managers monitoring competitor content performance - Marketing teams analyzing trending topics in their industry - Personal brands looking to create data-driven content - Agencies managing multiple LinkedIn accounts What it does This comprehensive workflow automates the entire LinkedIn content lifecycle: it scrapes viral posts from target accounts, analyzes engagement p

Free

Get daily calendar summaries via SMS with Google Calendar, Twilio and Claude AI

This free n8n automation helps anyone—from busy parents to entrepreneurs—get a daily SMS summary of their calendar events. It’s a personal assistant that gives you a heads up of what your day will look like. Great for: starting your day cognizant of the day's events, or for the neurodivergent. Example use case: Parent receives a text summarizing the Family Calendar events at 5AM. Its a reminder of a child's doctor appointment at 1PM and soccer practice at 430PM. The AI then ends the mess

Free

Automated daily AI summaries from WhatsApp groups

Automated Daily AI Summaries from WhatsApp Groups using a Custom AI Agent Transform your WhatsApp group conversations into actionable business intelligence through automated AI analysis and daily reporting. This workflow eliminates manual conversation monitoring by capturing messages in real-time, processing voice notes, and delivering structured insights directly to your team. Overview This workflow provides complete conversation intelligence automation from message capture to insight delivery.

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