Hi all!
I'm looking for a code that would be able to input a list of concert venue's name into a google search result, and output their venue capacity by scrapping the bolded information contained within a google search result's featured snippet into Excel. I'm currently inputting it manually, and since the majority of google search results's featured snippets are accurate, would like to have a code that could do this.
Attached are images of the excel graph I currently have, and where I get the results from.
Welcome any and all advice about how to design a code capable of doing this!
Excel Example.png
Google Search Example.png
Bookmarks