Integrate DEAR Inventory with Google Sheets
Send information between DEAR Inventory and Google Sheets automatically, without writing any code, using Zoho Flow.
Explore prebuilt integration flows to get started
Store stock updates made in DEAR inventory in a Google Sheets spreadsheet
How it works
Store stock updates made in DEAR inventory in a Google Sheets spreadsheet
DEAR Inventory + Google Sheets
Build your own integrations between DEAR Inventory and Google Sheets
Connect DEAR Inventory and Google Sheets 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 DEAR Inventory and Google Sheets using the below triggers and actions
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 - 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
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
All Actions - Actions 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 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.
What is Google Sheets?
Google Sheets lets you create and edit spreadsheets online. You can collaborate with others, define formulas, and create graphs and charts easily.
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 >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
Zoho Flow has helped us add a new sales channel. It has helped us integrate our existing and new sales channels, and manage our inventory in real time. Learn more
Siddharth Ahuja
CEO, Fabricroot
Zoho Flow has revolutionized our integration process, allowing us to transfer data seamlessly across multiple platforms without the need for coding. It has eliminated tedious and time-consuming tasks, making our workflow more efficient and saving us valuable time and effort. Zoho Flow is a game-changer for us, and I highly recommend it to anyone looking to streamline their business processes. Learn more
Toto
Technical Engineer, Master Liveaboards
