Free Public API Data in Google Sheets

Master APIs in Google Sheets: Fun Projects with Data Integration

Join us for an exciting and educational journey as we explore using free public APIs with Google Sheets. This episode covers everything from fetching data from APIs like Kanye Rest, Harry Potter, and public holidays, to adding fun elements like random useless facts and sports data. We start from scratch, teaching you how to get API data into Google Sheets, parse JSON responses, and create custom functions using Google Apps Script. Whether you’re a beginner or looking to enrich your spreadsheets with dynamic content, this video is your perfect guide. Get ready to transform your Google Sheets with practical API integrations!

00:00 Introduction to Free Public APIs
01:40 Getting Started with Kanye Quotes API
08:17 Exploring Harry Potter API
23:25 Fetching Public Holidays Data
30:57 Exploring Country Codes
32:22 Creating a Dropdown Menu
33:29 Testing Country Code Functionality
34:19 Parsing Launch Year Data
36:00 Building a Holiday Dashboard
37:16 Exploring More Public APIs
38:14 Screenshot API Experiment
44:53 Sports API Integration
56:23 Random Useless Facts API
59:56 Conclusion and Final Thoughts