Google Sheets and QuickBooks Online

Google Sheets

Triggers

• New row in a Google SheetRuns when a new row is added to a Google Sheets spreadsheet, with the row's cells by their column headings and the spreadsheet and tab it was added to, for a step that writes back to the row, such as Update cells in row.

Actions

• Add rowAdd a row to the end of a tab.
• Create spreadsheetCreate a new spreadsheet.
• Delete spreadsheetDelete a spreadsheet permanently.
• Overwrite rowOverwrite a whole row, from column A, with values in column order. To change only some cells of a row, use Update cells in row.
• Update cells in rowSet some cells of one row by column name, leaving the rest of the row as it is. Pair it with Read rows to write a result back to the row it came from (row.row_number). A column that doesn't exist yet is added to the header row.
• Clear rowEmpty a row's cells without deleting the row.

QuickBooks Online

Triggers

• New QuickBooks customerRuns when a customer is added in QuickBooks Online.
• New QuickBooks vendorRuns when a vendor is added in QuickBooks Online.
• New QuickBooks invoiceRuns when an invoice is created in QuickBooks Online.
• QuickBooks invoice paidRuns when a customer payment pays off an invoice in QuickBooks Online.
• New QuickBooks paymentRuns when a customer payment is recorded in QuickBooks Online.
• New QuickBooks billRuns when a bill is entered in QuickBooks Online.

Actions

• Get QuickBooks company infoRead the connected company's name, legal name, address, contact details, country and fiscal year start.
• List QuickBooks accountsList accounts from the chart of accounts, optionally narrowed by type, classification or name. Returns one page; use start_position to get the next.
• Create a QuickBooks accountAdd an account to the chart of accounts, such as a new bank account or expense category. QuickBooks accounts can't be deleted, only made inactive in QuickBooks.
• List QuickBooks customersList customers, optionally narrowed by name, email or when they last changed. Returns one page; use start_position to get the next.
• Get a QuickBooks customerRetrieve a single customer by ID from QuickBooks Online.
• Create a QuickBooks customerCreate a new customer in QuickBooks Online.