Workflow:

1. Export Google contacts as Google CSV.

2. Open .csv file in Google Sheets.

(https://docs.google.com/spreadsheets/u/0/)

3. Get 'Geocode by Awesome Table' extension for Google Sheets.

(may only be possible in the Chrome browser)

4. Geocode the 'Address 1 - Formatted' column.

Check the values in the Longitude/Latitude columns if they have the right formatting.
If it's wrong, change the the country/language setting in the file settings to 'United States' and geocode again.

5. Optional: Do the same for the 'Address 2 - Formatted' column.

You then have to rename the new Longitude and Latitude columns to 'Longitude 2' and 'Latitude 2'

6. Download file as CSV

7. Run the Python code (change input/output path in the code before running it).

If any problems arise, I suggest asking an LLM like ChatGPT.