Slide 1
Slide 1 text
No content
Slide 2
Slide 2 text
Technical Lead, Fly High Media
Interested in Speeding up SEO
auditing & workflows
Slide 3
Slide 3 text
ARE YOU USING AI TO
GENERATE CODES TO
SPEED UP
WORKFLOW?
Slide 4
Slide 4 text
IS ANYONE
CURRENTLY USING
GOOGLE APIS?
Slide 5
Slide 5 text
TOOLS
Google Sheets
Google App
Scripts
ChatGPT
Slide 6
Slide 6 text
WHY USE GOOGLE
SCRIPTS & AI?
Slide 7
Slide 7 text
SPEED
Slide 8
Slide 8 text
FREE
Slide 9
Slide 9 text
CUSTOMISABLE
Slide 10
Slide 10 text
WHAT GOOGLE APIS
ARE USEFUL FOR
SEARCH MARKETERS?
Slide 11
Slide 11 text
GOOGLE SEARCH
CONSOLE API
Slide 12
Slide 12 text
GOOGLE ANALYTICS
METRICS
Slide 13
Slide 13 text
GOOGLE ADS API
Slide 14
Slide 14 text
GOOGLE BUSINESS
PROFILE API
Slide 15
Slide 15 text
PAGE SPEED &
CORE WEB VITALS
CRUX API / GTMETRIX
Slide 16
Slide 16 text
OTHER APIS
Slide 17
Slide 17 text
WHAT ARE
GOOGLE APP SCRIPTS?
Slide 18
Slide 18 text
No content
Slide 19
Slide 19 text
No content
Slide 20
Slide 20 text
No content
Slide 21
Slide 21 text
LET’S START
EXTRACTING DATA
FROM APIS!
Slide 22
Slide 22 text
GOOGLE SEARCH
CONSOLE API
Slide 23
Slide 23 text
GET APIS FROM
GOOGLE DEVELOPERS
CONSOLE
Slide 24
Slide 24 text
No content
Slide 25
Slide 25 text
FLYHIGHMEDIA.CO.UK/
BRIGHTONSEO-2025
GUIDE
Slide 26
Slide 26 text
LET’S EXTRACT THE
CLICKS & IMPRESSIONS
FOR MULTIPLE URLS
Slide 27
Slide 27 text
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
Slide 28
Slide 28 text
ENSURE IT HAS SOMETHING
LIKE THIS
CLIENT_ID = 'YOUR_OAUTH_CLIENT_ID';
CLIENT_SECRET = 'YOUR_OAUTH_CLIENT_SECRET';
Slide 29
Slide 29 text
ASK CHATGPT/AI
I WANT TO PROVIDE CLIENT ID &
CLIENT SECRET TO GET THE DATA
FROM GOOGLE SEARCH CONSOLE
Slide 30
Slide 30 text
No content
Slide 31
Slide 31 text
ASK CHATGPT/AI
I WANT TO PROVIDE THE DATES
AND THE DOMAIN IN THE
FORMULA FROM A CELL
Slide 32
Slide 32 text
SITE URL
DOMAIN PROPERTY SC-DOMAIN:YOURDOMAIN.COM
URL PREFIX HTTPS://WWW.YOURDOMAIN.COM
Slide 33
Slide 33 text
ENABLE OAUTH2.0 IN
GOOGLE APP SCRIPTS
Slide 34
Slide 34 text
No content
Slide 35
Slide 35 text
No content
Slide 36
Slide 36 text
No content
Slide 37
Slide 37 text
1B7FSRK5ZI6L1RSXXTDGDEUS
PZLUKDSI4KGUTMORSTQHH
GBZBKMUN4IDF
Slide 38
Slide 38 text
No content
Slide 39
Slide 39 text
No content
Slide 40
Slide 40 text
RECOMMENDATION
SEPERATE METRICS INTO DIFFERENT FORMULAS
ASK CHATGPT/AI
Slide 41
Slide 41 text
AUTHORISE THE SCRIPT
Slide 42
Slide 42 text
No content
Slide 43
Slide 43 text
No content
Slide 44
Slide 44 text
No content
Slide 45
Slide 45 text
COPY URL AND OPEN URL IN NEW
TAB
&
THEN FOLLOW INSTRUCTIONS TO
VALIDATE THE CODE
Slide 46
Slide 46 text
No content
Slide 47
Slide 47 text
No content
Slide 48
Slide 48 text
COPY FORMULA (FROM
CHATGPT/AI) AND START
USING THE CUSTOM FORMULA
YOU HAVE MADE!
Slide 49
Slide 49 text
OTHER USE CASES
Slide 50
Slide 50 text
GSC
AUTOMATED REPORTING OF
SITE PERFORMANCE
Slide 51
Slide 51 text
GSC
IDENTIFYING AND
MONITORING CRAWL ERRORS
Slide 52
Slide 52 text
GSC
GET RELATED QUERIES TO
CONTENT
Slide 53
Slide 53 text
GA4
MONITOR E-COMMERCE
TRACKING DATA
Slide 54
Slide 54 text
GA4
MONTHLY TRAFFIC OVERVIEW
Slide 55
Slide 55 text
GA4
TRACKING CAMPAIGN UTM
PARAMETER PERFORMANCE
Slide 56
Slide 56 text
GOOGLE BUSINESS LISTINGS
REPORTING ON CUSTOMER
ACTIONS AND INSIGHTS FOR
MULTIPLE LISTINGS
Slide 57
Slide 57 text
CRUX API
EXTRACT REAL-USER
EXPERIENCE DATA (CORE WEB
VITALS)
Slide 58
Slide 58 text
WHY NOT USE OTHER
TOOLS?
Slide 59
Slide 59 text
EXPENSIVE
Slide 60
Slide 60 text
DATA IS NOT
CUSTOMISABLE
Slide 61
Slide 61 text
REAL-TIME
COLLABORATION
Slide 62
Slide 62 text
ISSUES YOU MAY
COME ACROSS
Slide 63
Slide 63 text
API QUOTAS AND
LIMITS
1
Slide 64
Slide 64 text
AUTHENTICATION
ERRORS
2
Slide 65
Slide 65 text
DATA FORMATTING
ISSUES
3
Slide 66
Slide 66 text
USE AI TO
TROUBLESHOOT ANY
ISSUES
4
Slide 67
Slide 67 text
GET ACCESS TO
SLIDES
SPEAKERDECK.COM/
JONATHONROBERTSSEO
Slide 68
Slide 68 text
FLYHIGHMEDIA.CO.UK/
BRIGHTONSEO-2025
GOOGLE API
GENERATION GUIDE
Slide 69
Slide 69 text
ANY FURTHER
QUESTIONS?
linkedin.com/in/jonathon-roberts-seo
jonathonr.bsky.social
@jonathonrseo
www.flyhighmedia.co.uk