Google Finance API using Excel Macro

I need an excel visual basic macro that can extract data from Google Finance using the Google Finance API. I have an excel file containing over 7,000 company names. Some of these 7,000 companies are listed in Google Finance while others will not have any data. The macro needs to be smart enough to eliminate which companies are not listed. (Note: I am not looking for AI to guess the correct match -- if there is no exact match then it is fine to simply state data was not availabile). In the first instance, I will need the macro to extract the business description for each company that have available data on Google Finance. However, the macro needs to be customisable such that it is easy to modify and choose other data for extraction.