Automate QuickBooks customers & sales receipts generation from a Google Sheet

This n8n template from [Intuz](https://www.intuz.com/) provides a complete and automated solution to streamline your sales and accounting process.

Simply add new transaction details to a designated Google Sheet, and this workflow takes over. Using specific status keywords in a column to trigger the process, it automatically creates new customer profiles and generates sales receipts in QuickBooks. This creates a complete, end-to-end system from a simple spreadsheet entry to a formal accounting record, eliminating manual data entry.

How it works

This workflow streamlines the process of recording sales from a Google Sheet into QuickBooks Online, intelligently handling both new and existing customers.

1. Trigger on New Row: The workflow starts automatically whenever a new row is added to your specified Google Sheet.

2. Check for Existing Customer: It takes the customer's name from the new row and searches your QuickBooks account to see if a customer with that DisplayName already exists.

3. Conditional Logic (IF Node): Based on the search result, the workflow splits into two paths:

- If Customer Exists (True Path): The workflow proceeds directly to create a Sales Receipt, linking it to the existing customer's ID found in the search. - If Customer Does Not Exist (False Path): The workflow first creates a new customer in QuickBooks using the name and email from the sheet. It then uses the ID of this newly created customer to generate the corresponding Sales Receipt.