Google Sheets, Zoho Projects, QuickBooks Integrations

Google Sheets
Zoho Projects
QuickBooks
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

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.

QuickBooks

New event INSTANT

Triggers when a new event occurs (e.g. when a new invoice is issued).

Actions

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.

QuickBooks

Create a bill

Creates a new bill.

QuickBooks

Create a customer

Creates a new customer

QuickBooks

Create a journal entry

Creates a new journal entry.

QuickBooks

Create an estimate

Creates a new estimate.

QuickBooks

Create an invoice

Creates a new invoice.

QuickBooks

Create an item

Creates a new item.

QuickBooks

Create a note

Adds a note to a selected object.

QuickBooks

Create a payment

Creates a new payment.

QuickBooks

Create a sales receipt

Creates a new sales receipt.

QuickBooks

Create a vendor

Creates a new vendor.

QuickBooks

Delete a bill

Deletes a bill with the specified ID.

QuickBooks

Delete a journal entry

Deletes a journal entry with a given ID.

QuickBooks

Delete an attachment

Deletes an attachment with a given ID.

QuickBooks

Delete an estimate

Deletes an estimate with the specified ID.

QuickBooks

Delete an invoice

Deletes an invoice with the specified ID.

QuickBooks

Delete a payment

Deletes a payment by ID.

QuickBooks

Delete a sales receipt

Deletes a sales receipt by ID.

QuickBooks

Download a file

Download a file with a given attachment ID.

QuickBooks

Download an estimate

Downloads an estimate with the specified ID (as a pdf file).

QuickBooks

Download an invoice

Downloads an invoice with the specified ID (as a pdf file).

QuickBooks

Download a sales receipt

Downloads a sales receipt by ID (as a pdf file).

QuickBooks

Search for account

Searches for an account by ID, name or a custom query.

QuickBooks

Search for a journal entry

Searches for journal entries by ID or using a custom query.

QuickBooks

Search for an object

Searches for an object (invoice, customer, etc.) that matches your search criteria.

QuickBooks

Search for attachments

Finds attachments or notes that meet specified criteria.

QuickBooks

Search for bills

Searches for bills by ID, number, or using a custom query.

QuickBooks

Search for customers

Searches for customers by ID, name, email, or by using a custom query.

QuickBooks

Search for estimates

Searches for estimates by ID, number, or using a custom query.

QuickBooks

Search for invoices

Searches for invoices by ID, number, or using a custom query.

QuickBooks

Search for items

Searches for items by ID, name, or using a custom query.

QuickBooks

Search for payments

Searches for payments by ID or using a custom query.

QuickBooks

Search for sales receipts

Searches for sales receipts by ID, number or using a custom query.

QuickBooks

Search for vendors

Searches for vendors by ID, name or using a custom query.

QuickBooks

Send an estimate

Sends an estimate with the specified ID.

QuickBooks

Send an invoice

Sends an invoice with the specified ID.

QuickBooks

Send a sales receipt

Sends a sales receipt via email.

QuickBooks

Update a bill

Updates a bill with a given ID.

QuickBooks

Update a customer

Updates a customer by ID.

QuickBooks

Update a journal entry

Updates a journal entry with a given ID.

QuickBooks

Update an estimate

Updates an estimate with a given ID.

QuickBooks

Update an invoice

Updates an invoice by ID.

QuickBooks

Update an item

Updates an item by ID.

QuickBooks

Update a payment

Updates a payment by ID.

QuickBooks

Update a sales receipt

Updates a sales receipt by ID.

QuickBooks

Update a vendor

Updates a vendor with a given ID.

QuickBooks

Upload a file

Uploads a file to a selected object.

Searches

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.

Integrate Google Sheets, Zoho Projects, QuickBooks with these services