How to Import Google Books Data to Airtable

Jun 10, 2022Rosie Threlfall

In this easy-to-follow guide, we'll learn how to import data from Google Books into Airtable using the free Data Fetcher Airtable app. For a list of book ISBNs, we'll import book details like 'Title', 'Description', 'Authors' and 'Published date' into Airtable. This can all be done without the need for code.

Create Output Table

Create a table in your base called 'Books' with a (single line text) field called 'ISBN' and another a (single line text) filed called 'Title.'

Populate the fields with the ISBNs of the books you want to import data into Airtable for.

Table Setup to Import Books Data Into

Create a Grid view in your table called 'Needs info' with the following filters:

'ISBN' is not empty and 'Title' is empty.

Google-Books-View-Filters.png

Install Data Fetcher

Install Data Fetcher from the Airtable app marketplace. Either sign up for a free Data Fetcher account or if you already have an account, sign in using the 'Have an account?' option in the bottom left of the box.

Sign Up to Data Fetcher

Import Google Books Data into Airtable

On the home screen of the Data Fetcher app, click 'Create your first request'. Requests enable you to import or send data to and from Airtable using Data Fetcher. You can create multiple requests for each Airtable base although you can only add one app per base on the Airtable Free plan.

Click create your first request in Data Fetcher

On the create request screen in Data Fetcher, for Application, select 'Google Books'.

Google Books Application

For Endpoint, select 'Search volumes by title/author/ISBN'.

Endpoint

Enter a Name for your request, e.g. 'Import Book Data '. Then click 'Save & Continue'.

Google-Books-Import-Settings.png

Make sure the Output table & View are set to your 'Books' table and 'Needs info' view.

Output Table and View

You need to select at least one option in order to reference the data you want to import from Google Books.

You can use either the Title (to fetch results based on the book title), ISBN (to fetch results based on book ISBN), Author (to fetch results based on book author) or Publisher (to fetch results based on book publisher).

For this example, we will use ISBN so click the + button in order to create a reference to our 'Books' output table.

Add reference to ISBN in output table

A new window will open to set a reference to a table or a variable. For Table, select 'Books' and Field select 'ISBN'. For Run every record select 'Needs info'.

Click 'Confirm'.

Insert reference to table

The 'ISBN' now has a table reference to our ISBN Airtable field.

Reference to ISBN

Click 'Save & Run'.

Import Google Books Data to Airtable

Data Fetcher will send the request to Google Books and the Response field mapping window will open. Here you set which fields to import from Google Books and how they map to your selected output table. For an imported field, you can also set whether to map to an existing field or create a new one and set the field type.

Use the 'Filter all' button to clear the pre-selected fields, then use the 'Find field' search bar to choose the fields you would like to import. For this example, we will import the 'Title', 'Description', 'Authors' and 'Published date' fields. 

Click 'Save & Run'.

Google Books Response Mapping

Data Fetcher will now create any new fields in the output table and run the request to retrieve the Google Books data then populate the Airtable 'Books' table.

Google Books Data imported into Airtable

Import Google Books Data Automatically

At the moment, we have to manually run the request to import the data from Google Books but by using Data Fetcher's scheduled requests feature we can automatically import this information every 15 minutes/ hour/ day etc.

In Data Fetcher, scroll to Schedule and click 'Upgrade'.

Upgrade Data Fetcher to Schedule Requests

A new tab will open where you can select a plan and enter your payment details to upgrade.

data fetcher upgrade options

Return to the Data Fetcher app and click 'I've done this'.

data fetcher upgrade done

Click 'Add API key' in order to add your Airtable API key. You can find your Airtable API key here.

Group 11(1).png

Enter your Airtable API key and click 'Save'.

save-airtable-api-key.png

Enable Schedule this request.

schedule-data-fetcher-request.png

Select intervals of either 'Minutes', 'Hours', 'Days' or 'Months' depending on how often you want the request to run. Click 'Save', and your requested Google Books data be automatically pulled in based on your specified schedule.

data fetcher schedule request

Other Recent Posts

How to Import a Website's XML Sitemap into Airtable

How to Import a Website's XML Sitemap into Airtable

Jun 16, 2022Rosie ThrelfallXML
How to Import Toggl Track Data to Airtable

How to Import Toggl Track Data to Airtable

May 30, 2022Rosie ThrelfallToggl Track
How to Import Google Ads Data to Airtable

How to Import Google Ads Data to Airtable

May 26, 2022Rosie ThrelfallGoogle