Integrate Google Sheets with DEAR Inventory
Send information between Google Sheets and DEAR Inventory 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 Google Sheets and DEAR Inventory
Connect Google Sheets 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 Google Sheets and DEAR Inventory using the below triggers and actions
All Triggers - A trigger kickstarts the flow
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
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 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
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 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
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 >Zoho Flow is an easy-to-use, very intuitive, and comprehensive integration platform. It helped us integrate Zoho Workplace with WordPress without writing a single line of code. Now, we do not miss Slack anymore, thanks to Zoho Flow and Zoho Workplace. Learn more
Rahul Roushan
CEO, OpIndia
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 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
