{"product_id":"n8n-automate-chatwork-notes-to-google-sheets-with-claude","title":"n8n Automate Chatwork Notes to Google Sheets with Claude","description":"\u003ch3\u003eAutomatically turn Chatwork expense \u0026amp; sales notes into structured Google Sheets records using Claude\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow polls your selected \u003cstrong\u003eChatwork\u003c\/strong\u003e rooms every 5 minutes, logs new messages to Google Sheets, then uses \u003cstrong\u003eAnthropic Claude\u003c\/strong\u003e to extract \u003cem\u003eexpense and sales records\u003c\/em\u003e from keyword-tagged notes—validated with custom code and written into a structured “records” tab.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a schedule (every 5 minutes)\u003c\/strong\u003e or manually, loading configuration such as Chatwork room IDs, the note keyword, categories, and timezone.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches latest Chatwork messages\u003c\/strong\u003e from each configured room via the Chatwork API.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCleans Chatwork markup\u003c\/strong\u003e into plain text, filters out old\/system\/self-reply messages, and keeps only messages not processed in previous executions.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends new messages to a Google Sheets “log” tab\u003c\/strong\u003e for traceability.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDetects keyword-tagged notes\u003c\/strong\u003e: for messages containing the configured keyword, it checks the Google Sheets “records” tab to skip notes already recorded.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtracts accounting records with Claude\u003c\/strong\u003e: sends eligible notes to Anthropic Claude to extract one or more records as JSON.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates and normalizes results\u003c\/strong\u003e: custom code validates extracted fields (amount\/quote\/date\/category rules), converts relative date text into a real date, and writes rows to “records” with \u003cstrong\u003eOK\u003c\/strong\u003e or \u003cstrong\u003e要確認\u003c\/strong\u003e status.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOptionally replies in Chatwork\u003c\/strong\u003e with a single confirmation summary (or review-needed reason) and marks the reply so it is never processed as a note.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eOperations teams capturing expenses and sales notes in Chatwork, while maintaining an always-updated Google Sheets ledger.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators consolidating accounting inputs without manual copy\/paste.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers standardizing how keyword-tagged notes become validated spreadsheet records.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Chatwork API, Google Sheets\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLLM:\u003c\/strong\u003e Anthropic Claude (extracts expense\/sales records as JSON)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\/logic:\u003c\/strong\u003e if, set, code, sticky note, HTTP request, Google Sheets\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46203575926963,"sku":"N8N-20733","price":68.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/ZfTVzdomhGTV3yHnAt5bb_ayBAywp8.png?v=1791710111","url":"https:\/\/buyflowscripts.com\/products\/n8n-automate-chatwork-notes-to-google-sheets-with-claude","provider":"N8N Commerce","version":"1.0","type":"link"}