Upgrade to Pro — share decks privately, control downloads, hide ads and more …

How to Use AI to harness Google APIs

Avatar for Jonathon Roberts Jonathon Roberts
April 11, 2025
Marketing & SEO
0
600

How to Use AI to harness Google APIs

Avatar for Jonathon Roberts

Jonathon Roberts

April 11, 2025
Tweet

More Decks by Jonathon Roberts

See All by Jonathon Roberts
TechSEO North Feb 2025 - How To Implement Schema to Custom CMSs
Avatar for Jonathon Roberts jonathonrobertsseo
0
37
BrightonSEO October 2024 - How to Speed Up Content Audits using ChatGPT
Avatar for Jonathon Roberts jonathonrobertsseo
3
730

Other Decks in Marketing & SEO

See All in Marketing & SEO
SERP Conf. Vienna - Web Accessibility: Optimizing for Inclusivity and SEO
Avatar for Sara Fernández Carmona sarafernandezseo
1
1.1k
GA4 Debugging: Survive and Thrive
Avatar for Jonathan Moore nathanless
PRO
1
440
JAWS-UGとは -JAWS-UG茨城支部#0勉強会-
Avatar for awsj communty program manager - Shigeru Numaguchi awsjcpm
0
120
Beyond Algorithms: customer-centric SEO as the key to long-term success
Avatar for Julian Hooks julianhooks
0
190
How to Optimise 3,500 Product Descriptions for eCommerce in One Day Using ChatGPT & Make
Avatar for Katarina Dahlin katarinadahlin
PRO
1
1k
Stop paying twice: how to eliminate search cannibalisation and maximise ROI - BrightonSEO x Hero Conf UK - April 2025
Avatar for Chris Ridley c_j_ridley
1
260
SEO Strategy Masterclass
Avatar for DavetheSEO 00dacousin
0
160
Topical Authority in the Age of Entity SEO - BrightonSEO San Diego
Avatar for Felipe Bazon felipebazon
0
230
Digital PR's Dirty Little Secret: Most of the Links You're Earning Have No Impact on Metrics That Actually Matter
Avatar for James Brockbank brockbankjames
0
160
How to talk to stakeholders about algorithm updates in 2024
Avatar for Aimee Jones aimeejones12
1
670
How Search Happens: Before & After you Click Enter @ SearchAfricon
Avatar for davetheseo davetheseo
0
100
Heros Not Villains - Modern SEO in the Generative IR Era
Avatar for Dawn Anderson dawnieando
4
1.1k

Featured

See All Featured
A better future with KSS
Avatar for Kyle Neath kneath
239
17k
Build your cross-platform service in a week with App Engine
Avatar for Jose L jlugia
231
18k
4 Signs Your Business is Dying
Avatar for Josh Pigford shpigford
183
22k
ピンチをチャンスに：未来をつくるプロダクトロードマップ #pmconf2020
Avatar for Aki / @LoveIdahoBurger aki_iinuma
122
52k
Navigating Team Friction
Avatar for Lara Hogan lara
185
15k
Side Projects
Avatar for Sacha Greif sachag
453
42k
Statistics for Hackers
Avatar for Jake VanderPlas jakevdp
799
220k
Producing Creativity
Avatar for Steve Smith orderedlist
PRO
344
40k
Designing Dashboards & Data Visualisations in Web Apps
Avatar for Des Traynor destraynor
231
53k
The Illustrated Children's Guide to Kubernetes
Avatar for Chris Short chrisshort
48
50k
For a Future-Friendly Web
Avatar for Brad Frost brad_frost
178
9.7k
Let's Do A Bunch of Simple Stuff to Make Websites Faster
Avatar for Chris Coyier chriscoyier
507
140k

Transcript

  1. None

  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?

  18. None
  19. None
  20. None

  21. LET’S START EXTRACTING DATA FROM APIS!

  22. GOOGLE SEARCH CONSOLE API

  23. GET APIS FROM GOOGLE DEVELOPERS CONSOLE

  24. None

  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
  30. None

  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

  34. None
  35. None
  36. None

  37. 1B7FSRK5ZI6L1RSXXTDGDEUS PZLUKDSI4KGUTMORSTQHH GBZBKMUN4IDF

  38. None
  39. None

  40. RECOMMENDATION SEPERATE METRICS INTO DIFFERENT FORMULAS ASK CHATGPT/AI

  41. AUTHORISE THE SCRIPT

  42. None
  43. None
  44. None

  45. COPY URL AND OPEN URL IN NEW TAB & THEN

    FOLLOW INSTRUCTIONS TO VALIDATE THE CODE
  46. None
  47. None

  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