Integrate Google Sheets with QuickBooks Online to automate your work

Creates a new spreadsheet. Choose from a blank spreadsheet, a copy of an existing one, or one with headers.

Permanently deletes all data in a selected row. This action cannot be undone.

This is an advanced action which makes a raw HTTP request that includes this integration's authentication.

Finds a worksheet by title.

Find a specific spreadsheet row based on a column and value. If found, it returns the entire row. Optionally, create a new row if no match is found.

Finds or creates a specific lookup row.

Triggers when an invoice becomes due within a specified number of days.

Create a new bill, optionally tied to a customer (with line item support).

Creates a new deposit in QuickBooks.

Creates a new credit memo.

Create a new estimate (with line item support).

Creates a new product or service.

Adds a new invoice (with line item and bundle item support).

Creates a new payment, optionally linked to an invoice.

Creates a new refund receipt.

Send an existing invoice.

Creates a new single time activity.

Updates an existing customer.

Updates an existing invoice (with line item support).

Updates an existing sales receipt.

Creates a new vendor credit.

Find an account by name.

Find a customer by name or email address.

Finds a class based on name or ID.

Finds a payment based on Id.

Find an invoice using either Invoice Number, Invoice ID or Invoice Date or Due Date.

Find a vendor by name.

Finds or creates a specific employee.

Finds or creates a specific product.

Create a blank worksheet with a title. Optionally, provide headers.

Format a row in a specific spreadsheet.

Find up to 500 rows based on a column and value as line items.

Return up to 500 rows as a single JSON value or as line items.

Finds or creates a specific find worksheet.

Create a new bill, optionally tied to a customer.

Create a new bill, optionally tied to a customer (with line item support).

Creates a new employee.

Adds a new customer.

Creates a new expense using check, cash, or credit card.

Creates a new journal entry.