How to Use AI to harness Google APIs

Transcript

2. Technical Lead, Fly High Media Interested in Speeding up SEO auditing & workflows
3. ARE YOU USING AI TO GENERATE CODES TO SPEED UP WORKFLOW?
4. IS ANYONE CURRENTLY USING GOOGLE APIS?
5. TOOLS Google Sheets Google App Scripts ChatGPT
6. WHY USE GOOGLE SCRIPTS & AI?
7. SPEED
8. FREE
9. CUSTOMISABLE
10. WHAT GOOGLE APIS ARE USEFUL FOR SEARCH MARKETERS?
11. GOOGLE SEARCH CONSOLE API
12. GOOGLE ANALYTICS METRICS
13. GOOGLE ADS API
14. GOOGLE BUSINESS PROFILE API
15. PAGE SPEED & CORE WEB VITALS CRUX API / GTMETRIX
16. OTHER APIS
17. WHAT ARE GOOGLE APP SCRIPTS?
21. LET’S START EXTRACTING DATA FROM APIS!
22. GOOGLE SEARCH CONSOLE API
23. GET APIS FROM GOOGLE DEVELOPERS CONSOLE
25. FLYHIGHMEDIA.CO.UK/ BRIGHTONSEO-2025 GUIDE
26. LET’S EXTRACT THE CLICKS & IMPRESSIONS FOR MULTIPLE URLS
27. ASK CHATGPT/AI I WANT A FORMULA THAT EXTRACTS THE CLICKS AND IMPRESSIONS USING GOOGLE SEARCH CONSOLE API FOR A URL SELECTED IN THE FORMULA
28. ENSURE IT HAS SOMETHING LIKE THIS CLIENT_ID = 'YOUR_OAUTH_CLIENT_ID'; CLIENT_SECRET = 'YOUR_OAUTH_CLIENT_SECRET';
29. ASK CHATGPT/AI I WANT TO PROVIDE CLIENT ID & CLIENT SECRET TO GET THE DATA FROM GOOGLE SEARCH CONSOLE
31. ASK CHATGPT/AI I WANT TO PROVIDE THE DATES AND THE DOMAIN IN THE FORMULA FROM A CELL
32. SITE URL DOMAIN PROPERTY SC-DOMAIN:YOURDOMAIN.COM URL PREFIX HTTPS://WWW.YOURDOMAIN.COM
33. ENABLE OAUTH2.0 IN GOOGLE APP SCRIPTS
37. 1B7FSRK5ZI6L1RSXXTDGDEUS PZLUKDSI4KGUTMORSTQHH GBZBKMUN4IDF
40. RECOMMENDATION SEPERATE METRICS INTO DIFFERENT FORMULAS ASK CHATGPT/AI
41. AUTHORISE THE SCRIPT
45. COPY URL AND OPEN URL IN NEW TAB & THEN FOLLOW INSTRUCTIONS TO VALIDATE THE CODE
48. COPY FORMULA (FROM CHATGPT/AI) AND START USING THE CUSTOM FORMULA YOU HAVE MADE!
49. OTHER USE CASES
50. GSC AUTOMATED REPORTING OF SITE PERFORMANCE
51. GSC IDENTIFYING AND MONITORING CRAWL ERRORS
52. GSC GET RELATED QUERIES TO CONTENT
53. GA4 MONITOR E-COMMERCE TRACKING DATA
54. GA4 MONTHLY TRAFFIC OVERVIEW
55. GA4 TRACKING CAMPAIGN UTM PARAMETER PERFORMANCE
56. GOOGLE BUSINESS LISTINGS REPORTING ON CUSTOMER ACTIONS AND INSIGHTS FOR MULTIPLE LISTINGS
57. CRUX API EXTRACT REAL-USER EXPERIENCE DATA (CORE WEB VITALS)
58. WHY NOT USE OTHER TOOLS?
59. EXPENSIVE
60. DATA IS NOT CUSTOMISABLE
61. REAL-TIME COLLABORATION
62. ISSUES YOU MAY COME ACROSS
63. API QUOTAS AND LIMITS 1
64. AUTHENTICATION ERRORS 2
65. DATA FORMATTING ISSUES 3
66. USE AI TO TROUBLESHOOT ANY ISSUES 4
67. GET ACCESS TO SLIDES SPEAKERDECK.COM/ JONATHONROBERTSSEO
68. FLYHIGHMEDIA.CO.UK/ BRIGHTONSEO-2025 GOOGLE API GENERATION GUIDE
69. ANY FURTHER QUESTIONS? linkedin.com/in/jonathon-roberts-seo jonathonr.bsky.social @jonathonrseo www.flyhighmedia.co.uk