Automatically update XL file in parallel to emails

I’m selling products in few market places, once I get an email from a market place that says that I sold a product, I want my XL file which sits in my google drive to be update ( stock count down in the specific product that sold ) and mark there as sold .