Google Sheets and QuickBooks expenses automation template
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 15 nodes and runs manually, when you click “Execute workflow”. Along the way it connects QuickBooks Online and Google Sheets.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Get New Vendors from Google Sheets (Google Sheets): uses Google Sheets
- Set Realm ID for Custom API Call (Edit Fields (Set)): sets 1 field: realmID
- Remove Duplicates: removes duplicate items
- Get Chart of Accounts (HTTP Request): calls an HTTP API
- Get New Expense Transactions (Google Sheets): uses Google Sheets
- Create New Vendors in QuickBooks (QuickBooks Online): create (vendor)
- Split Out: splits a list into separate items
- Remove Empties (If): checks a condition and branches into true / false
- Get Active Vendors in QuickBooks (QuickBooks Online): get many (vendor)
- Add Accounts to Google Sheet Template (Google Sheets): append or update
…plus 4 more steps. See the full node list below.
Services it uses
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)
- Manual Trigger
n8n-nodes-base.manualTrigger - QuickBooks Online
n8n-nodes-base.quickbooks - HTTP Request
n8n-nodes-base.httpRequest - Split Out
n8n-nodes-base.splitOut - Google Sheets
n8n-nodes-base.googleSheets - Remove Duplicates
n8n-nodes-base.removeDuplicates - If
n8n-nodes-base.if - Edit Fields (Set)
n8n-nodes-base.set
From the author
Automatically Upload Expenses to QuickBooks from Google Sheets What It Does This n8n workflow template automates the process of uploading categorized expenses from Google Sheets into QuickBooks Online. It leverages your Google Sheets data to create expense…