Automating SEO with AI-Driven App Scripts

In this presentation, Panos Kondilis reveals a suite of App Script tools designed to streamline SEO tasks. Developed by a team without programming experience, these tools emerged from leveraging AI technology, clear needs, effective prompting, and relentless testing.

We've created seven tools that automate time-consuming tasks, generate unique reports, and perform functions previously only possible with commercial software. These innovations demonstrate how practical problem-solving combined with AI and scripting can revolutionize SEO operations.

Transcript

1. Automating SEO with AI-Driven App Scripts Panos Kondylis SLEED Speakerdeck.com/pkondylis linkedin.com/in/kondilis/ panosko
2. About Me Panos Kondylis Director of SEO 22 years of experience in DM & SEO Married, father of 🧑👩 Love for 🎶,🏀 & SEO Thinks “The Wire” is the best TV ever made
3. About SLEED Based in Greece Founded in 2010 Clients from more than 25 industries An inhouse team of 160+ Sleeders E- Business Agency of the Year & E-Commerce Agency of the year
4. What we will see today SEO scripts that accelerate our day2days Tools with unique functionality How these scripts have helped us? 01 02 03
5. Chat GPT Arrived! Hello SEOs! This is a world full of possibilities
6. Our team started experimenting… Time to avenge for the endless follow ups to devs
7. Tools created, productivity boosted! If Oasis are still relevant in the 2020’s, anything is possible, humans!
8. So we’ve created 2 types of tools The ones that accelerate our day2day ..and the ones with REALLY unique functionality
9. The SEO Tools
10. The ones that accelerate our day2days What an N-Gram is? N-Gram Analysis of Keywords 1 An n-gram is a sequence of n adjacent words in particular order.
11. The ones that accelerate our day2days What is this tool about? Helps us cluster our keyword research file into N-Grams N-Gram Analysis of Keywords 1
12. The ones that accelerate our day2days How does it work? 1 We insert a keyword research file (from any tool like GSC, SEMRush, etc). 2 Clusters the keywords in 1-grams, 2-grams and 3-grams. N-Gram Analysis of Keywords 1
13. The ones that accelerate our day2days Identifies Key Topics & Patterns What is the value? N-Gram Analysis of Keywords 1 1 2 Content Strategy resonates easily and fast
14. Raw Data 1 Gram 2 Gram 3 Gram The ones that accelerate our day2days Insights: You know in a glimpse of an eye that: • HP, Dell & Lenovo are the most searched brands • People are searching for “how to’s” and “laptops for” → This means we need to create a. Pages with guides for laptops b. Pages with Laptops for various needs (i.e for Gaming, for University, for Students etc) N-Gram Analysis of Keywords 1
15. What is this tool? Monitors if the primary keyword -for which a web page ranks- is present in the page’s meta title. The ones that accelerate our day2days The ones that offer UNIQUE functionalities Title Optimisation Checker 2
16. How does it work? Title Optimisation Checker The ones that accelerate our day2days The ones that offer UNIQUE functionalities 2
17. What is the value? The ones that accelerate our day2days • For every keyword our pages rank for, the script checks if these keywords are present in these pages’ Meta Titles. • This insight allows us to either create new dedicated pages or optimise current ones to capitalize on these opportunities. The ones that offer UNIQUE functionalities Title Optimisation Checker 2
18. What is this tool? We monitor our website’s Web Vitals vs competition. [Can be updated regularly, upon our needs] The ones that accelerate our day2days CrUX Report with Competitors The ones that offer UNIQUE functionalities 3
19. How does it work? The ones that accelerate our day2days 1 Collects data automatically on a daily basis (LCP, INP, CLS, TTFB, etc), via the CrUX API. 2 Shows in one view how our direct competitors doing in this metric. CrUX Report with Competitors The ones that accelerate our day2days The ones that offer UNIQUE functionalities 3
20. CrUX Report with Competitors The ones that offer UNIQUE functionalities 3
21. The ones that accelerate our day2days Bulk Recaching Tool | Prerender.io API What is Prerender.io? • Improves SEO for JavaScript-heavy websites by rendering static HTML. • Enhances crawlability by converting dynamic content into SEO friendly pages. • Caches rendered pages for faster delivery and reduced server load. • Supports modern frameworks like React, Angular, and Vue for seamless integration. The ones that accelerate our day2days The ones that offer UNIQUE functionalities 4 The problem: Pages are recached every X days
22. The ones that accelerate our day2days Bulk Recaching Tool | Prerender.io API What is this tool? 1. We add a list of URLs we want to recache, or a specific sitemap.xml 2. All our URLs are added in the recache queue of Prerender.io The ones that accelerate our day2days The ones that offer UNIQUE functionalities 4
23. The ones that accelerate our day2days Why this is important? i.e Black Friday: Prices, content, page structure will change (maybe more than once) → This way we can re-cache specific pages, saving time and money! The ones that accelerate our day2days The ones that offer UNIQUE functionalities 4 Bulk Recaching Tool | Prerender.io API
24. How does it work? The ones that accelerate our day2days 1 2 We insert our keyword list We use our custom prompts, using OpenAI API. Bulk Creation Tool | Content The ones that accelerate our day2days The ones that offer UNIQUE functionalities 5 No need to pay for plugins 2 Gives as output an H1, a meta title, meta description & FAQs for each page
25. The ones that accelerate our day2days Bulk Creation Tool | Content The ones that accelerate our day2days The ones that offer UNIQUE functionalities 5
26. What is this tool? Indexing API script The ones that accelerate our day2days The scripts uses Indexing API to mass-index up to 200 pages/day, from a selected set of URLs we enter (instead of the manual 10/day limit) 6
27. The ones that accelerate our day2days What is this tool? • Upload an Organic Position Rankings file (from GSC, SEMRush, etc.) • Generate a Cannibalization Analysis report highlighting competing keywords across pages. Cannibalization Analysis report The ones that accelerate our day2days The ones that offer UNIQUE functionalities 7
28. The ones that accelerate our day2days Cannibalization Analysis report The ones that accelerate our day2days The ones that offer UNIQUE functionalities 7
29. Tools for various wants and needs • Alt Text Bulk Creation Tool • Google Ads Scripts • More in the making… But there is more…
30. How these scripts have helped us?
31. Is there any benefit? > 30 hrs saved / month Provide Unique Information More insights Perform tasks we could have not done otherwise For each person, by using the scripts Such as CRUX Insights Vs the Competition Via API use, such as Prerender.io or Indexing API We can analyse our content much more efficiently
32. Automating SEO with AI-Driven App Scripts Panos Kondylis SLEED Speakerdeck.com/pkondylis linkedin.com/in/kondilis/ panosko