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
800

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
55
BrightonSEO October 2024 - How to Speed Up Content Audits using ChatGPT
Avatar for Jonathon Roberts jonathonrobertsseo
3
840

Other Decks in Marketing & SEO

See All in Marketing & SEO
Sitekwaliteit is dé nr. 1 ranking factor - Eduard Blacquière - SEO Benelux meetup (mei 2025)
Avatar for SEO Pro Academy seoproacademy
0
170
Community Partnerships Campaign Overview
Avatar for Bernadette bernabiko
0
140
Joao Filipe Pereira - Predicting Core Web Vitals impact using Google Sheets [BrightonSEO April 2025]
Avatar for Joao Filipe Pereira joao_f_pereira
1
390
Lessons Learnt from Crawling 1000+ Websites
Avatar for Charles Meaden charlesmeaden
0
350
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
PRO
0
440
How digital authority PR is redefining brand influence
Avatar for Bubblegum Search bubblegumsearch
0
250
The #1 spot is gone: here's how to win anyway
Avatar for Tamara Novitovic tamaranovitovic
1
700
Winning Ecommerce Organic Search in an AI Era - #searchnstuff2025
Avatar for Aleyda Solis aleyda
0
1.6k
Do Core Web Vitals Actually Matter for SEO?
Avatar for Matthew Brown mjbpdx
0
1.8k
SEO Benelux Conf - Automating Technical SEO on a low budget
Avatar for Jan Caerels jancaerels
0
160
How to Build an AI Search Optimization Roadmap - Criteria and Steps to Take #SEOIRL
Avatar for Aleyda Solis aleyda
1
1.6k
勉強会から始まった僕のDevRel~新卒エンジニアがつないだ2年間の軌跡~
Avatar for uutan1108 ohmori_yusuke
1
260

Featured

See All Featured
Statistics for Hackers
Avatar for Jake VanderPlas jakevdp
799
220k
Refactoring Trust on Your Teams (GOTO; Chicago 2020)
Avatar for Rebecca Miller-Webster rmw
35
3.2k
Building a Scalable Design System with Sketch
Avatar for Laura Van Doore lauravandoore
463
33k
The Myth of the Modular Monolith - Day 2 Keynote - Rails World 2024
Avatar for Eileen M. Uchitelle eileencodes
26
3.2k
Evolution of real-time – Irina Nazarova, EuRuKo, 2024
Avatar for Irina Nazarova irinanazarova
9
1k
Rebuilding a faster, lazier Slack
Avatar for samanthasiow samanthasiow
84
9.2k
ピンチをチャンスに：未来をつくるプロダクトロードマップ #pmconf2020
Avatar for Aki / @LoveIdahoBurger aki_iinuma
127
54k
Stop Working from a Prison Cell
Avatar for Chris Michel hatefulcrawdad
272
21k
Connecting the Dots Between Site Speed, User Experience & Your Business [WebExpo 2025]
Avatar for Tammy Everts tammyeverts
10
640
Optimising Largest Contentful Paint
Avatar for Harry Roberts csswizardry
37
3.5k
How to train your dragon (web standard)
Avatar for Monica Dinculescu notwaldorf
97
6.3k
Done Done
Avatar for chrislema chrislema
186
16k

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