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 extension. 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 using the Google Books Airtable integration.

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.


Install Data Fetcher

Install Data Fetcher from the Airtable 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 extension 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 extension 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'.


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


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

Automatic Google Books Airtable Integration

At the moment, we have to manually run the request to import the data from Google Books but by using Data Fetcher's scheduled Google Books Airtable integration 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 pricing plans.png

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

data fetcher upgrade done

Under Schedule click '+ Authorize'.

Schedule Data Fetcher

Next, you'll see a new window where you'll be prompted to authorize which Airtable bases you want Data Fetcher to have access to.

It's recommended to select 'All current and future bases in all current and future workspaces' which will avoid having to authorize other bases in the future.

Click 'Grant access'.


In Data Fetcher, you'll now see Schedule this request is toggled on.

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

Schedule this request

Other Recent Posts

How to Use Airtable Generative AI

How to Use Airtable Generative AI

Jul 5, 2024

Andy Cloke

Connect to the OpenAI API in Airtable with No-Code

Connect to the OpenAI API in Airtable with No-Code

Jun 25, 2024

Andy Cloke

How to Make an HTTP GET Request in Airtable

How to Make an HTTP GET Request in Airtable

Jun 24, 2024

Andy Cloke

Custom Requests