Connect Google Sheets to Xero

Add Sheet to Existing Spreadsheet

Adds a new sheet to a spreadsheet. Supports three sheet types: GRID, OBJECT, and DATA_SOURCE. SHEET TYPES: - GRID (default): Standard spreadsheet with rows/columns. Use properties to set dimensions, tab color, etc. - OBJECT: Sheet contai...

Aggregate Column Data

Searches for rows where a specific column matches a value and performs mathematical operations on data from another column.

Append Dimension

Tool to append new rows or columns to a sheet, increasing its size. Use when you need to add empty rows or columns to an existing sheet.

Auto-Resize Rows or Columns

Auto-fit column widths or row heights for a dimension range using batchUpdate.autoResizeDimensions. Use when you need to automatically adjust row heights or column widths to fit content after writing data.

Batch Clear Values By Data Filter

Clears one or more ranges of values from a spreadsheet using data filters. The caller must specify the spreadsheet ID and one or more DataFilters. Ranges matching any of the specified data filters will be cleared. Only values are cleared...

Batch get spreadsheet

Retrieves data from specified cell ranges in a Google Spreadsheet.

Create Bank Transaction

Create a bank transaction in Xero. Use SPEND for payments out or RECEIVE for money received.

Create Contact

Create a new contact in Xero. Contacts can be customers, suppliers, or both.

Create Invoice

Create a new invoice in Xero. Supports both sales invoices (ACCREC) and bills (ACCPAY).

Create Item

Create an inventory item in Xero. Items can be tracked for sales and/or purchases.

Create Manual Journal

Create one or more manual journals (journal entries) in Xero with journal lines. Manual journals must balance (debits equal credits).

Create Payment

Create a payment in Xero to link an invoice with a bank account transaction.