Integrate Zoho Sheet with DEAR Inventory

Send information between Zoho Sheet and DEAR Inventory automatically, without writing any code, using Zoho Flow.

Explore prebuilt integration flows to get started

[esc]

Add the transaction details of new sales authorized in Dear Inventory to Zoho Sheet via MadKudo

Add the transaction details of authorized sales in your inventory management app into a spreadsheet. This flow adds the transaction details of new sales authorized in Dear Inventory to a Zoho Sheet spreadsheet via MadKudo.

How it works
1. A new sale is authorized in Dear Inventory.
2. Zoho Flow adds the transaction details to a Zoho Sheet spreadsheet via MadKudo.
Use this flow
+
+

Add the transaction details of new sales authorized in Dear Inventory to Zoho Sheet via MadKudo

DEAR Inventory + MadKudu + Zoho Sheet

Build your own integrations between Zoho Sheet and DEAR Inventory

Connect Zoho Sheet and DEAR Inventory with over 900+ apps and build your own integrations using our no-code drag and drop builder and comprehensive workflow elements

Supported triggers and actions

Integrate Zoho Sheet and DEAR Inventory using the below triggers and actions

All Triggers - A trigger kickstarts the flow

Spreadsheet created

Triggers when a new spreadsheet is created

Row updated in a column

Triggers when a row is updated in a column

Worksheet created

Triggers when a new worksheet is created in the selected spreadsheet

Row created - WorkDrive

Triggers when a new row is created in a spreadsheet stored in Zoho WorkDrive

Worksheet created - WorkDrive

Triggers when a new worksheet is created in WorkDrive

Row created or updated

Triggers when a row is added or updated in the selected worksheet

Row created or updated - WorkDrive

Triggers when a row is created or updated in a spreadsheet stored in Zoho WorkDrive

Row created

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

Row updated in a column range

Triggers when a row is updated in a column range

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

All Actions - Actions are the automated tasks

Create row

Creates a new row in the selected worksheet

Create worksheet - WorkDrive

Creates a new worksheet in Zoho WorkDrive

Create spreadsheet

Creates a new spreadsheet

Create worksheet

Creates a new worksheet in the selected spreadsheet

Create row - WorkDrive

Creates a row in a spreadsheet stored in Zoho WorkDrive

Create workbook from template

Creates a new workbook from an existing template

Update row - WorkDrive

Updates a row in a spreadsheet stored in Zoho WorkDrive

Update row

Updates a specified row in the selected worksheet

Delete row

Deletes the specified row in a worksheet

Delete row - WorkDrive

Deletes a row in a spreadsheet stored in Zoho WorkDrive

Fetch row

Fetches a row by column value

Fetch row - WorkDrive

Fetches a row from a spreadsheet stored in Zoho WorkDrive

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

What is Zoho Sheet?

Zoho Sheet is an online spreadsheet application that lets you create, share, collaborate, and publish spreadsheets from anywhere. You can control access to your sheets, change language preferences, and add visuals to represent your data better.

Popular Spreadsheet Zoho

What is DEAR Inventory?

DEAR Inventory is inventory management software that helps you manage your inventory, purchases, sales, suppliers, and customers in one easy-to-use system.

Build comprehensive workflows using

Webhook triggers

Receive your data from a wider range of services in multiple formats, like JSON, form data, and plain text.

Learn more >

Logic

Create customized business workflows by including advanced logic elements like if-then branches, time delays, and more.

Learn more >

Custom functions

Write simple scripting functions to format data, call web APIs, send emails, and more.

Learn more >

Zoho Flow was the deal-maker for the whole Zoho platform. For everyone who wants to use more than one Zoho app, Zoho Flow is a must. Learn more

Louis Castellano

CEO, Lakeside CNC Group

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.

Neville Mader

Director, Perth Security Services

We use Zoho Flow to connect Zoho Subscriptions with JotForm. As our customers fill their preferences in JotForm, Zoho Flow passes it to Zoho Subscriptions and creates a subscription automatically. It was impressive that we were able to configure all this on a simple drag-and-drop interface!

Josh Lucas

Head of Operations, AAA Band Rentals

Watch Zoho Flow in action

Play video

Endless integrations. End to manual work.

SIGN UP TODAY