Find Free Udemy Courses with Google Sheets and the Udemy API?

Udemy has a really cool API that lets you pull down course details and results for all of their courses. In this blog post, we’re going to see how we can use their API along with Google Sheets to list out all of the Free Udemy courses. First, you’ll need to go here and create an Udemy API Key. Once you have your API key, we can start working in Google Sheets. In cell A1, type in “=udemyapi(KEY)” and press Enter. This will open up a new window with your API key, which you’ll need to copy down into cell B2 as shown below (it should be highlighted). Be careful not to change anything in this window! It will save automatically once you’ve copied down the entire thing into cell B2

Udemy has a really cool API that lets you pull down course details and results for all of their courses.

The Udemy API is a great way to get course data, including ratings, reviews and more.

It’s very easy to use and it’s free!

In this blog post, we’re going to see how we can use their API along with Google Sheets to list out all of the Free Udemy courses.

What is an API?

An Application Programming Interface (API) is a set of rules that allow different software programs or web services to communicate with each other. For example, if you have an account on Twitter and want another service like Instagram or Facebook Messenger send you updates every time someone mentions your username in a tweet, then both these services will need an API so they can talk to each other seamlessly without any problems whatsoever.

First, you’ll need to go here and create an Udemy API Key.

First, you’ll need to go here and create an Udemy API Key. You can then use this key in Google Sheets to pull information from the Udemy database.

If you want to learn more about using the Udemy API, check out their documentation here.

Once you have your API key, we can start working in Google Sheets.

Once you have your API key, we can start working in Google Sheets. The first thing we need to do is create a new spreadsheet and name it whatever you want. I’m going to call mine “Free Udemy Courses”. Next, go into cell B2 and copy and paste your API key into it from the previous section. You can now use this formula in other cells:

=udemyapikey()

In cell A1, type in “=udemyapi(KEY)” and press Enter.

In cell A1, type in “=udemyapi(KEY)” and press Enter.
Copy and paste the API key from cell B2 into cell A1.
Press enter to run the formula. The result should look something like this:

{ “status”: 200, “total_results”: 2, “course_ids”: [ { “id”: 109438 } ] }

This will open up a new window with your API key, which you’ll need to copy down into cell B2 as shown below. Be careful not to change anything in this window! It will save automatically once you’ve copied down the entire thing into cell B2.

This will open up a new window with your API key, which you’ll need to copy down into cell B2 as shown below. Be careful not to change anything in this window! It will save automatically once you’ve copied down the entire thing into cell B2.

If all goes well, your Google Sheet should now look something like this:

Now we can set up a little formula that will query the Udemy API and return the results as shown below.

The formula is in cell B2: =udemyapi(KEY)

This is copied from cell A1 to cell B2, where it will be used for querying the Udemy API later on. When you press Enter after entering this formula into your spreadsheet, it should return a JSON string. If not, try refreshing your browser or reloading the page after refreshing (Ctrl-F5).

You can use Google Sheets to pull all the free Udemy courses in one easy-to-read list. The API key is a bit more involved, but it’s free and worth it if you are interested in learning new skills or expanding your knowledge base.

Now that you know how to find free Udemy courses, it’s time to start learning! You can use this knowledge to find new topics or improve your skills in any area that interests you.