# How connect a webhook response direct with the column

**URL:** <https://community.glideapps.com/t/how-connect-a-webhook-response-direct-with-the-column/85358>\
**Category:** Ask for Help\
**Created:** [November 13, 2025, 11:15am UTC](https://community.glideapps.com/t/how-connect-a-webhook-response-direct-with-the-column/85358 "2025-11-13T11:15:08Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Joas\_MATOTO](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joas_matoto/32/83225_2.png) [@Joas\_MATOTO](https://community.glideapps.com/u/Joas_MATOTO)\
**Post date:** [November 13, 2025, 11:15am UTC](https://community.glideapps.com/t/how-connect-a-webhook-response-direct-with-the-column/85358/1 "2025-11-13T11:15:08Z")

</div>

Hi everyone 👋

I’m working on a Glide app and I’m receiving JSON data from a webhook (triggered by Google Apps Script). The payload looks like this:

json

```auto
{
  "email_id": "E-12345",
  "message_id": "12345",
  "thread_id": "abcd",
  "from": "user@example.com",
  "to": "support@myapp.com",
  "cc": "cc@example.com",
  "subject": "Test email",
  "body": "Hello this is a test",
  "attachments": ["https://example.com/file1.png"],
  "received_at": "2025-11-13T09:00:00Z",
  "linked_client": "user@example.com",
  "conversation_key": "user@example.com → support@myapp.com",
  "is_reply": false,
  "visibility": true,
  "read": false,
  "last_activity": "2025-11-13T09:00:00Z"
}

```

I’d like to take this JSON and automatically map each field to its corresponding column in a Glide Big Table (not Google Sheets). I’m a bit stuck on how to handle this part — especially how to parse the response and push it directly into the table.

Has anyone done something similar or can point me in the right direction?

Thanks in advance!

 ![Capture d'écran 2025-11-13 102522](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/e/8ea67f5345b9d662e67b71324464b13de995ec9d.png)

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [November 13, 2025, 11:36am UTC](https://community.glideapps.com/t/how-connect-a-webhook-response-direct-with-the-column/85358/2 "2025-11-13T11:36:41Z")

</div>

Inside your workflow, you need a Query JSON step for each data attribute you want to extract from the JSON. Then use those in an Add Row step.

---

<div class="post-metadata">

**Author:** ![Joas\_MATOTO](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joas_matoto/32/83225_2.png) [@Joas\_MATOTO](https://community.glideapps.com/u/Joas_MATOTO)\
**Post date:** [November 13, 2025, 2:11pm UTC](https://community.glideapps.com/t/how-connect-a-webhook-response-direct-with-the-column/85358/3 "2025-11-13T14:11:04Z")

</div>

![Capture d'écran 2025-11-13 150913](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/a/eaa4b6931ce5e1932ead5aa9e2de43e418a1f096.png)  
I don’t understand what you mentioned above! how to perform that task? because i’m just using app script that is sending data to glide via the webhook.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [November 13, 2025, 2:43pm UTC](https://community.glideapps.com/t/how-connect-a-webhook-response-direct-with-the-column/85358/4 "2025-11-13T14:43:59Z")

</div>

The Query JSON step should target the trigger request body, like below:

 ![CleanShot 2025-11-13 at 22.41.01@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/9/f9a0ea4b1e515fca0a84c95640f32f426c1dfd2e.png)

In the JSON field of the Query JSON, you should add the attribute key, eg. `email_id`  
Then as I said, you will need a separate Query JSON step for each attribute.  
Then finally, the Add Row step.