ABRA FlexiBee, Placeholder, Google Sheets, Zoho Projects, Xero, Microsoft SQL Server Integrations

ABRA FlexiBee
Placeholder
Google Sheets
Microsoft SQL Server
Zoho Projects
Xero
Try Integromat for FREE
No credit card. You'll love it.

What is Integromat?

GmailWatch emailsGoogle SheetsAdd a rowGmailIterate attachmentsRouterFacebookCreate a postArchiveCreate an archiveDropboxUpload a fileDocuments onlyImages onlyWhen new email arrivesAdd a row to a sheetProcess attachmentsone by one ...Post images to pageZip all documentsUpload archive

Integromat will automate processes that you currently handle manually. It is not only capable of connecting apps but can also transfer and transform data. It works 24 hours a day, seven days a week and does not require your intervention. Simply set Integromat to do what you want and let it work for you. Save your time!

Triggers

ABRA FlexiBee

Sledovat změny v evidenci

Spustí se, pokud bude ve zvolené evidenci vytvořen nebo upraven záznam.

ABRA FlexiBee

Sledovat změny v evidenci (webhook) INSTANT

Spustí se, pokud dojde ve zvolené evidenci ke zvoleným změnám.

Google Sheets

Perform a Function INSTANT

Receives data passed to the function INTEGROMAT used in a sheet. Sheets Add-On required.

Google Sheets

Watch Changes INSTANT

Triggers when a cell is updated. Watches only changes made in Google Sheet app. Sheets Add-On required.

Google Sheets

Watch Rows

Watches for new rows.

Zoho Projects

Watch Bugs

Triggers when a new bug/issue is created.

Zoho Projects

Watch Documents

Triggers when a new document is added.

Zoho Projects

Watch Milestones

Triggers when a new milestone is created.

Zoho Projects

Watch Projects

Triggers when a new project is created.

Zoho Projects

Watch Tasklists

Triggers when a new tasklist is created.

Zoho Projects

Watch Tasks

Triggers when a task is created.

Zoho Projects

Watch Time Logs

Triggers when a new time log is created.

Xero

Watch receipts

Triggers when a new receipt is added or an existing receipt is updated.

Xero

Watch invoices

Triggers when a new invoice is added or an existing invoice is updated.

Xero

Watch credit notes

Triggers when a new credit note is added or an existing credit note is updated.

Xero

Watch bank transactions

Triggers when a new transaction is added or an existing transaction is updated.

Xero

Watch bank transfers

Triggers when a new bank transfer is created.

Xero

Watch employees

Triggers when a new employee is added or an existing employee is updated.

Xero

Watch purchase orders

Triggers when a new order is added or an existing order is updated.

Xero

Watch contacts

Triggers when a contact is created or updated.

Xero

Watch payments

Triggers when a payment is created or updated.

Actions

ABRA FlexiBee

Načíst detail záznamu

Načte detail záznamu ve zvolené evidenci dle zadaného identifikátoru.

ABRA FlexiBee

Nahrát přílohu

Nahraje přílohu ke zvolenému záznamu.

ABRA FlexiBee

Odemknout záznam

Odemkne konkrétní záznam ve zvolené evidenci.

ABRA FlexiBee

Přidat štítky

Přidá štítek ke zvolenému záznamu.

ABRA FlexiBee

Přidat záznam

Přidá nový záznam do zvolené evidence.

ABRA FlexiBee

Smazat záznam

Smaže konkrétní záznam ve zvolené evidenci.

ABRA FlexiBee

Storno záznamu

Stornuje konkrétní záznam ve zvolené evidenci. Lze použít pouze pro doklady.

ABRA FlexiBee

Upravit/vytvořit záznam

Upraví konkrétní záznam ve zvolené evidenci. Pokud záznam neexistuje, vytvoří ho.

ABRA FlexiBee

Upravit záznam

Upraví konkrétní záznam ve zvolené evidenci.

ABRA FlexiBee

Zamknout záznam

Uzamkne konkrétní záznam ve zvolené evidenci.

Placeholder

Get Placeholder

Returns an image in desired dimensions and with optional parameters.

Google Sheets

Add a Row

Appends a new row to the bottom of the table.

Google Sheets

Add a Sheet

Adds a new sheet.

Google Sheets

Clear a Cell

Cleares a specific cell.

Google Sheets

Clear a Row

Clears values from a specific row.

Google Sheets

Create a Spreadsheet

Creates a new spreadsheet.

Google Sheets

Delete a Row

Deletes a specific row.

Google Sheets

Get a Cell

Gets a specific cell.

Google Sheets

Perform a Function - Responder

Returns processed data as a result of the INTEGROMAT function. Sheets Add-On required.

Google Sheets

Update a Cell

Updates a specific cell.

Google Sheets

Update a Row

Updates a row.

Zoho Projects

Add Document

Adds a document in the folder.

Zoho Projects

Add Forum Category

Adds the forum category.

Zoho Projects

Create Bug

Creates a bug in the given project.

Zoho Projects

Create Event

Creates an event in the given project.

Zoho Projects

Create Forum

Creates a forum in the given project.

Zoho Projects

Create Milestone

Creates a new milestone in the given project.

Zoho Projects

Create Project

Creates a new project.

Zoho Projects

Create Subtask

Creates the subtask in the given project.

Zoho Projects

Create Task

Creates a new task in the given project.

Zoho Projects

Create Tasklist

Creates a new tasklist in the given project.

Zoho Projects

Create Time Log

Creates the time log to a task.

Zoho Projects

Delete Bug

Delete a bug in the given project.

Zoho Projects

Delete Document

Deletes the document.

Zoho Projects

Delete Event

Deletes an event in the given project.

Zoho Projects

Delete Forum

Deletes a forum in the given project.

Zoho Projects

Delete Milestone

Deletes the milestone in the given project.

Zoho Projects

Delete Project

Deletes the project.

Zoho Projects

Delete Task

Deletes the tasks in the given project.

Zoho Projects

Delete Tasklist

Deletes the tasklist in the given project.

Zoho Projects

Get Bug

Gets the details of the bug.

Zoho Projects

Get Document

Fetches the details of the document.

Zoho Projects

Get Forum

Gets the details of a forum.

Zoho Projects

Get Milestone

Gets all the details of the milestone.

Zoho Projects

Get Project

Lists all the details of the project.

Zoho Projects

Get Task

Gets all the details for the task.

Zoho Projects

Make an API Call

Performs an arbitrary authorized API call.

Zoho Projects

Reorder Task

Reorders the tasks in the given project.

Zoho Projects

Update Bug

Updates a bug in the given project.

Zoho Projects

Update Event

Update an event in the given project.

Zoho Projects

Update Forum

Updates a forum in the given project.

Zoho Projects

Update Milestone

Updates the milestone int the given project.

Zoho Projects

Update Project

Updates the project.

Zoho Projects

Update Task

Updates the task in the given project.

Zoho Projects

Update Tasklist

Updates the tasklist in the given project.

Xero

Create a receipt

Creates a new receipt.

Xero

Get a receipt

Returns information about a receipt with a given ID.

Xero

Create an invoice

Creates a new invoice.

Xero

Get an invoice

Returns information about an invoice with a given ID.

Xero

Create a credit note

Creates a new credit note.

Xero

Get a credit note

Returns information about a credit note with a specified ID.

Xero

Create a bank transaction

Creates a new bank transaction.

Xero

Get a bank transaction

Returns information about a transaction with a specified ID.

Xero

Create a bank transfer

Transfers a specified amount from one account to another.

Xero

Create an employee

Creates a new employee.

Xero

Create a purchase order

Creates a new purchase order.

Xero

Get a purchase order

Returns information about a purchase order with a specified ID.

Xero

Create a contact

Creates a new contact.

Xero

Update a contact

Updates a contact by ID.

Xero

Archive a contact

Archives a contact with a given ID.

Xero

Create a contact group

Creates a new contact group.

Xero

Add a contact to a contact group

Adds a contact to a specified contact group.

Xero

Remove a contact from a contact group

Removes a contact from a contact group.

Xero

Delete a contact group

Deletes a contact group with a specified ID.

Xero

Create a history note

Adds a note to a record.

Xero

Create an item

Creates a new item.

Xero

Get a contact

Retrieves contact information by ID.

Xero

Get an account

Returns information about an acccount with a specified ID.

Xero

Get an invoice URL

Retrieves Xero online invoice URL.

Xero

Get an item

Searches for an item by item ID or item code.

Xero

Get a payment

Retrieves information about a payment with a specified ID.

Xero

Get bank statements report

Returns bank statements for a selected bank account.

Xero

Get bank summary

Returns the balances and cash movements for each bank account.

Xero

Get history of changes

Retrieves the changes made to a given object.

Xero

Search for a contact

Searches for a contact by name or email.

Xero

Search for an account

Finds an account by ID, name, or code.

Xero

Search for an invoice

Searches for an invoice

Xero

Search for a tax rate

Finds a tax rate by name.

Xero

Send an invoice via email

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).

Xero

Update an employee

Updates an employee by ID.

Xero

Update an invoice

Updates an invoice with a given ID.

Xero

Update an item

Updates an item by ID.

Xero

Update a payment

Use this method to apply payments to approved AR and AP invoices or refund AR or AP credit notes.

Xero

Upload a file

Uploads a file to an invoice, receipt, contact or another item.

Microsoft SQL Server

Execute stored procedure

Iterators

Microsoft SQL Server

Iterate recordset

Iterates through received recordset.

Searches

ABRA FlexiBee

Hledat v evidenci

Načte záznamy ze zvolené evidence odpovídající zadaným kritériím.

ABRA FlexiBee

Načíst přílohy

Načte seznam všech příloh u zvoleného záznamu.

Google Sheets

Get Range Values

Gets a range content.

Google Sheets

Search Rows

Returns results matching the given criteria.

Google Sheets

Search Rows (Advanced)

Returns results matching the given criteria. This module doesn't return a row number.

Zoho Projects

List Bugs

Lists all the bugs in the given project.

Zoho Projects

List Documents

Lists all the documents in the given project.

Zoho Projects

List Events

Lists all the events in the given project.

Zoho Projects

List Forums

Lists all the forums in the given project.

Zoho Projects

List Milestones

Gets all the milestones in the given project.

Zoho Projects

List Project Activities

Lists all the recent activities of the project.

Zoho Projects

List Projects

Gets all the projects in the portal for the logged in user.

Zoho Projects

List Subtasks

Lists all the subtasks of the given task.

Zoho Projects

List Tasklists

Gets all the tasklists in the given project.

Zoho Projects

List Tasks

Gets all the tasks in the given project. It fetches only the main tasks and not the subtasks.

Zoho Projects

List Time Logs

Lists all the time logs in the given project.