Who’s it for
Teams that invoice from spreadsheets and want a dependable, repeatable push into QuickBooks Online without manual entry. Useful for subscriptions, small batches, and ops demos.
How it works / What it does
- Starts on manual run for safe testing.
- Reads rows from a Google Sheet and maps fields to invoice inputs.
- Creates one QuickBooks Online invoice per row using your item settings.
- Reports basic success or errors so you can adjust data quickly.
How to set up
- Connect Google Sheets and QuickBooks credentials in n8n.
- In the config node, set
sheets_url to your sheet (the example link can be used for tests).
- Ensure your sheet has
CustomerId, Amount, and Description.
- In the QBO node, set a valid
itemId and default quantity if needed.
Example sheet (read-only):
Open the sample spreadsheet
Requirements
- n8n environment
- QuickBooks Online with OAuth2
- Google Sheets access to the source spreadsheet
How to customize the workflow
- Replace Google Sheets with Airtable, CSV import, DB query, or your API while keeping the same field names.
- Add tax, terms, or line items from extra columns.
- Schedule runs or add approval steps before invoice creation.
