# Google Books API

**URL:** https://community.glideapps.com/t/google-books-api/55722
**Category:** Ask for Help
**Created:** [December 14, 2022, 7:21am UTC](https://community.glideapps.com/t/google-books-api/55722 "2022-12-14T07:21:58Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![Debra\_Langley](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/debra_langley/32/51585_2.png) [@Debra\_Langley](https://community.glideapps.com/u/Debra_Langley)
#### Post date: [December 14, 2022, 7:21am UTC](https://community.glideapps.com/t/google-books-api/55722/1 "2022-12-14T07:21:58Z")

</div>

I have a list of book ISBN numbers and want to auto poulate the book covers, oublisher and other info automatically from Google Books.

There is a free Google Books API available.

Does anyone know how to do this?

---

<div class="post-metadata">

### Author: ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [December 14, 2022, 7:26am UTC](https://community.glideapps.com/t/google-books-api/55722/2 "2022-12-14T07:26:16Z")

</div>

You should be able to use the Fetch JSON plugin to query the API, and then the JQ Plugin to transform the result.

> **[Glide • Fetch JSON column](https://www.glideapps.com/plugins/fetch)**
>
> Fetch and optionally transform JSON

> **[Glide • Transform JSON column](https://www.glideapps.com/plugins/jq)**
>
> Transform JSON with JQ

If you check the above doc links, you’ll find examples and a video guide to using JQ.

---

<div class="post-metadata">

### Author: ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [December 14, 2022, 11:14am UTC](https://community.glideapps.com/t/google-books-api/55722/3 "2022-12-14T11:14:51Z")

</div>

Yes it’s possible. I built an app that did this very thing for a teacher who wanted to build a reading log app. It works fairly well!

---

<div class="post-metadata">

### Author: ![Dilon\_Perera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilon_perera/32/85652_2.png) [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)
#### Post date: [December 14, 2022, 11:29am UTC](https://community.glideapps.com/t/google-books-api/55722/4 "2022-12-14T11:29:54Z")

</div>

Hi @Debra_Langley,

Welcome to the community 🥳

Just adding a video besides for Darren’s helpful information!

> **Video**
>
> [Google Books - Glide.mp4 - Google Drive](https://drive.google.com/file/d/1HHgkoplsk2XSZR12xRn9wg8ryugn6KZ1/view?usp=share_link)

> **Other Details**
>
> - URL Column
> 
> **`https://books.googleapis.com/books/v1/volumes?q=|||&maxResults=1&orderBy=relevance`**
> 
> ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/b/fbf7313193eebaa2634e4d8d30856720cf3ae538.png)
> 
> - Fetch URL Column
> 
> ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/1/519b23db648b5e48a50b927df261e4d647e3a992.png)
> 
> - Book Name Column
> 
> JQ Query : **`.items[].volumeInfo.title`**
> 
> ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/6/366f1fabf59a4b0438a10b1424ba991cce66537a.png)
> 
> - Author Name
> 
> JQ Query : **`.items[].volumeInfo.authors[0]`**
> 
> ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/9/b9fa887649f41aaa9bd1a0f65098f9c1935da5bc.png)
> 
> - Image
> 
> JQ Query : **`.items[].volumeInfo.imageLinks.thumbnail`**
> 
> ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/d/7d29f1b3872d7064c7c9feebe7d6180c5c22c1c4.png)

Thank you

---

<div class="post-metadata">

### Author: ![Debra\_Langley](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/debra_langley/32/51585_2.png) [@Debra\_Langley](https://community.glideapps.com/u/Debra_Langley)
#### Post date: [December 14, 2022, 1:32pm UTC](https://community.glideapps.com/t/google-books-api/55722/5 "2022-12-14T13:32:36Z")

</div>

Thanks for all the help will take a look.