Web Data Scraping

[Thilina_Wick]

Hi so one of my clients have a requirement to use web scraping to get data from a data source without api support, is there a way to do this or is csv upload the only way to go?

Any help would be appreciated

Thanks in advance

[HBT]

I don't think there is a way around this in Appsheet. You can automate this job with Google App Script. Or you can do it manually. (https://www.benlcollins.com/spreadsheets/google-sheet-web-scraper/)

[Ami]

As mentioned you can perhaps use google script but you can surely make it with excel, check out on youtube https://youtu.be/dShR33CdlY8

Do note rhat you can't use a macro enabled excel sheet as a data source in appsheet, you need to add a macro to copy the scraped data to another excel file.

If you require assistancr let me know.

There might also be a solution with integromat

[Marc_Dillon]

IMPORTHTML() formula in Google Sheets.

[Thilina_Wick]

Hi @Marc_Dillon Thanks for the reply can you please elaborate on this, thank you

[Marc_Dillon]

https://lmgtfy.app/?q=importhtml