show data from webhook in google sheets
Budget: £10 – £20 GBP
we are receiving data from API -
[{"number":"+42452555210","message":"Freddy","deviceID":1,"simSlot":0,"schedule":null,"userID":1,"groupID":null,"status":"Received","resultCode":null,"errorCode":null,"type":null,"attachments":null,"prioritize":null,"retries":null,"sentDate":"2022-04-29T14:11:23+0000","deliveredDate":"2022-04-29T14:11:28+0000","expiryDate":null,"ID":106}]
we want to store the data in google sheets under each separate column using google scripts.
[{"number":"+42452555210","message":"Freddy","deviceID":1,"simSlot":0,"schedule":null,"userID":1,"groupID":null,"status":"Received","resultCode":null,"errorCode":null,"type":null,"attachments":null,"prioritize":null,"retries":null,"sentDate":"2022-04-29T14:11:23+0000","deliveredDate":"2022-04-29T14:11:28+0000","expiryDate":null,"ID":106}]
we want to store the data in google sheets under each separate column using google scripts.