Step 2: Connect Google Sheets

These nodes load and update vendor, account, and expense data in your spreadsheet.

1. Open Fetch New Sheet Vendors and set Document to https://docs.google.com/spreadsheets/d/[YOUR_ID]/edit and Sheet to Vendors.
2. Open Fetch Expense Entries and set Document to https://docs.google.com/spreadsheets/d/[YOUR_ID]/edit and Sheet to Expenses with a filter on Transaction ID.
3. Open Append Accounts to Sheet and set Operation to appendOrUpdate, mapping columns: ID → {{ $json.Id }}, Name → {{ $json.Name }}, Account Type → {{ $json.AccountType }}.
4. Open Update Vendor Sheet and set Operation to appendOrUpdate with mappings ID → {{ $json.Id }} and Name → {{ $json.DisplayName }}.
5. Open Log Transaction ID and set Operation to update with mappings # → {{ $('Filter Empty Records').item.json['#'] }} and Transaction ID → {{ $json.Purchase.Id }}.
6. Open Log Error Message and set Operation to appendOrUpdate with mappings # → {{ $json['#'] }} and Message → {{ $json.error }}.
7. Credential Required: Connect your googleSheetsOAuth2Api credentials to all Google Sheets nodes (6 nodes handle vendors, accounts, expenses, and logging).

Step 3: Set Up QuickBooks Connections

These nodes read and write vendor and expense data in QuickBooks Online.

1. Open Fetch Active Vendors and confirm Resource is vendor, Operation is getAll, and Return All is enabled.
2. Open Create Vendors in QBO and set Resource to vendor, Operation to create, and Display Name to {{ $json.Name }}.
3. Credential Required: Connect your quickBooksOAuth2Api credentials to Fetch Active Vendors and Create Vendors in QBO.

Step 4: Configure Ledger & Expense Posting

This path loads accounts and posts expenses to QuickBooks based on sheet data.

1. Open Assign Realm ID and set the realmID assignment value to your QuickBooks Company ID (realm ID).
2. In Retrieve Account Ledger, set URL to https://sandbox-quickbooks.api.intuit.com/v3/company/{{ $json.realmID }}/query and ensure query parameters include select * from Account where active=true maxResults 500 and minorversion = 75.
3. In Separate Account Items, set Field To Split Out to QueryResponse.Account.
4. In Post Expense to QBO, set URL to https://sandbox-quickbooks.api.intuit.com/v3/company/{{ $('Assign Realm ID').item.json.realmID }}/purchase and confirm the JSON body maps fields like {{ $json.Date.toDateTime('M/d/y').toFormat('yyyy-MM-dd') }}, {{ $json.Description }}, {{ $json['Vendor ID'] }}, and {{ $json['Expense ID'] }}.
5. Ensure Assign Realm ID outputs to both Retrieve Account Ledger and Fetch Expense Entries in parallel.
6. Credential Required: Connect your quickBooksOAuth2Api credentials to Retrieve Account Ledger and Post Expense to QBO.

Step 5: Configure Filtering and Vendor Deduplication

These nodes prevent blank or duplicate items from being created and posted.

1. In Eliminate Duplicate Vendors, set Compare to selectedFields and Fields To Compare to Name.
2. In Filter Empty Records, confirm conditions: Transaction ID is empty using {{ $json['Transaction ID'] }} and Vendor is not empty using {{ $json.Vendor }}.
3. Verify the execution flow: Fetch New Sheet Vendors → Eliminate Duplicate Vendors → Create Vendors in QBO → Fetch Active Vendors → Update Vendor Sheet.
4. Verify the expense flow: Fetch Expense Entries → Filter Empty Records → Post Expense to QBO → Log Transaction ID.

Step 6: Add Error Handling

Errors from posting expenses are routed to a log sheet so issues can be reviewed.

1. Open Post Expense to QBO and confirm it is set to continue on error (so failures can be captured).
2. Ensure Post Expense to QBO outputs to both Log Transaction ID (success path) and Log Error Message (error path).
3. Verify Log Error Message writes to the Expenses sheet with {{ $json.error }}.

Step 7: Test and Activate Your Workflow

Run a controlled test to confirm accounts, vendors, and expenses sync correctly.

1. Click Execute Workflow to run Manual Start Trigger with a small sample of vendor and expense rows.
2. Confirm that account data appears in the Accounts sheet via Append Accounts to Sheet.
3. Verify vendor creation in QuickBooks and that Update Vendor Sheet writes back IDs.
4. Check the Expenses sheet for updated Transaction ID values from Log Transaction ID and any errors in Log Error Message.
5. Once validated, set the workflow to Active for production use.