Extract Spend Details
detail.loadingPreview
Extracts spend details from emails and stores them in a Google Sheet.
🚀Ready to Deploy This Workflow?
About This Workflow
Overview
This workflow is designed to automatically extract detailed spend information from your emails. It first identifies and retrieves relevant emails using Gmail triggers, then extracts specific data from attached invoice and payment PDFs. The extracted information is then processed by an HTML extraction node to find spend details, split out individual spend items, and finally structured using a Google Gemini model. The processed data, including date, service, details, amount, category, currency, and card used, is then sent to a Google Sheet for easy tracking and analysis.
Key Features
- Automatically fetches emails containing invoice and payment information.
- Extracts data from PDF attachments.
- Parses HTML content to identify spend details.
- Splits out individual spend entries for detailed analysis.
- Leverages Google Gemini for structured data parsing and categorization.
- Logs processed spend data into a Google Sheet.
How To Use
- Configure Gmail Triggers: Set up the 'Get invoice' and 'Get payment' nodes with your desired Gmail filters to trigger the workflow when specific emails arrive.
- Provide PDF Password: If your PDF attachments are password-protected, update the
YOUR_PASSWORD_HEREplaceholder in the 'Extract invoice' and 'Extract payment' nodes. - Define HTML Selectors: In the 'HTML' node, customize the
cssSelectorvalue to accurately target the spend details within your email's HTML structure. The default is.spend-table, which might need adjustment based on your email format. - Set up Google Gemini: Ensure your Google Gemini API credentials are correctly configured in the 'Google Gemini Chat Model' node.
- Define Output Schema: Review and adjust the
inputSchemain the 'Structured Output Parser' node to precisely match the expected structure and types of your spend data. Ensure theenumvalues forcategoryandcurrencyare appropriate. - Configure Google Sheets: Set up the 'Send' node with your Google Sheet credentials and specify the correct sheet and columns for data logging. Map the output fields from the parser to your sheet columns.
Apps Used
Workflow JSON
{
"id": "83abb356-aa07-4284-99ab-93e827c70c5b",
"name": "Extract Spend Details",
"nodes": 0,
"category": "Finance Automation",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 83abb356-aa07...
About the Author
Crypto_Watcher
Web3 Developer
Automated trading bots and blockchain monitoring workflows.
Statistics
Verification Info
Related Integrations
- Google Sheets + Schedule Trigger(394 workflows)
- Google Sheets + Split Out(277 workflows)
- Gmail + Schedule Trigger(270 workflows)
- Google Sheets + Slack(268 workflows)
- Gmail + Google Sheets(245 workflows)
- Google Drive + Google Sheets(203 workflows)
- Form Trigger + Google Sheets(163 workflows)
- Google Drive + Google Drive Trigger(135 workflows)
- Google Drive + Split Out(134 workflows)
- Gmail + Split Out(132 workflows)
Related Workflows
Discover more workflows you might like
Convert Any Webpage to PDF and Save Locally
This n8n workflow provides a simple way to convert any public webpage URL into a PDF document. Once converted, the PDF file is automatically saved to your local disk, making it easy to archive or share web content offline.
Automate DOCX to PDF Conversion and Save Locally
This workflow automates the process of converting a Microsoft Word DOCX file to a PDF document. It downloads a source DOCX file, uses ConvertAPI to perform the conversion, and then saves the resulting PDF file directly to your local disk.
Automated Backlink Outreach & Lead Generation
Streamline your SEO efforts with this powerful workflow that automates the discovery of backlink opportunities. It scrapes target websites for contact information, stores leads in Google Sheets, and sends personalized outreach emails, all without manual intervention.
Automate Instagram Reel Analysis with Gemini and Apify
Unlock deeper insights into your Instagram Reels by automating analysis. This workflow leverages Apify to fetch reel data and Gemini AI to dissect key elements like background, pose, text, and context, enabling better content replication.
Telegram Profanity & Toxicity Filter
This n8n workflow automatically monitors incoming Telegram messages for profanity and toxic language. It leverages Google's Perspective API to analyze message content, and if a message is deemed inappropriate, the workflow sends an automated warning response back to the sender.
Automate Competitor Tracking with Crunchbase & ClickUp
Streamline competitor analysis by automatically fetching data from Crunchbase and creating review tasks in ClickUp. Stay informed about market changes without manual effort.