Need macro to extract data from google

[nethmi fernandiz]

Hello,

Is it possible to extract the address and phone number from google using macro?

I have excel where, column A has company name, column B has company location and we need company address in column C and company phone number in column D.

How to do? Please help

PFB table for reference

Company name	Company location	Company address	Company contact number
IBM	London, UK	Data needed	Data needed
Thrive Global	New york, USA	Data needed	Data needed

<tbody>
</tbody>

Thanks in advance
Namrata