Use Zoho Flow to integrate DEAR Inventory with Google Sheets, in atleast 220 different ways, without writing code. Automate any tasks that keep you away from what you do best.

CONNECT

Connect your apps and move data seamlessly

Connect

AUTOMATE

Automate redundant manual tasks and save your precious time and effort

Automate

ORCHESTRATE

Orchestrate your business process by integrating the apps you use efficiently

Orchestrate

Explore prebuilt integration flows to get started

Store stock updates made in DEAR inventory in a Google Sheets spreadsheet

Use this flow
Load More

Didn't find the integration you are looking for? Create one yourself.

All Triggers - A trigger kickstarts the flow

Purchase order authorised

Triggers when a purchase order is authorised

Sale quote authorised

Triggers when a quote for a sale is authorised

Customer created or updated

Triggers when a customer is created or updated

Sales invoice authorised

Triggers when a sales invoice is authorised

Sales order authorised

Triggers when a sales order is authorised

Sale undone

Triggers when a sale is undone

Sale back ordered

Triggers when a sale is back ordered

Sale payment received

Triggers when the full payment for a sale is received

Purchase invoice authorised

Triggers when a purchase invoice is authorised

Supplier updated

Triggers when any detail of a supplier is updated

Sale shipment tracking number updated

Triggers when the shipment tracking number of a sale is updated

Sale pick authorised

Triggers when picking of a sale is authorized

Sale shipment authorised

Triggers when shipment of a sale is authorised

Purchase credit note authorised

Triggers when credit note for a purchase is authorised

Sale voided

Triggers when a sale is voided

Partial sale payment received

Triggers when partial payment for a sale is received

Received purchase stock authorised

Triggers when a purchase stock received is authorised

Stock level updated

Triggers when the level of a stock is updated

Sale credit note authorised

Triggers when a credit note of a sale is authorised

Sale pack authorised

Triggers when packing of a sale is authorised

Row added - New version

Triggers when a new row is added to the bottom of the selected worksheet

Spreadsheet created

Triggers when a new spreadsheet is created

Row added - Old version

Triggers when a new row is added to the bottom of the selected worksheet. (Will be deprecated soon)

Worksheet created

Triggers when a new worksheet is created in the selected spreadsheet

Load More

All Actions - Action are the automated tasks

Create sale

Creates a new sale

Create stock adjustment

Creates a new stock adjustment

Create supplier

Creates a new supplier

Add contact to customer

Adds a new contact to an existing customer

Create customer

Creates a new customer

Add address to customer

Adds a new address to an existing customer

Create product

Creates a new product

Update supplier

Updates the details of a supplier

Update product

Updates the details of an existing product

Update customer address

Updates the details of an existing customer address

Update customer

Updates the details of an existing customer

Update customer contact

Updates the details of an existing customer contact

Fetch purchase by search term

Fetches the details of an existing purchase by order number, invoice number, or credit note number

Fetch sale shipment

Fetches the details of an existing sale shipment by order number, invoice number, or credit note number.

Fetch production by search term

Fetches the details of an existing production by product code, product name, or production order number.

Fetch customer by name

Fetches the details of an existing customer by name

Fetch sale by search term

Fetches the details of a sale by order number, invoice number, or credit note number

Fetch opportunity

Fetches the details of an existing opportunity by opportunity ID

Fetch product by SKU or name

Fetches the details of an existing product by its SKU or name or both

Fetch supplier by name

Fetches the details of an existing supplier by name

Create spreadsheet

Creates a new spreadsheet

Create row - Old version

Creates a new row in the selected worksheet. (Will be deprecated soon)

Create row - New version

Creates a new row in the selected worksheet

Update row - Old version

Updates the specified row in the selected worksheet. (Will be deprecated soon)

Update row - New version

Updates the specified row in the selected worksheet

Fetch row - Old version

Fetches an existing row by the given value. (Will be deprecated soon)

Fetch row - New version

Fetches an existing row by the given value

Load More

What is Zoho Flow?

Zoho Flow is an integration platform that helps you connect your apps without any code. Automate complex business workflows within minutes. Set a trigger, add actions, use Delays and Decisions to create your entire workflow on an easy to use builder.

Testimonial

Neville MaderDirector, Perth Security Services

“Zoho Flow has automated our entire "Security Operations" process, saving us a lot of manual work and admin overhead, in turn enabling us to focus our efforts on providing clients with accurate and quality services.”

Watch Zoho Flow in action