Find chemical products by IDs and adjust product quantities in WHS Monitor from new or updated Google Sheets rows
Do you want to keep the product quantity from your point of sales system to WHS Monitor product register up-to-date automatically? This integration can automatically add or deduct the quantity in your product register when a new transaction is recorded on Google Sheets.
Do you want to keep the product quantity from your point of sales system to WHS Monitor product register up-to-date automatically? This integration can automatically add or deduct the quantity in your product register when a new transaction is recorded on Google Sheets.
- When this happens...New or Updated Spreadsheet Row
Triggers when a new row is added or modified in a spreadsheet.
- automatically do this...Find a Chemical Product by Product ID
Find a chemical product by product ID
- then do this!Adjust Product Quantity
Adjust quantity for a product
- Free forever for core features
- 14 day trial for premium features & apps
Dont Change Sheet Structure
Drive
SpreadsheetRequired
WorksheetRequired
Try ItDrive
Try ItDont Change Sheet Structure
No Team Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItDrive
SpreadsheetRequired
WorksheetRequired
Column NameRequired
Index
Dont Change Sheet Structure
No Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItDont Change Sheet Structure
Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItDrive
SpreadsheetRequired
Try ItDrive
SpreadsheetRequired
WorksheetRequired
Use Timezone set up on the spreadsheet to format date values?