How connect a webhook response direct with the column

[Joas_MATOTO]

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

{
  "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!

[Darren_Murphy]

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.

[Joas_MATOTO]

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.

[Darren_Murphy]

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

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.