Automated Multi-Line Invoice Generation from Google Sheets to QuickBooks Online (n8n)

Streamline billing by aggregating spreadsheet entries into professional QuickBooks invoices using n8n's logic nodes.

Tools: Google Sheets → QuickBooks Online

Platform: n8n

Short Answer

A fully automated n8n workflow that monitors a Google Sheet for 'Ready' status, aggregates multiple line items for the same customer, creates or updates the customer record, and generates a finalized QuickBooks invoice with an attached link to the source data.

The Problem

Manual entry of line items from tracking sheets into QuickBooks is prone to human error and consumes hours of administrative time. Businesses often struggle to group multiple billable rows from a spreadsheet into a single, cohesive invoice for a specific customer.

The Outcome

A fully automated n8n workflow that monitors a Google Sheet for 'Ready' status, aggregates multiple line items for the same customer, creates or updates the customer record, and generates a finalized QuickBooks invoice with an attached link to the source data.

Step-by-Step Guide

1. **Establish Credentials**: In n8n, go to 'Credentials' and set up 'Google Sheets OAuth2 API' and 'QuickBooks Online OAuth2 API'. Ensure your Google App has the 'Drive' and 'Sheets' scopes enabled. 2. **Configure Trigger**: Add a 'Google Sheets Trigger' node. Set the event to 'On Row Updated'. Select your Spreadsheet and Worksheet. Set the 'Poll Times' to your preferred frequency (e.g., every 5 minutes). 3. **Filter Logic**: Drag an 'If' node or 'Filter' node. Set the condition to check if the column `Status` is equal to `Ready`. This prevents draft rows from being processed. 4. **Search and Create Customer**: Add a 'QuickBooks Online' node. Set the Action to 'Get All' Customers. Use an n8n Expression to filter by email: `{{ $json.Email }}`. 5. **Conditional Branching (Check/Create)**: Use an 'If' node to check if the search returned a result. If not, follow with a QuickBooks 'Create' Customer node to ensure the invoice has a valid `CustomerRef`. 6. **Data Aggregation**: To handle multiple rows for one invoice, use the 'Aggregate' node. Group by `Customer Email` or `Customer ID`. Map fields like `Description`, `Amount`, and `Quantity` into a nested list that QuickBooks expects for line items. 7. **Map Line Items with Expressions**: In the QuickBooks 'Create Invoice' node, use the 'Fixed' or 'Expression' toggle for Line Items. Reference the aggregated data from the previous step. Use `{{ $node["Aggregate"].json["line_items"] }}`. 8. **Format Dates**: Ensure the date is in ISO 8601 format using n8n expressions: `{{ $now.format('yyyy-MM-dd') }}` for the `TxnDate` field. 9. **Finalize Invoice**: Set the `Financial Link` or `Memo` to include the Google Sheet URL for auditability. 10. **Feedback Loop**: Add a final Google Sheets 'Update Row' node to change the status from 'Ready' to 'Processed' and write back the QuickBooks `Invoice ID` and `Total Amount` for verification.