I can't find a script that would grab the URL from row A on my spreadsheet and return the output on row B. My importxml formula is working fine:=IMPORTXML(A332, //*[@id='ariadne'])But the issues is I've got more than 20K rows of url that need to be parsed.I imagine there would be a for loop that grabs the url from row A, applies the importxml formula to it and pastes it on row B. Does anyone know how to get this done?
Using Google scripts instead of Importxml
google spreadsheets;google apps script;xml