Receives data passed to the function INTEGROMAT used in a sheet. Sheets Add-On required.
Triggers when a cell is updated. Watches only changes made in Google Sheet app. Sheets Add-On required.
Watches for new rows.
Triggers when a bank transaction is added or updated.
Triggers when a new bank transfer is created.
Triggers when a contact is created or updated.
Triggers when a credit note is added or updated.
Triggers when an invoice is added or updated.
Triggers when a new item is created.
Triggers when a manual journal is created or updated.
Triggers when a payment is created or updated.
Triggers when an order is added or updated.
Returns current weather information for a specified location.
Returns 1-16 days weather forecast for a specified location.
Appends a new row to the bottom of the table.
Adds a new sheet.
Cleares a specific cell.
Clears values from a specific row.
Creates a new spreadsheet.
Deletes a specific row.
Deletes a specific sheet.
Gets a specific cell.
Returns processed data as a result of the INTEGROMAT function. Sheets Add-On required.
Updates a specific cell.
Updates a row.
Adds a contact to a specified contact group.
Archives a contact with a given ID.
Creates a new bank transaction.
Transfers a specified amount from one account to another.
Creates a new contact.
Creates a contact group.
Creates a new credit note.
Adds a note to a record.
Creates a manual journal.
Creates a new employee.
Creates a new invoice.
Creates a new item.
Use this method to apply payments to approved AR and AP invoices or refund AR or AP credit notes.
Creates a new purchase order.
Creates a quote.
Deletes all contacts from a contact group.
Downloads an attachment.
Downloads an invoice.
Returns information about a transaction with a specified ID.
Retrieves contact information by ID.
Returns information about a contact group.
Returns information about a credit note with a specified ID.
Returns information about a manual journal.
Returns information about an account with a specified ID.
Returns information about an invoice with a given ID.
Retrieves Xero online invoice URL.
Searches for an item by item ID or item code.
Retrieves information about a payment with a specified ID.
Returns information about a purchase order with a specified ID.
Performs an arbitrary authorized API call.
Removes a contact from a contact group.
The email will be sent to the primary email address of the contact on the invoice. The invoice must be of Type ACCREC and a valid Status for sending (SUMBITTED,AUTHORISED or PAID).
Updates a contact by ID.
Updates an employee by ID.
Updates an invoice by ID.
Updates an item by ID.
Uploads a file to a selected object.
Gets a range content.
Gets a list of all sheets in a spreadsheet.
Returns results matching the given criteria.
Returns results matching the given criteria. This module doesn't return a row number.
Returns bank statements for a selected bank account.
Returns the balances and cash movements for each bank account.
Retrieves the changes made to a given object.
Retrieves a list of attachments.
Finds an account by ID, name, or code.
Searches for a contact by name or email.
Searches for an invoice.
Returns a list of items.
Searches for a manual journals.
Finds a tax rate by name.