@@tech-lever Yo, thanks for the fast reply! Even in your table it's not working for me lmao, but i figured it out. It's a language problem. I guess there are some little variations in excel/spreadsheet functions from language to language. I am from germany and I have to separate the values with semicolons instead of commas. So for example for me the correct version is "=IMPORTXML("URL";"//h1")" instead of "=IMPORTXML("URL","//h1")"
thank you for your great video. I need some help because after scraping a page, i need to go to the next page keep going scraping. The url of the secon d page ends with p=2 and so on thank I do not know if it is possible to do that in google sheet you for your help