Library / Finance, Invoices & Accounting
Finance, Invoices & Accounting
Extract expense receipts from Gmail with Gemini and log them to Google Sheets
Reads receipts emailed through Gmail with an AI model, logs the extracted amounts to Google Sheets, alerts Finance on Slack above the limit, and emails the employee a confirmation.
What it does
# AI Receipt & Expense Tracker This workflow automatically processes employee expense receipts received through Gmail, uses AI to read and extract receipt details, validates the expense amount, stores the expense in Google Sheets, alerts Finance through Slack when an expense exceeds the approved limit, and sends a confirmation email to the employee. ## Setup steps 1. Connect a Gmail account and enable receipt attachments. 2. Create a Google Sheet with columns for expense details. 3. Connect an AI model that can read receipt images/PDFs. 4. Set the company expense limit, such as ₹5,000 you can set as you wish. 5. Connect Slack and select the Finance channel. Configure the employee confirmation email. 6. Add a monthly Schedule Trigger for the expense report. 7. Connect the Finance email address for the monthly summary. 8. Test the workflow with a sample receipt before activating it.
The steps
- Gmail Trigger
- Analyze an image
- Code in JavaScript
- Code in JavaScript1
- Append or update row in sheet
- If
- Send a message
- Send a message1
- Send a message2
- Schedule Trigger
- Get row(s) in sheet
- Code in JavaScript2
- Send a message3
Similar automations
Finance, Invoices & AccountingExtract expense receipts from IMAP email with Mindee into Google Sheets7 stepsFinance, Invoices & AccountingExtract Expenses from Emailed Receipts into Google Sheets6 stepsFinance, Invoices & AccountingSave Gmail Receipts to Drive and Sheets with OpenAI12 stepsFinance, Invoices & AccountingPersonal Expense Tracker API with Google Sheets9 steps