---
title: "XPath Tester using Web Apps Created by Google Apps Script (working with existing Google Sheets functions in Apps Script)"
author: "Martin Hawksey"
date: 2021-07-02T07:22:20+00:00
modified: 2021-07-02T07:23:03+00:00
canonical_url: https://pulse.appsscript.info/p/2021/07/xpath-tester-using-web-apps-created-by-google-apps-script-working-with-existing-google-sheets-functions-in-apps-script/
markdown_url: https://pulse.appsscript.info/p/2021/07/xpath-tester-using-web-apps-created-by-google-apps-script-working-with-existing-google-sheets-functions-in-apps-script.md
categories:
  - "Intermediate"
  - "Sheets"
  - "Snippet"
  - "Solutions"
  - "V8"
  - "Web App"
tags:
  - "tanaikech.github.io"
featured_image: https://pulse.appsscript.info/files/2021/07/20210202a-fig1.gif
description: "This is an interesting little Apps Script solution from Kanshi Tanaike which uses the existing Google Sheets =IMPORTXML() in a Google Apps Script  Web App to test an XPath. As there is a delay in loading some Google Sheets function results this post includes a nice little coding pattern using a do...while loop to wait for results to render.  "
---

# XPath Tester using Web Apps Created by Google Apps Script (working with existing Google Sheets functions in Apps Script)

![XPath Tester using Web Apps Created by Google Apps Script (working with existing Google Sheets functions in Apps Script)](https://pulse.appsscript.info/files/2021/07/20210202a-fig1.gif)

> [https://tanaikech.github.io/2021/02/02/xpath-tester-using-web-apps-created-by-google-apps-script/](https://tanaikech.github.io/2021/02/02/xpath-tester-using-web-apps-created-by-google-apps-script/)
> In this post, I would like to introduce the xpath tester using Web Apps created by Google Apps Script.

This is an interesting little Apps Script solution from Kanshi Tanaike which uses the existing Google Sheets `=IMPORTXML()` in a Google Apps Script  Web App to test an XPath. As there is a delay in loading some Google Sheets function results this post includes a nice little coding pattern using a `do...while` loop to wait for results to render.

Source: [XPath Tester using Web Apps Created by Google Apps Script**](https://tanaikech.github.io/2021/02/02/xpath-tester-using-web-apps-created-by-google-apps-script/)

---

*Published by [Martin Hawksey](https://pulse.appsscript.info/p/author/admin/) on [Pulse](https://pulse.appsscript.info/). Original article: [https://pulse.appsscript.info/p/2021/07/xpath-tester-using-web-apps-created-by-google-apps-script-working-with-existing-google-sheets-functions-in-apps-script/](https://pulse.appsscript.info/p/2021/07/xpath-tester-using-web-apps-created-by-google-apps-script-working-with-existing-google-sheets-functions-in-apps-script/)*