# Updating data on a list from a Google Spreadsheet (that is reqularly updated)

**URL:** <https://community.blaze.today/t/updating-data-on-a-list-from-a-google-spreadsheet-that-is-reqularly-updated/20944>\
**Category:** Questions and Help\
**Created:** [July 18, 2022, 9:31am UTC](https://community.blaze.today/t/updating-data-on-a-list-from-a-google-spreadsheet-that-is-reqularly-updated/20944 "2022-07-18T09:31:39Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![George\_Marinos](https://community.blaze.today/user_avatar/community.blaze.today/george_marinos/32/124_2.png) [@George\_Marinos](https://community.blaze.today/u/George_Marinos)\
**Post date:** [July 18, 2022, 9:31am UTC](https://community.blaze.today/t/updating-data-on-a-list-from-a-google-spreadsheet-that-is-reqularly-updated/20944/1 "2022-07-18T09:31:39Z")

</div>

[https://dashboard.blaze.today/snippet/OFvEHes81d1O2l0oYzpD](https://dashboard.blaze.today/snippet/OFvEHes81d1O2l0oYzpD)  
In the above snippet there is a long list of doctor's names with the suburb of practice and their unique ID Provider number (unique for name & location - provided by Govt body).

My issue is that the doctor list (name - suburb - Provider number) is ever changing and constantly needs updating. The data in the list "dr\_list" is alphabetised according to surname. It is very long and very clumsy to update.

I was wondering if the data in the list "dr\_list" can be tabulated in a Google Spreadsheet from where alterations can be easily made and automatically updated into the snippet? Hope this is clear?

Regards  
George Marinos

---

<div class="post-metadata">

**Author:** ![Cedric\_Debono\_Blaze](https://community.blaze.today/user_avatar/community.blaze.today/cedric_debono_blaze/32/1672_2.png) [@Cedric\_Debono\_Blaze](https://community.blaze.today/u/Cedric_Debono_Blaze)\
**Post date:** [July 18, 2022, 10:56am UTC](https://community.blaze.today/t/updating-data-on-a-list-from-a-google-spreadsheet-that-is-reqularly-updated/20944/2 "2022-07-18T10:56:37Z")

</div>

Hi @George_Marinos

Would something like the examply in this thread work?

> [@Extract data from a published google spreadsheet](https://community.blaze.today/t/extract-data-from-a-published-google-spreadsheet/11915):
>
> Extract data from a published google spreadsheet and use the values in the first column in a dropdown menu to look up the other values in the row. {note} This is the original spreadsheet: [public testing - DO NOT DELETE - Google Sheets](https://docs.google.com/spreadsheets/d/1XRXbi-zHIMD3Mg787Um5Pf_3koox6_66VS8OB6XIfHM/edit?usp=sharing) {urlload: [https://docs.google.com/spreadsheets/d/e/2PACX-1vRg1Cge8IQ6FgknYMrU6ZRRL42JLsHWwNsX5BYWM-r2PnfaN7utkbf\_O-VYO9lUpJa0UvNmS8gYaLfi/pub?output=csv;](https://docs.google.com/spreadsheets/d/e/2PACX-1vRg1Cge8IQ6FgknYMrU6ZRRL42JLsHWwNsX5BYWM-r2PnfaN7utkbf_O-VYO9lUpJa0UvNmS8gYaLfi/pub?output=csv;) done=(res) -\> ["csv"=res]} {endnote: trim=right} {if: iserror(csv)}Loading{else}{rows=slice(map(split(cs…

---

<div class="post-metadata">

**Author:** ![George\_Marinos](https://community.blaze.today/user_avatar/community.blaze.today/george_marinos/32/124_2.png) [@George\_Marinos](https://community.blaze.today/u/George_Marinos)\
**Post date:** [July 19, 2022, 2:26pm UTC](https://community.blaze.today/t/updating-data-on-a-list-from-a-google-spreadsheet-that-is-reqularly-updated/20944/3 "2022-07-19T14:26:33Z")

</div>

Thanks Cedric,  
This works extremely well. Perfect solution. Great tool.

Thank you.  
George

---

<div class="post-metadata">

**Author:** ![Cedric\_Debono\_Blaze](https://community.blaze.today/user_avatar/community.blaze.today/cedric_debono_blaze/32/1672_2.png) [@Cedric\_Debono\_Blaze](https://community.blaze.today/u/Cedric_Debono_Blaze)\
**Post date:** [July 21, 2022, 8:06am UTC](https://community.blaze.today/t/updating-data-on-a-list-from-a-google-spreadsheet-that-is-reqularly-updated/20944/4 "2022-07-21T08:06:48Z")

</div>

@George_Marinos - you're most welcome 🙂