In this guide, we'll look up business geolocation, rating & opening Hours in Airtable. We're going to use the Data Fetcher app to do connect to the Google Places API and pull in this information with no-code.
Add all the business names you want to look up in the 'Name' field in your Airtable table. If you have full addresses, use those. If not, a name and city are sufficient.
Add the following fields:
Then create a new Grid view called 'Needs place id' with the following filters:
Then create another new Grid view called 'Needs details' with the following filters:
Install Data Fetcher from the Airtable app marketplace. After the app launches, sign up for a free Data Fetcher account by entering a password and clicking 'Sign up for free'.
The first thing we need to do is look up a unique place id for every business name in our table. We will then use this id to look up further details (opening hours, geolocation etc.) about each business.
On the home screen of the Data Fetcher app, click 'Create your first request'. Requests in Data Fetcher are how you import data to or send data from your Airtable base.
On the create request screen in Data Fetcher, for Application, select 'Google Maps'.
Next, enter your API Key from the previous step.
For Endpoint, select 'Find a place from name/address/phone number'.
Enter a Name for your request, e.g. 'Import Place Id'. Then click 'Save & Continue'.
We want to use the values in our 'Name' field for Input. Under Name, click the + button to insert a reference to the table.
A modal will open where we can create the table reference. For Field, select 'Name'.
For Run for every record in view, select 'Needs place id'. Click 'Confirm'.
The Input now has a reference to our table.
For Fields, select 'Place id'. For now, we're just going to look up the place id, as we need to use it to look up opening hours and other details.
Click 'Save & Run'.
The request will run and the Response field mapping modal will open. This is where you set which fields to import from the Google Places API and how they should map to your output table. For each Google Places API field, you can either import or filter it. For an imported field, you can set whether to map them to an existing field or create a new field.
Make sure 'Place id' is imported and mapped to the existing 'Place id' field. Then click 'Save & Run'.
Data Fetcher then run the request again for every record and look up the Google Places place id based on the business name. The records in the 'Needs place id' view will be updated and move out of the filtered view.
Click 'Back' to return to the Data Fetcher home screen.
Now we will create a second request using the place ids to look up details about each business such as geolocation, overall use rating & opening hours.
On the Data Fetcher home screen, Click 'Create request'.
On the create request screen, for Application, again select 'Google Maps'.
Your API Key should populate automatically.
For Endpoint, select 'Find details for a place id'.
Enter a Name for your request, e.g. 'Import Place Details'. Then click 'Save & Continue'.
We want to use the values in our 'Place id' field for Place id. Under Place id, click the + button to insert a reference to the table.
A modal will open where we can create the table reference. For Place id, select 'Place id'. For Run on every record in view, select 'Needs details'. Then Click 'Confirm'.
Place id now has a reference to our table.
Select the Fields you want to import from Google Places. Most of these should be self-explanatory but note the following:
Click 'Save & Run'.
Import the fields you want on the Response field mapping, then click 'Save & Run'.
Data Fetcher will create the missing fields in the table, then run the request again and import rating, geolocation, opening hours and other fields for every business in the 'Needs details' view.
At the moment you have to calculate the delivery time & distance by manually clicking the 'Run' button for each request. Lets combine the two requests into a sequence, then schedule this to run automatically.
On the Data Fetcher home screen, click the blue dropdown icon, then click 'Create sequence'.
Give the sequence a name, like 'Import Place Id & Details'.
Select 'Import Place Id' for the first request and 'Import Place Details' for the second. Then click 'Save'.
In Data Fetcher, scroll to Schedule and click 'Upgrade'.
A new tab will open where you can select a plan and enter your payment details to upgrade.
Return to the Data Fetcher app and click "I've done this".
Click 'Add API key' in order to add your Airtable API key. You can find your Airtable API key here.
Enter your Airtable API key and click 'Save'.
Enable Schedule this sequence.
Select how often you want the request to run, e.g. 'Every hour'. Click 'Save' The sequence will now run on the schedule and update the exchange rates automatically.