Magento 2, Google Sheets, QuickBooks Time Integrations

Google Sheets
Magento 2
QuickBooks Time
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

Magento 2

Watch customers

Triggers when a new customer is created.

Magento 2

Watch orders

Triggers when a new order is created.

Magento 2

Watch products

Triggers when a new product is created.

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.

QuickBooks Time

Watch Files

Triggers when a new file is attached to a timesheet.

QuickBooks Time

Watch Reminders

Triggers when a new reminder is created or updated.

QuickBooks Time

Watch Timesheets

Triggers when a timesheet is created and updated.

Actions

Magento 2

Create a customer

Creates a new customer.

Magento 2

Create a product

Creates a new product.

Magento 2

Delete a customer

Deletes a customer by customer id.

Magento 2

Delete a product

Deletes a product by product SKU.

Magento 2

Get a customer

Gets a customer detail by customer id.

Magento 2

Get an order

Gets an order by order id.

Magento 2

Get a product

Gets an info about product by product SKU.

Magento 2

Get order status

Checks the status of an order

Magento 2

Invoice an order

Creates a new invoice for an order

Magento 2

Make an API Call

Performs an arbitrary authorized API call.

Magento 2

Ship an order

Creates new Shipment for given Order.

Magento 2

Update a customer

Updates a customer by customer id.

Magento 2

Update a product

Updates a product by product SKU.

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

Delete a Sheet

Deletes a specific sheet.

Google Sheets

Get a Cell

Gets a specific cell.

Google Sheets

Make an API Call

Performs an arbitrary authorized API call.

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.

QuickBooks Time

Create a Group

Creates a group to your company.

QuickBooks Time

Create a Job/Customer

Adds a job or customer to your company.

QuickBooks Time

Create an Invitation

Creates an invitation for new users to join your company.

QuickBooks Time

Create a Notification

Creates/Adds a notification.

QuickBooks Time

Create a Reminder

Creates user-specific clock-in and clock-out reminders for a user.

QuickBooks Time

Create a Timesheet

Adds a timesheet to your company.

QuickBooks Time

Create a User

Adds users to your company.

QuickBooks Time

Delete a File

Deletes a file.

QuickBooks Time

Delete a Notification

Deletes a notification in your company.

QuickBooks Time

Delete a Timesheet

Deletes a timesheet.

QuickBooks Time

Download a File

Downloads a file.

QuickBooks Time

Get a Job/Customer

Returns the data of a specified job or customer.

QuickBooks Time

Get a Timesheet

Returns the data of a specified timesheet.

QuickBooks Time

Get a User

Returns the data of a specified user.

QuickBooks Time

Make an API Call

Performs an arbitrary authorized API call.

QuickBooks Time

Update a File

Updates a file that is attached to an object.

QuickBooks Time

Update a Group

Updates a group in your company.

QuickBooks Time

Update a Job/Customer

Updates a job or customer.

QuickBooks Time

Update a Reminder

Updates a reminder for employees within your company.

QuickBooks Time

Update a Timesheet

Updates a timesheet.

QuickBooks Time

Update a User

Updates a user.

Searches

Magento 2

Find Customers

Retrieves a list of customers based on search criteria.

Magento 2

Find Orders

Retrieves a list of orders based on search criteria.

Magento 2

Find Products

Retrieves a list of products based on search criteria.

Google Sheets

Get Range Values

Gets a range content.

Google Sheets

List Sheets

Gets a list of all sheets in a spreadsheet.

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.

QuickBooks Time

List Files

Retrieves a list of all uploaded files.

QuickBooks Time

List Groups

Retrieves a list of all active groups.

QuickBooks Time

List Jobs/Customers

Retrieves a list of all active top-level jobs or customers.

QuickBooks Time

List Managed Clients

Retrieves a list of managed clients available from your account.

QuickBooks Time

List Notifications

Retrieves a list of notifications associated with your company.

QuickBooks Time

List Reminders

Retrieves clock-in and clock-out reminders for a user.

QuickBooks Time

List Timesheets

Retrieves a list of timesheets for a specified timeframe.

QuickBooks Time

List Users

Retrieves a list of all active users.