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
AUTOMATE
Automate redundant manual tasks and save your precious time and effort
ORCHESTRATE
Orchestrate your business process by integrating the apps you use efficiently
Explore prebuilt integration flows to get started
Store stock updates made in DEAR inventory in a Google Sheets spreadsheet
Use this flowDidn'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
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
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.
Start your 15 day free trial
Testimonial
“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
