Use getaddress.io to validate addresses stored in Google Forms.
- Create a service account in the Google Developer Console
- Share Google Sheet with service account
- Copy client secret to client_secret.json
- Obtain api key from getaddress.io and place it in api_key.txt
- Run the program as follows:
python validate.py -r <sheet name>