# Howto: Use Google Sheets as fronted for Lookup Table Editing

**URL:** <https://community.graylog.org/t/howto-use-google-sheets-as-fronted-for-lookup-table-editing/19665>\
**Category:** Graylog Central (peer support)\
**Created:** [April 29, 2021, 12:16pm UTC](https://community.graylog.org/t/howto-use-google-sheets-as-fronted-for-lookup-table-editing/19665 "2021-04-29T12:16:12Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![jan](https://sea2.discourse-cdn.com/flex016/user_avatar/community.graylog.org/jan/32/11_2.png) [@jan](https://community.graylog.org/u/jan)\
**Post date:** [April 29, 2021, 12:16pm UTC](https://community.graylog.org/t/howto-use-google-sheets-as-fronted-for-lookup-table-editing/19665/1 "2021-04-29T12:16:12Z")

</div>

Many people wonder how you could easily edit Lookup Table content by non-tech people and keep the process of updating and shipping that to Graylog as low as possible.

I have seen people writings scripts or automation doing this what adds another moving wheel to the setup and it can be a burden. Many already use Google Sheets or similar - why not try to use that direct?

In short - you can use the export CSV URL from a shared Google Sheet as source for a DSV Lookup:

 ![image](https://us1.discourse-cdn.com/flex016/uploads/graylog/original/2X/9/922a49b3347ebd78cce73b213d40cd26401ca620.jpeg)

When you share “read-only” for people having access to the link it is kind of secure - maybe not for SOC2 but for your SOHO/Home Setup that should be enough.

This way you can edit Lookup table content from within a Google Sheet.

Happy Hacking  
Jan

---

<div class="post-metadata">

**Author:** ![reimlima](https://sea2.discourse-cdn.com/flex016/user_avatar/community.graylog.org/reimlima/32/16254_2.png) [@reimlima](https://community.graylog.org/u/reimlima)\
**Post date:** [April 29, 2021, 1:05pm UTC](https://community.graylog.org/t/howto-use-google-sheets-as-fronted-for-lookup-table-editing/19665/2 "2021-04-29T13:05:35Z")

</div>

This could easily become an wiki page.

“Wiki session” is empty and I think it’s a good way to avoid people to open New Topics over and over about the same thing.

I can help create wiki pages with “troubleshoot things”, I’m pretty sure other will do as well.

What you guys think about that?

---

<div class="post-metadata">

**Author:** ![gsmith](https://sea2.discourse-cdn.com/flex016/user_avatar/community.graylog.org/gsmith/32/1222_2.png) [@gsmith](https://community.graylog.org/u/gsmith)\
**Post date:** [April 30, 2021, 1:07am UTC](https://community.graylog.org/t/howto-use-google-sheets-as-fronted-for-lookup-table-editing/19665/3 "2021-04-30T01:07:39Z")

</div>

@jan  
Nice, Thanks for sharing.

---

<div class="post-metadata">

**Author:** ![jan](https://sea2.discourse-cdn.com/flex016/user_avatar/community.graylog.org/jan/32/11_2.png) [@jan](https://community.graylog.org/u/jan)\
**Post date:** [May 10, 2021, 10:44am UTC](https://community.graylog.org/t/howto-use-google-sheets-as-fronted-for-lookup-table-editing/19665/4 "2021-05-10T10:44:54Z")

</div>

Just for the complete circle.

Use the URL from the first reply from here: [Download-Link für den CSV-Export von Google Spreadsheets - mit mehreren Blättern](https://qastack.com.de/programming/33713084/download-link-for-google-spreadsheets-csv-export-with-multiple-sheets). For those not able to read:

```auto
https://docs.google.com/spreadsheets/d/{key}/gviz/tq?tqx=out:csv&sheet={sheet_name}

```

In the linked Document you can see the different options as you can also run queries, remove headers and multiple more.

Do not forget to use Caching in Graylog if you use this Lookup Table in Graylog for all messages, or Google will block your Graylog from accessing this cause of a detected DDOS … (i just experienced this so, create at least a node based caching for this).

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex016/uploads/graylog/original/3X/c/7/c7c09c6b5099570133d6502b83f50ba4430de5b6.png) [@system](https://community.graylog.org/u/system)\
**Post date:** [May 24, 2021, 10:45am UTC](https://community.graylog.org/t/howto-use-google-sheets-as-fronted-for-lookup-table-editing/19665/5 "2021-05-24T10:45:02Z")

</div>

Closed on May 24, 2021, 10:45am UTC

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.
