Exploring Google APIs with Python & JavaScript

on YouTube ↗01h 16m

" summary

Shows concrete code and working demos using Python and JavaScript client libraries, not slides-only theory: list first 100 Drive files (prints name and mimeType), create+format Sheets header (create spreadsheet, write rows, freeze and bold row), replace placeholders in Slides to auto-generate decks, Gmail add-on extracts receipt fields and emails results. Explains credentials: API keys for public data, OAuth 2 for user data (access tokens last ~1 hour, refresh tokens normally don’t expire), service accounts for machine-to-machine, and serverless options (App Engine, Cloud Functions).

AI-written summary · about

" chapters (62)

1. 0:00Intro
2. 0:27Overview
3. 1:34About me
4. 2:05Python books
5. 2:37The weirdest job
6. 3:38My job
7. 4:12Outline
8. 5:12Success
9. 5:22Google Apps
10. 6:14More to Google
11. 9:33Authentication vs Authorization
12. 11:31Developer Console
13. 13:08Dashboard
14. 14:01Library
15. 14:52credentials page
16. 15:22create credentials
17. 15:37API keys
18. 16:26whitelist API keys
19. 17:26no API key
20. 17:52different types of OAuth
21. 19:41create OAuth client secret
22. 20:48client IDs
23. 21:11global access
24. 21:28programming languages
25. 23:20API keys vs client IDs
26. 24:49Simple API access
27. 25:43OAuth
28. 28:52How OAuth works
29. 29:45Looking at some code
30. 30:08API key 1
31. 32:33How it works
32. 33:11Part D
33. 33:56Google Cloud Platform
34. 34:11Apps Script
35. 34:25Google Drive
36. 34:50Zip Files
37. 35:28Drive Metadata
38. 36:37Code Sample
39. 38:18Selfie
40. 38:45Work
41. 39:01Middle code
42. 39:39OAuth2 credentials
43. 39:59Refresh tokens
44. 40:21Running on Python
45. 40:40OAuth Flow
46. 41:58Service Endpoint
47. 42:37Execute the query
48. 43:02Assign files
49. 43:28Im powerful
50. 44:23New Sheets API
51. 45:25Use Case 1
52. 45:58Node Code Lab
53. 46:20Toy Order Database
54. 46:58Customer Orders Database
55. 49:56Google Sheets
56. 53:11Google Slides Example
57. 54:03Gmail API
58. 54:22Gmail API Example
59. 55:39Calendar API Example
60. 57:13Mail Merge Example
61. 57:53BigQuery Example
62. 59:26Natural Language

" related talks

• 31mWeb API Mashups in a Python ApplicationJohan Euphrosine · EuroPython 2011
• 24mJavaScript, spreadsheets and APITomasz Stachewicz · ConfrontJS 2022
• 09mGoogle Apps ScriptAndrey Shulga · Frontend fwdays'17
• 45mEdit Excel and Google Spreadsheets with Python: An IntroductionAl Sweigart · Python Web Conf 2023
• 23m"So, I Got Some Code Working… Now How Do I Share It?!"Elaine Wong · PyOhio 2024
• 34mPython as a Framework for Analytics and Growth HackingIgnacio Elola · PyData Berlin 2015
• 31mBeginning your own data engineering projectsHui Xiang Chua · Conf42 Python 2021
• 40mLatest advances in the Google APIs platformAli Afshar · EuroPython 2011