$30 off During Our Annual Pro Sale. View Details »

How to Use AI to harness Google APIs

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

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

Other Decks in Marketing & SEO

See All in Marketing & SEO
The practical guide to AI search: from zero to market leader in 90 days
Avatar for Samanyou Garg samanyougarg
2
1.1k
It's ALL AI search: Building a unified view for growth
Avatar for Ray Grieselhuber raygrieselhuber
PRO
0
690
E-E-A-T for Grown-Ups: Playbook for Auditing and Optimizing Your Content
Avatar for Tom Winter tomwinter
0
100
コンテンツマーケティングの戦略設計（2025年版）
Avatar for Yasuki Ichishima makitani
3
3.4k
Tracking User Journey for SEO in GA4
Avatar for Bengü Sarıca Dinçer bngsrc
1
1.3k
How to Build an AI Search Optimization Roadmap
Avatar for Aleyda Solis aleyda
1
120
会社説明資料｜株式会社トライバルメディアハウス
Avatar for 株式会社トライバルメディアハウス tribal
0
5.1k
勉強会から始まった僕のDevRel~新卒エンジニアがつないだ2年間の軌跡~
Avatar for uutan1108 ohmori_yusuke
2
310
Content Decay the silent threat to website performance
Avatar for Rich George richardgeorge
0
310
BrightonSEO 2025 - Lies, Damned Lies & SEO Reports
Avatar for Ryan Ricketts slickettsdigital
0
220
顧客体験をアップデートするときに見直すべきポイント
Avatar for Satoshi Konno sarosaro
0
210
AI Search: Where are we now and how to succeed - #SEOsummit Brasil
Avatar for Aleyda Solis aleyda
0
400

Featured

See All Featured
Building a Scalable Design System with Sketch
Avatar for Laura Van Doore lauravandoore
463
34k
The MySQL Ecosystem @ GitHub 2015
Avatar for Sam Lambert samlambert
251
13k
Testing 201, or: Great Expectations
Avatar for Joseph Mastey jmmastey
46
7.8k
jQuery: Nuts, Bolts and Bling
Avatar for Doug Neiner dougneiner
65
8.3k
Design and Strategy: How to Deal with People Who Don’t "Get" Design
Avatar for Morgane Peng morganepeng
132
19k
I Don’t Have Time: Getting Over the Fear to Launch Your Podcast
Avatar for Joe Casabona jcasabona
34
2.6k
個人開発の失敗を避けるイケてる考え方 / tips for indie hackers
Avatar for panda_program panda_program
122
21k
Large-scale JavaScript Application Architecture
Avatar for Addy Osmani addyosmani
515
110k
Done Done
Avatar for chrislema chrislema
186
16k
Navigating Team Friction
Avatar for Lara Hogan lara
191
16k
The Art of Programming - Codeland 2020
Avatar for Erika Heidi erikaheidi
56
14k
A better future with KSS
Avatar for Kyle Neath kneath
240
18k

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