Check freee expense deals with Gemini, kintone, Google Drive and Chatwork
Ready for 3.0What this workflow does
This workflow has 13 nodes and runs on a schedule (cron 0 9 * * 1-5). It uses only n8n's built-in nodes. It also calls api.freee.co.jp over HTTP.
How it runs
Trigger: On a schedule (cron 0 9 * * 1-5).
- Config (Edit Fields (Set)): sets or maps fields
- freee API - Get expense deals (HTTP Request): calls api.freee.co.jp
- Split deals into items (Split Out): splits a list into separate items
- Gemini - Check expense details (HTTP Request): calls an HTTP API (POST)
- Parse Gemini judgement (Code): runs custom JavaScript code
- Filter: keeps only the items that match a condition
- kintone API - Check for duplicate (HTTP Request): calls an HTTP API
- If: checks a condition and branches into true / false
- kintone API - Create record (HTTP Request): calls an HTTP API (POST)
- Google Drive API - Archive receipt summary (HTTP Request): calls an HTTP API (POST)
…plus 2 more steps. See the full node list below.
HTTP calls to: api.freee.co.jp
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (8)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - Split Out
n8n-nodes-base.splitOut - Code
n8n-nodes-base.code - Filter
n8n-nodes-base.filter - If
n8n-nodes-base.if - Aggregate
n8n-nodes-base.aggregate
From the author
Quick overview This workflow runs daily and pulls recent expense deals from freee, asks Google Gemini to flag anything unusual, logs the deal and AI comment to kintone, archives a JSON summary to Google Drive, and notifies your accounting team in Chatwork.…