I’m trying to create a custom function on appscript which would give me the price info of a particular Airbnb listing. Is that possible? I know I cant use Importxml function since its not static but I thought it would be possible to build a custom function via appscript. I keep getting the error message “We’re sorry, a server error occurred. Please wait a bit and try again.”

I’m currently using the importhtml function in Google Sheets to scrape values from several different websites and then compare the scraped data with data from my own site. The values on my site are in column A and the scraped values (a list of numbers) get dumped into columns B, E, G, etc. I then use =IF (COUNTIF(A:A, BX/EX/GX), “O”, “X”) to place an X or an O in the column to the right of the scraped values and conditional formatting to turn Xs red so that I can quickly see if I already have the values on my site.