# Using Google Scripts Webapp to get data from a Glide Webhook

**URL:** <https://community.glideapps.com/t/using-google-scripts-webapp-to-get-data-from-a-glide-webhook/65249>\
**Category:** Ask for Help\
**Created:** [August 21, 2023, 4:09pm UTC](https://community.glideapps.com/t/using-google-scripts-webapp-to-get-data-from-a-glide-webhook/65249 "2023-08-21T16:09:27Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Matty\_Fenny](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/matty_fenny/32/39419_2.png) [@Matty\_Fenny](https://community.glideapps.com/u/Matty_Fenny)\
**Post date:** [August 21, 2023, 4:09pm UTC](https://community.glideapps.com/t/using-google-scripts-webapp-to-get-data-from-a-glide-webhook/65249/1 "2023-08-21T16:09:27Z")

</div>

So I have a webapp in google scripts. I trigger it with a webhook from Glide.

I need to figure out how to get a value from the webhook.

So in the webapp, once the webhook is triggered, i need to get data from a cell called Job Number, figure out which row that is on, and do something with that row in the script.

What I have in the script:

const content = JSON.parse(e.postData.contents)  
const jobNo = content.params.jobNo.value;

let ss = SpreadsheetApp.getActiveSpreadsheet();  
let sheet = ss.getSheetByName(“Job Tab”);  
let sheetData = sheet.getDataRange().getValues;

I would then check for the row that jobNo is on, so then i could have:

let targetRow = …

It fails every time it runs and I have no idea why.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [August 22, 2023, 1:45am UTC](https://community.glideapps.com/t/using-google-scripts-webapp-to-get-data-from-a-glide-webhook/65249/2 "2023-08-22T01:45:55Z")

</div>

Is the reason you’re using an Apps Script webapp only because the data you need is stored on another Spreadsheet?