Skip to main content

Log in with the Google Maps Geocode Connector

You can use Awesome Table Connectors to convert a list of addresses into geographic coordinates within Google Sheets by logging in with the Google Maps Geocode connector.

Prerequisites

Method 1: Sign in with Google Maps Geocode​

  1. In the Awesome Table add-on Home screen, click Create new request.


    The list of available connectors is displayed.

  2. Open the Google Maps Geocode connector.

    The Google Maps Geocode connector is listed in the Productivity category of the add-on

  3. On the Connect to Google Maps Geocode screen, click Continue without authentication.

    note

    Geocode up to 1,000 addresses daily with a free Google account and up to 10,000 if you're a paid Google Workspace user, no authentication required. If you need more, you can get an API key with a Google billing account.

You are now logged in with the Google Maps Geocode connector. The Select data drop-down shows actions you can use to geocode.

The list of data to use to geocode
What's next

You can now use Awesome Table Connectors to convert geographic coordinates in Google Sheets.

Method 2: Connect with an API key​

Some connectors allow you to log in with an API key within the Awesome Table add-on. With this method, you don't need an account and can sign in from the add-on.

Prerequisites
You have obtained the API key from the administration interface of the software you are connecting to. Only the account administrator can provide it.

  1. In the Awesome Table add-on Home screen, click Create new request.


    The list of available connectors is displayed.
  2. Open the connector.

  3. Select Connect with an API key.

    The button of the screen of the add-on that says Connect with an API key

  4. Enter your API Key.

    An empty field for API key

  5. Click Test & Save.

  6. Enter an Account name.

    An empty field for Account name

  7. Click Save account.

    A message appears saying your authentication is successful.

You are now logged in with the connector and you can start geocoding.

What's next

You can now use Awesome Table Connectors to convert geographic coordinates in Google Sheets.

On this page