Updating Shopify Inventory (and by extension Products) via Google Sheet PUT Request

Hello Community,

We are trying to use a Google Sheet (via Google Script) to update 900+ SKUs (all with their unique variant_ID) using following this documentation: https://shopify.dev/api/admin-rest/2021-10/resources/inventorylevel#top

However, we can’t seem to get it work. This is the JSON string we want to pass through. Help please!

“product”: {

“id”: “XXXXXXXXXXXXX”,

“variants”: [

{

“id”: “XXXXXXXXXXXX”,

“inventory_quantity”: 100,

“amount”: 3.15,

“published_scope”: “web”