# Update Glide Table with text scraped from tables on external web pages

**URL:** <https://community.glideapps.com/t/update-glide-table-with-text-scraped-from-tables-on-external-web-pages/70436>\
**Category:** Ask for Help\
**Created:** [February 2, 2024, 9:18pm UTC](https://community.glideapps.com/t/update-glide-table-with-text-scraped-from-tables-on-external-web-pages/70436 "2024-02-02T21:18:44Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![coastal](https://avatars.discourse-cdn.com/v4/letter/c/94ad74/32.png) [@coastal](https://community.glideapps.com/u/coastal)\
**Post date:** [February 2, 2024, 9:18pm UTC](https://community.glideapps.com/t/update-glide-table-with-text-scraped-from-tables-on-external-web-pages/70436/1 "2024-02-02T21:18:44Z")

</div>

I have a Glide Table with data that I entered manually. It has 13 columns. Three of the columns contain text that was compiled from tables on various pages of an external website. I am trying to figure out if there is any way to automatically update the cells in those 3 columns automatically if the text in the corresponding web page tables is updated. I imagine this would involve some type of scraping tool. I have never done this before. Is this possible? Any ideas about how?

---

<div class="post-metadata">

**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\
**Post date:** [February 2, 2024, 9:30pm UTC](https://community.glideapps.com/t/update-glide-table-with-text-scraped-from-tables-on-external-web-pages/70436/2 "2024-02-02T21:30:53Z")

</div>

Use the Browser integration to get the text, then split it out. Glide AI is very good at splitting out the important info.

---

<div class="post-metadata">

**Author:** ![coastal](https://avatars.discourse-cdn.com/v4/letter/c/94ad74/32.png) [@coastal](https://community.glideapps.com/u/coastal)\
**Post date:** [February 2, 2024, 10:02pm UTC](https://community.glideapps.com/t/update-glide-table-with-text-scraped-from-tables-on-external-web-pages/70436/3 "2024-02-02T22:02:23Z")

</div>

Thanks @david. I’m new to Glide and definitely appreciate getting a response from the CEO!

Could you tell me a bit more about how to split it out? I need to grab the text from a specific cell in a specific table on the external web page.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [February 2, 2024, 11:22pm UTC](https://community.glideapps.com/t/update-glide-table-with-text-scraped-from-tables-on-external-web-pages/70436/4 "2024-02-02T23:22:45Z")

</div>

I would do this:

- Use a “Get Webpage Source” column to grab the content of the URL.
- Use a “Text to JSON” column to convert the content to JSON, maybe you can instruct it to specifically parse out the cell you want only, guide it to that cell using specific keywords.
- Use a Query JSON column to query out the value you want from the “Text to JSON” result.

---

<div class="post-metadata">

**Author:** ![coastal](https://avatars.discourse-cdn.com/v4/letter/c/94ad74/32.png) [@coastal](https://community.glideapps.com/u/coastal)\
**Post date:** [February 3, 2024, 8:12pm UTC](https://community.glideapps.com/t/update-glide-table-with-text-scraped-from-tables-on-external-web-pages/70436/5 "2024-02-03T20:12:37Z")

</div>

Thanks ThinhDinh. I will give that a try!