Shopify product creation > Google sheets

[oli_Fowler]

Hi there! im new here and ive been going down a rabbit hole for 1 week with shopify and google sheets automation, im going slightly mad cause i cant work it out - I’d like to be able to create a product on shopify and have data sent to google sheets and then I’d like to be able to update that product, especially inventory levels via google sheet - my question is is this possible? and most importantly am I going about it in the right way? Is there a better way of doing it…I wanted to see what you all thought - any help would be greatly appreciated, i just cant work it out