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
Add the transaction details of new sales authorized in Dear Inventory to Zoho Sheet via MadKudo
How it works
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
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
Row created
Triggers when a new row is added at the bottom of the selected worksheet
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
Worksheet created - WorkDrive
Triggers when a new worksheet is created in WorkDrive
Spreadsheet created
Triggers when a new spreadsheet is created
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 worksheet
Creates a new worksheet in the selected spreadsheet
Create row
Creates a new row in the selected worksheet
Create worksheet - WorkDrive
Creates a new worksheet in Zoho WorkDrive
Create row - WorkDrive
Creates a row in a spreadsheet stored in Zoho WorkDrive
Create spreadsheet
Creates a new spreadsheet
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 - WorkDrive
Deletes a row in a spreadsheet stored in Zoho WorkDrive
Delete row
Deletes the specified row in a worksheet
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.
Similar apps
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.
Similar apps
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 >It is amazing what processes can be automated [with Zoho Flow]. It can be difficult to visualize what can be done. Ask the experts at Zoho Flow, they can tell you straight away and if it needs customization they will help you build it! Learn more
Owain ap Rees
Sales Director, Artico
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
With Zoho Flow, we've transformed our feedback process. Automating the creation of tickets in Zoho Desk based on responses from our feedback forms has significantly improved our customer support. The integration with Google Sheets and Zoho Campaigns has also streamlined our communication and marketing efforts. Learn more
Toto
Technical Engineer, Master Liveaboards
