{"id":90,"name":"Extract expenses from emails and add to Google Sheet","nodes":[{"id":"trigger-ce75c2bc","name":"Manual Trigger","type":"n8n-nodes-base.manualTrigger","typeVersion":1,"position":[100,100],"parameters":{}},{"name":"Check subject","type":"n8n-nodes-base.if","position":[800,300],"parameters":{"conditions":{"string":[{"value1":"={{$json[\"subject\"].toLowerCase()}}","value2":"=/{{$json[\"subjectPatterns\"].toLowerCase()}}/","operation":"regex"}]},"combineOperation":"any"},"typeVersion":1,"id":"b15e5cbe-1ca2-4e8d-9c41-15fb4c0b639f","notes":"This if node performs automated tasks as part of the workflow."},{"name":"Setup Variables","type":"n8n-nodes-base.set","position":[620,300],"parameters":{"values":{"string":[{"name":"subjectPatterns","value":"(expenses|reciept)"}]},"options":{}},"typeVersion":1,"id":"3bb8576e-9b1b-4d02-b88f-7f93bc37e04f","notes":"This set node performs automated tasks as part of the workflow."},{"name":"Check for new emails","type":"n8n-nodes-base.emailReadImap","position":[440,300],"parameters":{"format":"resolved","mailbox":"Inbox","options":{"allowUnauthorizedCerts":true}},"credentials":{"imap":{"id":"{{ $credentials.imap.id }}","name":"GMAIL"}},"typeVersion":1,"id":"baf1dfb8-0486-4dfc-b7c8-320d21ed2743","notes":"This emailReadImap node performs automated tasks as part of the workflow."},{"name":"Read Receipts","type":"n8n-nodes-base.mindee","position":[1020,280],"parameters":{"binaryPropertyName":"attachment_0"},"credentials":{"mindeeReceiptApi":{"id":"{{ $credentials.mindeeReceiptApi.id }}","name":"Mindee Receipt account"}},"typeVersion":1,"id":"17b1387f-46e7-4184-a49d-a99eb1d518e3","notes":"This mindee node performs automated tasks as part of the workflow."},{"name":"Set column data","type":"n8n-nodes-base.set","position":[1200,280],"parameters":{"values":{"string":[{"name":"Date","value":"={{$json[\"date\"]}}"},{"name":"Description","value":"={{$node[\"Check for new emails\"].json[\"subject\"].split(\"-\")[1]}}"},{"name":"Category","value":"={{$json[\"category\"]}}"},{"name":"Currency","value":"={{$json[\"currency\"]}}"},{"name":"Amount","value":"={{$json[\"total\"]}}"}]},"options":{}},"typeVersion":1,"id":"d04b42ee-32e2-4985-aeff-86727cf0ebff","notes":"This set node performs automated tasks as part of the workflow."},{"name":"Add to Google Sheet","type":"n8n-nodes-base.googleSheets","position":[1380,280],"parameters":{"range":"A:E","options":{},"sheetId":"1xAtx1ORZYKu4urgqpOe3DawFjiWeOZO0VCVvOlQYnaE","operation":"append","authentication":"{{ $credentials.oAuth2 }}"},"credentials":{"googleSheetsOAuth2Api":{"id":"{{ $credentials.googleSheetsOAuth2Api.id }}","name":"Sheets"}},"typeVersion":1,"id":"0e943e58-3b1b-4bc3-8906-12838b9e6dbe","notes":"This googleSheets node performs automated tasks as part of the workflow."}],"active":false,"settings":{"executionOrder":"v1","saveManualExecutions":true,"callerPolicy":"workflowsFromSameOwner","errorWorkflow":null,"timezone":"UTC","executionTimeout":3600,"maxExecutions":1000,"retryOnFail":true,"retryCount":3,"retryDelay":1000},"connections":{"Check for new emails":{"main":[[],[],[],[],[],[],[],[]]}},"description":"Automated workflow: Extract expenses from emails and add to Google Sheet. This workflow processes data and performs automated tasks.","meta":{"instanceId":"workflow-53444285","versionId":"1.0.0","createdAt":"2025-09-29T07:07:45.509182","updatedAt":"2025-09-29T07:07:45.509197","owner":"n8n-user","license":"MIT","category":"automation","status":"active","priority":"high","environment":"production"},"notes":"Excellent quality workflow: Extract expenses from emails and add to Google Sheet. This workflow has been optimized for production use with comprehensive error handling, security, and documentation."}