How to Geocode in Google Sheets Install the API Connector Google Sheets add-on to add the Geocodio API to your spreadsheet. First you will need to install the API Connector Google Sheets add-on. ... Create a Geocodio API key. ... Organize your addresses in the spreadsheet. ... Set up the API Connector. ... Implement the ImportAPI function.