This workflow follows the Form Trigger → Googlegemini recipe pattern — see all workflows that pair these two integrations.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"name": "Smart Tax Accountant: Auto-Categorize Receipts for Tax Return",
"nodes": [
{
"parameters": {
"content": "## \ud83e\uddfe Smart Tax Accountant\n\nAutomate your tax return prep. Upload a receipt image, and **Gemini** will extract the details and categorize the expense (e.g., \"Supplies\", \"Travel\") automatically.\n\n## How it works\n1. **Input:** Upload receipt via **n8n Form** (or use Test Mode).\n - *Includes a **Test Mode** to simulate a \"Coffee at Starbucks\" receipt.*\n2. **Analyze:** Gemini (Vision) reads the image to extract Date, Amount, and Vendor.\n3. **Categorize:** Gemini determines the tax category (Account Title) based on the content.\n4. **Log:** Saves clean data to **Google Sheets** for your tax filing.\n\n## Setup steps\n1. **Connect:** Google Gemini, Google Sheets.\n2. **Config:** Open **\"Config\"** to set Sheet ID.\n3. **Test:** Set `TEST_MODE` to `true` to verify the logic instantly.",
"height": 380,
"width": 500,
"color": 3
},
"id": "01030e59-6d53-4067-acfb-1d93710c06a6",
"name": "Sticky Note - Main",
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
-1248,
48
]
},
{
"parameters": {
"content": "## \u2699\ufe0f Configuration\nSet Sheet ID & Mode.",
"height": 140,
"color": 6
},
"id": "1c7f9e94-137c-4875-bd73-281b5d0b595b",
"name": "Sticky Note - Config",
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
-496,
32
]
},
{
"parameters": {
"content": "## \ud83d\udcf8 Receipt Input\nForm Upload or Mock.",
"height": 340,
"width": 760,
"color": 6
},
"id": "04d5607d-fdd3-4187-a5c6-72420f527de2",
"name": "Sticky Note - Input",
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
-208,
32
]
},
{
"parameters": {
"content": "## \ud83e\udde0 AI Accountant\nExtracts & Categorizes.",
"height": 140,
"width": 440,
"color": 6
},
"id": "645d25ae-13bd-420e-8b23-b230027b6756",
"name": "Sticky Note - AI",
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
624,
32
]
},
{
"parameters": {
"content": "## \ud83d\udcca Tax Database\nLogs to Sheets.",
"height": 140,
"width": 380,
"color": 6
},
"id": "ebea3a83-e55b-4d3e-a6f5-e6ce73ac879f",
"name": "Sticky Note - DB",
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
1104,
32
]
},
{
"parameters": {
"assignments": {
"assignments": [
{
"id": "id-1",
"name": "SHEET_ID",
"value": "",
"type": "string"
},
{
"id": "id-2",
"name": "TEST_MODE",
"value": "true",
"type": "string"
}
]
},
"includeOtherFields": true,
"options": {}
},
"id": "cac924da-5a46-4c80-9430-0bc7372f5bdc",
"name": "Config",
"type": "n8n-nodes-base.set",
"typeVersion": 3.4,
"position": [
-384,
96
]
},
{
"parameters": {
"formTitle": "\ud83e\uddfe Receipt Uploader",
"formDescription": "Upload a receipt image for tax categorization.",
"formFields": {
"values": [
{
"fieldLabel": "Receipt Image",
"fieldType": "file",
"requiredField": true
}
]
},
"options": {}
},
"id": "b4c86477-8a23-47d5-8034-e1bead974bc8",
"name": "Form Trigger",
"type": "n8n-nodes-base.formTrigger",
"typeVersion": 2.3,
"position": [
-624,
96
]
},
{
"parameters": {},
"id": "f1b4e134-8341-4cac-b3d6-e4eb010e64f8",
"name": "Manual Trigger",
"type": "n8n-nodes-base.manualTrigger",
"typeVersion": 1,
"position": [
-624,
240
]
},
{
"parameters": {
"rules": {
"values": [
{
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict"
},
"conditions": [
{
"leftValue": "",
"rightValue": "",
"operator": {
"type": "string",
"operation": "equals"
}
}
],
"combinator": "and"
}
}
]
},
"options": {}
},
"id": "cd48412a-b1c7-41ad-9d5c-8f62fc34dcbf",
"name": "Test Mode?",
"type": "n8n-nodes-base.switch",
"typeVersion": 3.2,
"position": [
-48,
80
]
},
{
"parameters": {
"jsCode": "// Simulate Receipt Data (Gemini Output)\nreturn [{\n json: {\n vendor: \"Starbucks Coffee\",\n date: \"2026-02-12\",\n amount: 850,\n currency: \"JPY\",\n category: \"Meeting Expenses (\u4f1a\u8b70\u8cbb)\",\n summary: \"Coffee meeting with client\"\n }\n}];"
},
"id": "394dd1a0-06a8-4193-ba96-887a833ff478",
"name": "Mock Receipt Data",
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
224,
80
]
},
{
"parameters": {
"modelId": {
"__rl": true,
"value": "models/gemini-1.5-flash",
"mode": "list",
"cachedResultName": "models/gemini-1.5-flash"
},
"messages": {
"values": [
{
"content": "=Act as a Japanese Tax Accountant.\nAnalyze the attached receipt image and extract details.\n\n[Tasks]\n1. Extract Vendor, Date, Amount.\n2. Categorize the expense into Japanese Tax Account Titles (\u52d8\u5b9a\u79d1\u76ee).\n - e.g., \u6d88\u8017\u54c1\u8cbb, \u65c5\u8cbb\u4ea4\u901a\u8cbb, \u4f1a\u8b70\u8cbb, \u65b0\u805e\u56f3\u66f8\u8cbb, \u901a\u4fe1\u8cbb.\n\n[Output JSON ONLY]\n{\n \"vendor\": \"...\",\n \"date\": \"YYYY-MM-DD\",\n \"amount\": 1000,\n \"currency\": \"JPY\",\n \"category\": \"Account Title (e.g. \u6d88\u8017\u54c1\u8cbb)\",\n \"summary\": \"Brief description\"\n}"
}
]
},
"options": {}
},
"type": "@n8n/n8n-nodes-langchain.googleGemini",
"typeVersion": 1,
"position": [
32,
256
],
"id": "ae707371-9313-4b88-bd11-55b00caf5b42",
"name": "Gemini (Vision)",
"credentials": {
"googlePalmApi": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"jsCode": "// Merge Mock and Real Data\nconst mode = $('Config').first().json.TEST_MODE;\nlet data = {};\n\nif (mode === 'true') {\n data = $('Mock Receipt Data').first().json;\n} else {\n // Parse Gemini JSON\n const text = $('Gemini (Vision)').first().json.content.parts[0].text;\n try {\n const cleanText = text.replace(/```json/g, '').replace(/```/g, '').trim();\n data = JSON.parse(cleanText);\n } catch (e) {\n data = { vendor: \"Error\", amount: 0, category: \"Unknown\" };\n }\n}\n\nreturn { json: data };"
},
"id": "5b63055d-3633-4f27-bd0b-05036343aec0",
"name": "Normalize Data",
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
688,
112
]
},
{
"parameters": {
"operation": "appendOrUpdate",
"documentId": {
"__rl": true,
"mode": "id",
"value": "={{ $('Config').first().json.SHEET_ID }}"
},
"sheetName": {
"__rl": true,
"mode": "name",
"value": "Expenses"
},
"columns": {
"mappingMode": "defineBelow",
"value": {
"Date": "={{ $json.date }}",
"Vendor": "={{ $json.vendor }}",
"Amount": "={{ $json.amount }}",
"Category": "={{ $json.category }}",
"Memo": "={{ $json.summary }}",
"Logged At": "={{ $now.format('yyyy-MM-dd HH:mm') }}"
}
},
"options": {}
},
"id": "4a916642-1256-412a-b455-63a64a445cfa",
"name": "Save to Sheets",
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.7,
"position": [
1152,
112
],
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
}
],
"connections": {
"Config": {
"main": [
[
{
"node": "Test Mode?",
"type": "main",
"index": 0
},
{
"node": "Gemini (Vision)",
"type": "main",
"index": 0
}
]
]
},
"Form Trigger": {
"main": [
[
{
"node": "Config",
"type": "main",
"index": 0
}
]
]
},
"Manual Trigger": {
"main": [
[
{
"node": "Config",
"type": "main",
"index": 0
}
]
]
},
"Test Mode?": {
"main": [
[
{
"node": "Mock Receipt Data",
"type": "main",
"index": 0
}
]
]
},
"Mock Receipt Data": {
"main": [
[
{
"node": "Normalize Data",
"type": "main",
"index": 0
}
]
]
},
"Gemini (Vision)": {
"main": [
[
{
"node": "Normalize Data",
"type": "main",
"index": 0
}
]
]
},
"Normalize Data": {
"main": [
[
{
"node": "Save to Sheets",
"type": "main",
"index": 0
}
]
]
},
"Save to Sheets": {
"main": [
[]
]
}
},
"active": false,
"settings": {
"executionOrder": "v1",
"availableInMCP": false
},
"versionId": "d6024029-5044-432b-acd5-71b07eda9ae5",
"meta": {
"templateCredsSetupCompleted": true
},
"id": "iubi4c2RciB37pvJ",
"tags": []
}
Credentials you'll need
Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.
googlePalmApigoogleSheetsOAuth2Api
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Smart Tax Accountant: Auto-Categorize Receipts for Tax Return. Uses formTrigger, googleGemini, googleSheets. Event-driven trigger; 13 nodes.
Source: https://github.com/alternativescom/n8n-automation-workflows/blob/main/12-smart-tax-accountant/workflow.json — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
Upload a job posting (PDF, image, or screenshot) and instantly get a tailored CV section and a matching cover letter – both written in the posting's language and tone, both honest about what you actua
Form Trigger, Google Sheets, @Easybits/N8N Nodes Extractor +3
This workflow accepts invoice PDFs or images from an n8n Form or Telegram, uses Google Gemini to OCR and extract structured invoice fields and line items, appends the results to Google Sheets, and sen
Form Trigger, Google Sheets, Google Gemini +2
This n8n template automates scraping content from Skool communities using the Olostep API. It collects structured data from Skool pages and stores it in a clean format, making it easy to analyze commu
N8N Nodes Olostep, Form Trigger, HTTP Request +3
It is ideal for businesses handling vendor invoices, reimbursement forms, or bulk document intake.
HTTP Request, Information Extractor, Google Gemini Chat +3
Note: This template only works for self-hosted n8n.
Google Sheets Tool, Form Trigger, Form +3