You might see if they have an API you could use. I did something
similar with USPS, pass  it a zip code then it gives you the city name.

If they do not have one you could use, research web  queries.
You "Should" be able to build a parameterized query, loop through
your set of SSN's or names, and write the data to a sheet one row at
a time.