To get it to sync, I recommend you try this tutorial:
Then you update the spreadsheet manually. I would make the key in the spread sheet the date and make the value equal to what item are in the shop.