# Problem with import a XML code to google sheet

**URL:** <https://community.glideapps.com/t/problem-with-import-a-xml-code-to-google-sheet/63500>\
**Category:** Ask for Help\
**Created:** [July 4, 2023, 8:59pm UTC](https://community.glideapps.com/t/problem-with-import-a-xml-code-to-google-sheet/63500 "2023-07-04T20:59:49Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Carter](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carter/32/45004_2.png) [@Carter](https://community.glideapps.com/u/Carter)\
**Post date:** [July 4, 2023, 8:59pm UTC](https://community.glideapps.com/t/problem-with-import-a-xml-code-to-google-sheet/63500/1 "2023-07-04T20:59:49Z")

</div>

Hello, I have my data which is imported directly on a GoogleSheet, when on Glide I put the command “ImportXML” it adds a ’ to the left of the content which makes the command not launch on google sheet.

Does someone have an idea ?

 ![Capture d’écran 2023-07-04 à 22.58.33](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/8/48e4511acaf16a949799f96e62a343da72b2f1d5.png)

---

<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:** [July 5, 2023, 12:33am UTC](https://community.glideapps.com/t/problem-with-import-a-xml-code-to-google-sheet/63500/2 "2023-07-05T00:33:42Z")

</div>

Why do you need to do that from Glide though? Can’t you just use a formula in the Sheet to do that? I assume you’re using an add row/set column action here?

---

<div class="post-metadata">

**Author:** ![Carter](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carter/32/45004_2.png) [@Carter](https://community.glideapps.com/u/Carter)\
**Post date:** [July 5, 2023, 8:48am UTC](https://community.glideapps.com/t/problem-with-import-a-xml-code-to-google-sheet/63500/3 "2023-07-05T08:48:42Z")

</div>

Because I import a loot of events from a robot (browse ai) into google sheet, and with Glide I juste edit the row to add the formula because I can’t do it with the robot.

---

<div class="post-metadata">

**Author:** ![Carter](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carter/32/45004_2.png) [@Carter](https://community.glideapps.com/u/Carter)\
**Post date:** [July 5, 2023, 2:41pm UTC](https://community.glideapps.com/t/problem-with-import-a-xml-code-to-google-sheet/63500/4 "2023-07-05T14:41:45Z")

</div>

I found a “trick” to do it, so in Glide in my template I put like “§IMPORTXML” instead of “=IMPORTXML” and then in Google Sheet I just do à Search and Change. So I change all § to = and it’s working fine. It’s a good “solution” because I import like 1000 events per week so … 🤣

---

<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:** [July 5, 2023, 2:44pm UTC](https://community.glideapps.com/t/problem-with-import-a-xml-code-to-google-sheet/63500/5 "2023-07-05T14:44:01Z")

</div>

I think something can be better here. Without knowing the structure of your db, have you tried arrayformula or byrow at all?

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [July 6, 2023, 2:44pm UTC](https://community.glideapps.com/t/problem-with-import-a-xml-code-to-google-sheet/63500/6 "2023-07-06T14:44:54Z")

</div>

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