Automated Invoice Creation: Google Sheets to QuickBooks Online

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

1. Connect Google Sheets and QuickBooks credentials in n8n.
2. In the config node, set sheets_url to your sheet (the example link can be used for tests).
3. Ensure your sheet has CustomerId, Amount, and Description.
4. 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.