Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Hi community,

 

we are trying to build a really simple inventory management system within a Google Sheet.

 

Whenever a new row in another spreadsheet (“Orders”) is created, the number in a cell of another spreadsheet (“Inventory”) needs to decrease by 1.

 

Example:

  1. I add a new order manually to the spreadsheet “Orders”
  2. The according number in the spreadsheet “Inventory” for the product goes from 5 to 4

 

Any tips how to achieve this workflow?

 

Thanks, 

Chris

Probably easiest to use a GSheets formula.

COUNTA: https://support.google.com/docs/answer/3093991?hl=en

May depend on how you have your GSheet inventory tab structured.

Otherwise, if you want to use Zapier, then do these actions

 

Action: GSheet - Lookup Row

Action: GSheet - Update Row

Hi @snowwhite 

Just checking in. Were you able to get this sorted?

Terms & Conditions