+
DEAR Inventory integrations with Google Sheets

Use Zoho Flow to integrate DEAR Inventory with Google Sheets, in atleast 192 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

Sale shipment authorised

Triggers when shipment of a sale is authorised

Sale payment received

Triggers when the full payment for a sale is received

Sale undone

Triggers when a sale is undone

Sale back ordered

Triggers when a sale is back ordered

Supplier updated

Triggers when any detail of a supplier is updated

Stock level updated

Triggers when the level of a stock is updated

Sales order authorised

Triggers when a sales order is authorised

Sale pack authorised

Triggers when packing of a sale is authorised

Customer created or updated

Triggers when a customer is created or updated

Partial sale payment received

Triggers when partial payment for a sale is received

Purchase order authorised

Triggers when a purchase order is authorised

Sale shipment tracking number updated

Triggers when the shipment tracking number of a sale is updated

Sales invoice authorised

Triggers when a sales invoice is authorised

Purchase credit note authorised

Triggers when credit note for a purchase is authorised

Sale quote authorised

Triggers when a quote for a sale is authorised

Sale voided

Triggers when a sale is voided

Sale credit note authorised

Triggers when a credit note of a sale is authorised

Purchase invoice authorised

Triggers when a purchase invoice is authorised

Received purchase stock authorised

Triggers when a purchase stock received is authorised

Sale pick authorised

Triggers when picking of a sale is authorized

Worksheet created

Triggers when a new worksheet is created in the selected spreadsheet

Spreadsheet created

Triggers when a new spreadsheet is created

Row added - New version

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

Row added - Old version

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

Load More

All Actions - Action are the automated tasks

Create product

Creates a new product

Create supplier

Creates a new supplier

Create customer

Creates a new customer

Create sale

Creates a new sale

Create stock adjustment

Creates a new stock adjustment

Update supplier

Updates the details of a supplier

Update product

Updates the details of an existing product

Update customer

Updates the details of an existing customer

Fetch sale by search term

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

Fetch purchase by search term

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

Fetch customer by name

Fetches the details of an existing customer by name

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

Create spreadsheet

Creates a new spreadsheet

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 - New version

Fetches an existing row by the given value

Fetch row - Old version

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

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

Louis Castellano CEO, Lakeside CNC Group

“All the interactions, including customer relationship management, are automated and pre-determined in Zoho Flow. This allows our employees to concentrate on the tasks that are more important than the manual data input” Know more

Watch Zoho Flow in action