# Parsing webhook header info from Discourse into Google Sheets

**URL:** https://meta.discourse.org/t/parsing-webhook-header-info-from-discourse-into-google-sheets/151172
**Category:** Development
**Created:** [12 mei 2020 om 12:00 UTC](https://meta.discourse.org/t/parsing-webhook-header-info-from-discourse-into-google-sheets/151172 "2020-05-12T12:00:53Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Conor\_McCarthy](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/conor_mccarthy/32/180128_2.png) [@Conor\_McCarthy](https://meta.discourse.org/u/Conor_McCarthy)
#### Post date: [12 mei 2020 om 12:00 UTC](https://meta.discourse.org/t/parsing-webhook-header-info-from-discourse-into-google-sheets/151172/1 "2020-05-12T12:00:54Z")

</div>

Hi,

I have a Discourse webhook pointing to a Google apps script that writes the data to a spreadsheet. What I cant seem to fin is how to get the _header_ information for that webhook event in my google apps script e.g. X-Discourse-Instance:

All suggestions welcome!

Conor

---

<div class="post-metadata">

### Author: ![Krischan](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/krischan/32/47290_2.png) [@Krischan](https://meta.discourse.org/u/Krischan)
#### Post date: [12 mei 2020 om 12:22 UTC](https://meta.discourse.org/t/parsing-webhook-header-info-from-discourse-into-google-sheets/151172/2 "2020-05-12T12:22:00Z")

</div>

Maybe a bit of a stretch, but you could take a detour via Zapier and parse the raw hook:

> **[Updates for Webhooks: Catch Raw Hooks and Pass Them Along to Your Other Apps](https://zapier.com/blog/updates/1113/webhooks-catch-raw-hooks)**
>
> Thanks to recent updates to Webhooks by Zapier, you can now access the entire raw JSON payload with the new Catch Raw Hook Trigger. Instead of rebuilding the payload by mapping fields in the next steps of your Zap, save time by passing the entire...

---

<div class="post-metadata">

### Author: ![Conor\_McCarthy](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/conor_mccarthy/32/180128_2.png) [@Conor\_McCarthy](https://meta.discourse.org/u/Conor_McCarthy)
#### Post date: [12 mei 2020 om 13:16 UTC](https://meta.discourse.org/t/parsing-webhook-header-info-from-discourse-into-google-sheets/151172/3 "2020-05-12T13:16:13Z")

</div>

Thanks for getting back to me @Krischan

Yes I was using Zapier and felt that I could achieve the same with a webhook. I have recreated all of the Zapier functionality so far…apart from this one key!

Any other suggestions?

Thanks!