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 contact is created or updated.
Triggers when an estimate is created or updated.
Triggers when an expense is created or updated.
Trigger when an invoice is created or updated.
Triggers when an item is created or updated.
Triggers when a project is created.
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.
Pošle textovou zprávu.
Vyvoláním této akce zjistíte aktuální výši zbývajícího kreditu na portálu SMSbrána.
Creates a contact with given information.
Creates a contact person for contact.
Creates a new credit note.
Creates a new expense category.
Creates an estimate for your customer.
Creates a billable or non-billable expense.
Creates an invoice for your customer.
Creates a new item.
Creates a new payment.
Creates a new price list.
Creates a new project.
Creates a new recurring expense.
Creates a new recurring invoice.
Delete an existing Contact.
Delete an existing contact person.
Deletes an existing credit note.
Deletes an existing estimate.
Deletes an existing expense.
Delete an existing invoice. Invoices which have payment or credits note applied cannot be deleted.
Deletes an existing item. Items that are part of a transaction cannot be deleted.
Deletes an existing payment.
Deletes a price list.
Deletes an existing project.
Deletes an existing recurring expense.
Deletes an existing recurring invoice.
Deletes a task added to a project.
Deetes a logged time entry.
Email a credit note.
Emails an invoice to the customer. Input json string is not mandatory. If input json string is empty, mail will be send with default mail content.
Get details of a contact.
Get the details of a contact person.
Gets details of an existing credit note.
Get the details of an estimate.
Gets the detail of the expense.
Gets the details of an invoice.
Fetches details of an existing item.
Gets the details of an existing payment.
Fetches the details of an existing price list.
Gets the details of a project.
Gets the details of the recurring expense.
Gets the details of a recurring invoice.
Gets details of a time entry.
Logs time entries.
Performs an arbitrary authorized API call.
Mark a contact as active or inactive.
Marks a contact person as primary for contact.
Marks a draft estimate as send, accepted or declined.
Marks a invoice as sent, void, or draft.
Marks an item as active or inactive.
Marks project as active or inactive.
Stops or resumes an active recurring invoice.
Refunds credit note amount.
Refund the excess amount paid by the customer.
Update an existing contact. To delete a contact person remove it from the contact persons list.
Update details of an existing contact person.
Update details of an existing credit note.
Updates an existing estimate. To delete a line item just remove it from the line items list.
Update an existing expense.
Updates an existing invoice. To delete a line item just remove it from the line items list.
Updates the details of an existing item.
Updates an existing payment information.
Updates an existing Price List.
Updates details of a project.
Updates an exsiting recurring expense.
Updates a recurring invoice.
Updates the details of an existing task.
Updates logged time entry.
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.
Lists all contact persons with pagination.
Lists all contacts with pagination.
Lists all the credit notes.
Lists all estimates with pagination.
List Expense categories along with pagination.
List all the expenses with pagination.
Lists all invoices with pagination.
Gets the list of all active items with pagination.
Lists all the refunds pertaining to an existing customer payment.
Lists all the payments made by your customer.
Gets the list of all the price lists with pagination.
Lists all projects with pagination.
Lists all the expenses with pagination.
Lists the details of all recurring invoices.
Lists all time entries with pagination.