Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Sign up for free
Menu
Search
Features
All features
Private URLs
Password Protection
Custom URLS
Scheduled publishing
Remove Branding
Restrict embedding
Deck Collections
Notes
Features
All features
Private URLs
Password Protection
Custom URLS
Scheduled publishing
Remove Branding
Restrict embedding
Deck Collections
Notes
Explore
Featured decks
Featured speakers
Programming
Technology
Storyboards
Explore
Featured decks
Featured speakers
Programming
Technology
Storyboards
Pricing
Search
Sign in
Sign up for free
How to Use AI to harness Google APIs
Search
Jonathon Roberts
April 11, 2025
Marketing & SEO
1.1k
0
Share
Embed
Copy iframe code
Copy JS code
Copy link
Start on current slide
How to Use AI to harness Google APIs
Jonathon Roberts
April 11, 2025
Transcript
69 slides
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
More Decks by Jonathon Roberts
See All by Jonathon Roberts
Vibe Coding Your Way To Custom SEO Tools
jonathonrobertsseo
0
65
From Crawl To Clarity Automating SEO Audits With Node.JS
jonathonrobertsseo
0
560
TechSEO North Feb 2025 - How To Implement Schema to Custom CMSs
jonathonrobertsseo
0
110
BrightonSEO October 2024 - How to Speed Up Content Audits using ChatGPT
jonathonrobertsseo
3
1.1k
Other Decks in Marketing & SEO
See All in Marketing & SEO
Log File Forensics - How To Analyze Log Files for AI Search BrightonSEO San Diego 2026
zjchahalis
0
440
Profile Backlinks Not Indexed: The 8-Step Fix Checklist
speedyindexteam
PRO
1
1.5k
Growing Your Brand in AI Search - by @Aleyda at #FatJocial
aleyda
0
210
Who owns AI visibility and who gets the budget?
decabbit
0
160
『Peatix』利用ユーザーインタビューサマリー【広告出稿のポイント】
sairu_inc
0
390
Ecommerce In the Age of AI Search: Shifts, Risks and Strategic Moves
aleyda
0
410
Braze✕AIで実現するゲーミフィケーション実装アプローチ
sarosaro
0
140
The New Citation Economy | AEO Research Deck Sept 2026
joshbly
0
330
Diagnosing Rendering & Indexing Issues with the URL Inspection API
manuelmadeddu
0
130
20+ GEO-Experimente, 100 Mio. Websites: Was wir getestet haben, was gescheitert ist – und was in der KI-Suche wirklich funktioniert (OMT)
thomaspeham
0
100
Buying Ads in ChatGPT: what the data says so far
joss1
0
250
How to Build an AI Skill for your SEO Workflow: A Sitebulb Webinar
graydotco
0
290
Featured
See All Featured
Building a Scalable Design System with Sketch
lauravandoore
464
34k
Taking LLMs out of the black box: A practical guide to human-in-the-loop distillation
inesmontani
PRO
3
2.5k
Designing for Timeless Needs
cassininazir
1
570
Visualizing Your Data: Incorporating Mongo into Loggly Infrastructure
mongodb
50
10k
Unlocking the hidden potential of vector embeddings in international SEO
frankvandijk
0
1k
Navigating Weather and Climate Data
rabernat
0
590
The Organizational Zoo: Understanding Human Behavior Agility Through Metaphoric Constructive Conversations (based on the works of Arthur Shelley, Ph.D)
kimpetersen
PRO
0
540
New Earth Scene 8
popppiees
5
2.9k
Measuring Dark Social's Impact On Conversion and Attribution
stephenakadiri
2
330
The untapped power of vector embeddings
frankvandijk
2
2k
The B2B funnel & how to create a winning content strategy
katarinadahlin
PRO
1
620
HDC tutorial
michielstock
2
1k