Record Chatwork expense and sales notes to Google Sheets with Claude checks

by 久保田 卓磨 ✓ · 1 views · created 2026-10-10 · Document Extraction, AI Summarization

What this workflow does

This AI workflow has 22 nodes and runs on a schedule (every 5 minutes) (plus 2 other triggers). Along the way it connects Google Sheets and Anthropic. It also calls api.chatwork.com over HTTP.

How it runs

Trigger: On a schedule (every 5 minutes) (plus 2 other triggers).

1. Config (Edit Fields (Set)): sets 10 fields: room_ids, keyword, strip_keyword…
2. Spreadsheet ID (Edit Fields (Set)): sets 1 field: spreadsheet_id
3. Get room names (HTTP Request): calls api.chatwork.com (GET)
4. Add the log and records tabs (HTTP Request): calls an HTTP API (POST)
5. Split rooms (Code): runs custom JavaScript code
6. Write the header rows (HTTP Request): calls an HTTP API (POST)
7. Get messages (HTTP Request): calls an HTTP API (GET)
8. Add room (Edit Fields (Set)): sets 2 fields: room_id, room_name
9. Clean messages (Code): runs custom JavaScript code
10. Keep new messages only (Remove Duplicates): removes duplicate items

…plus 9 more steps. See the full node list below.

Services it uses

Google SheetsAnthropic

HTTP calls to: api.chatwork.com

Before you upgrade to n8n 3.0

Nodes used (9)

• Schedule Triggern8n-nodes-base.scheduleTrigger
• Manual Triggern8n-nodes-base.manualTrigger
• Edit Fields (Set)n8n-nodes-base.set
• HTTP Requestn8n-nodes-base.httpRequest
• Coden8n-nodes-base.code
• Remove Duplicatesn8n-nodes-base.removeDuplicates
• Google Sheetsn8n-nodes-base.googleSheets
• Ifn8n-nodes-base.if
• Anthropic@n8n/n8n-nodes-langchain.anthropic

From the author

Quick overview This workflow polls selected Chatwork rooms every 5 minutes, logs new messages to Google Sheets, uses Anthropic Claude to extract expense and sales records from keyword-tagged notes, validates the results with custom code, writes structured…

View the original on n8n.io → Check your own copy