Lock in $30 Savings on PRO—Offer Ends Soon! ⏳
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
How to Use AI to harness Google APIs
Search
Jonathon Roberts
April 11, 2025
Marketing & SEO
0
820
How to Use AI to harness Google APIs
Jonathon Roberts
April 11, 2025
Tweet
Share
More Decks by Jonathon Roberts
See All by Jonathon Roberts
TechSEO North Feb 2025 - How To Implement Schema to Custom CMSs
jonathonrobertsseo
0
59
BrightonSEO October 2024 - How to Speed Up Content Audits using ChatGPT
jonathonrobertsseo
3
850
Other Decks in Marketing & SEO
See All in Marketing & SEO
BrightonSEO - Matt Beswick
bezz1234
0
310
It's ALL AI search: Building a unified view for growth
raygrieselhuber
PRO
0
640
Introduction - How AI-driven platforms reshaping referral traffic and SEO strategies - World News Media Congress 2025 - WAN-IFRA
clarasoteras
0
120
A Friggin' Sweet Insider Guide to Google Sheets for SEO
greggifford
PRO
3
650
Content Decay the silent threat to website performance
richardgeorge
0
290
採用広報強化サービス 「ななごータレントプール」ご紹介 / nanago_talentpool
nanago
0
800
Have SEOs Ruined the Internet? - User Awareness of SEO in 2025
akashhashmi
0
160
0-Click SEO. How to optimize for visibility, awareness and memorability.
gfiorelli1
0
250
Brand Signals Will Decide Your Visibility in AI-Powered Search; Where to Double Down.
brockbankjames
PRO
0
220
Crafting your authority engine: E-E-A-T & machine-readable SEO for AI
cristianow
PRO
0
300
Humanistic SEO | brightonSEO | Megan Roberts
meganjane
0
330
Do Core Web Vitals Actually Matter for SEO?
mjbpdx
0
1.9k
Featured
See All Featured
Designing Experiences People Love
moore
142
24k
ピンチをチャンスに:未来をつくるプロダクトロードマップ #pmconf2020
aki_iinuma
127
54k
Reflections from 52 weeks, 52 projects
jeffersonlam
355
21k
Responsive Adventures: Dirty Tricks From The Dark Corners of Front-End
smashingmag
253
22k
Evolution of real-time – Irina Nazarova, EuRuKo, 2024
irinanazarova
9
1k
Helping Users Find Their Own Way: Creating Modern Search Experiences
danielanewman
31
3k
Raft: Consensus for Rubyists
vanstee
140
7.2k
Statistics for Hackers
jakevdp
799
230k
Fashionably flexible responsive web design (full day workshop)
malarkey
407
66k
Designing for humans not robots
tammielis
254
26k
GraphQLとの向き合い方2022年版
quramy
49
14k
jQuery: Nuts, Bolts and Bling
dougneiner
65
8k
Transcript
None
Technical Lead, Fly High Media Interested in Speeding up SEO
auditing & workflows
ARE YOU USING AI TO GENERATE CODES TO SPEED UP
WORKFLOW?
IS ANYONE CURRENTLY USING GOOGLE APIS?
TOOLS Google Sheets Google App Scripts ChatGPT
WHY USE GOOGLE SCRIPTS & AI?
SPEED
FREE
CUSTOMISABLE
WHAT GOOGLE APIS ARE USEFUL FOR SEARCH MARKETERS?
GOOGLE SEARCH CONSOLE API
GOOGLE ANALYTICS METRICS
GOOGLE ADS API
GOOGLE BUSINESS PROFILE API
PAGE SPEED & CORE WEB VITALS CRUX API / GTMETRIX
OTHER APIS
WHAT ARE GOOGLE APP SCRIPTS?
None
None
None
LET’S START EXTRACTING DATA FROM APIS!
GOOGLE SEARCH CONSOLE API
GET APIS FROM GOOGLE DEVELOPERS CONSOLE
None
FLYHIGHMEDIA.CO.UK/ BRIGHTONSEO-2025 GUIDE
LET’S EXTRACT THE CLICKS & IMPRESSIONS FOR MULTIPLE URLS
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
ENSURE IT HAS SOMETHING LIKE THIS CLIENT_ID = 'YOUR_OAUTH_CLIENT_ID'; CLIENT_SECRET
= 'YOUR_OAUTH_CLIENT_SECRET';
ASK CHATGPT/AI I WANT TO PROVIDE CLIENT ID & CLIENT
SECRET TO GET THE DATA FROM GOOGLE SEARCH CONSOLE
None
ASK CHATGPT/AI I WANT TO PROVIDE THE DATES AND THE
DOMAIN IN THE FORMULA FROM A CELL
SITE URL DOMAIN PROPERTY SC-DOMAIN:YOURDOMAIN.COM URL PREFIX HTTPS://WWW.YOURDOMAIN.COM
ENABLE OAUTH2.0 IN GOOGLE APP SCRIPTS
None
None
None
1B7FSRK5ZI6L1RSXXTDGDEUS PZLUKDSI4KGUTMORSTQHH GBZBKMUN4IDF
None
None
RECOMMENDATION SEPERATE METRICS INTO DIFFERENT FORMULAS ASK CHATGPT/AI
AUTHORISE THE SCRIPT
None
None
None
COPY URL AND OPEN URL IN NEW TAB & THEN
FOLLOW INSTRUCTIONS TO VALIDATE THE CODE
None
None
COPY FORMULA (FROM CHATGPT/AI) AND START USING THE CUSTOM FORMULA
YOU HAVE MADE!
OTHER USE CASES
GSC AUTOMATED REPORTING OF SITE PERFORMANCE
GSC IDENTIFYING AND MONITORING CRAWL ERRORS
GSC GET RELATED QUERIES TO CONTENT
GA4 MONITOR E-COMMERCE TRACKING DATA
GA4 MONTHLY TRAFFIC OVERVIEW
GA4 TRACKING CAMPAIGN UTM PARAMETER PERFORMANCE
GOOGLE BUSINESS LISTINGS REPORTING ON CUSTOMER ACTIONS AND INSIGHTS FOR
MULTIPLE LISTINGS
CRUX API EXTRACT REAL-USER EXPERIENCE DATA (CORE WEB VITALS)
WHY NOT USE OTHER TOOLS?
EXPENSIVE
DATA IS NOT CUSTOMISABLE
REAL-TIME COLLABORATION
ISSUES YOU MAY COME ACROSS
API QUOTAS AND LIMITS 1
AUTHENTICATION ERRORS 2
DATA FORMATTING ISSUES 3
USE AI TO TROUBLESHOOT ANY ISSUES 4
GET ACCESS TO SLIDES SPEAKERDECK.COM/ JONATHONROBERTSSEO
FLYHIGHMEDIA.CO.UK/ BRIGHTONSEO-2025 GOOGLE API GENERATION GUIDE
ANY FURTHER QUESTIONS? linkedin.com/in/jonathon-roberts-seo jonathonr.bsky.social @jonathonrseo www.flyhighmedia.co.uk