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