\
**Category:** Ask for Help\
**Created:** [November 19, 2019, 5:12am UTC](https://community.glideapps.com/t/parsing-xml-html-into-google-sheets/2131 "2019-11-19T05:12:36Z")\
**Posts on this page:** 2\
**Page:** 1
**Author:**  [@apertur.co](https://community.glideapps.com/u/apertur.co)\
**Post date:** [November 19, 2019, 5:12am UTC](https://community.glideapps.com/t/parsing-xml-html-into-google-sheets/2131/1 "2019-11-19T05:12:36Z")
Does anybody have any experience parsing data from a website into Google Sheets? I am trying to create a workout logging app where people can input (via a form) the “share” links commonly provided by apps like Strava into my app, and the app will parse the linked webpage for specific data (date, distance, time, etc.). I have made a tiny bit of progress but am encountering a number of challenges:
- Share links, even from the same app, have **different formats**. For example, the website gives an “Embed in Blog” code block [`]`, while the app gives what looks like a short URL [[9.7 mi Run Activity on August 12, 2019 by Mark E on Strava](https://strava.app.link/Z7dpIOjWH1)].
- Links may actually be **redirects** , and it’s not clear whether they can be parsed using `IMPORTXML` or `IMPORTHTML`
- `IMPORT` functions don’t work with `ARRAYFORMULA`
- **Parsing using XPath** doesn’t work, which may be the result of the above, or a separate problem
I’d appreciate thoughts on the best way to approach this.
Thanks!
---
**Author:**  [@George\_B](https://community.glideapps.com/u/George_B)\
**Post date:** [November 19, 2019, 9:54pm UTC](https://community.glideapps.com/t/parsing-xml-html-into-google-sheets/2131/2 "2019-11-19T21:54:28Z")
I have used some Google scripting to do this. It’s a bit of trial and error.