Automated export of Quickbooks Online data with n8n - with tutorial
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 4 nodes and runs on a schedule (every month at 08:00). Along the way it connects QuickBooks Online and Google Sheets.
How it runs
Trigger: On a schedule (every month at 08:00).
- Fetch Customers from QuickBooks (QuickBooks Online): get many
- Prepare Customer Data (Edit Fields (Set)): sets 3 fields: Id, Balance, Email
- Export to Google Sheets (Google Sheets): append
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 (4)
- QuickBooks Online
n8n-nodes-base.quickbooks - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - Schedule Trigger
n8n-nodes-base.scheduleTrigger
From the author
Video Introduction Want to automate your inbox or need a custom workflow? 📞 Book a Call | 💬 DM me on Linkedin --- Overview This workflow automatically exports customer balance data from QuickBooks to Google Sheets on a monthly basis. It eliminates manual…