Workflow
How it works
1. You press the button to start a run. 2. Google Sheets returns the rows of your address list. 3. For each row, an HTTP request sends the address to the Google Maps Places text search API. 4. The JSON answer is parsed to read the first match. 5. Google Sheets adds a row with the address and its latitude and longitude.