How to Use AI to harness Google APIs
by
Jonathon Roberts
Link
Embed
Share
Beginning
This slide
Copy link URL
Copy link URL
Copy iframe embed code
Copy iframe embed code
Copy javascript embed code
Copy javascript embed code
Share
Tweet
Share
Tweet
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