Upgrade to Pro — share decks privately, control downloads, hide ads and more …

How AI Can Automate Your SEO Day2Day

Sponsored · SiteGround - Reliable hosting with speed, security, and support you can count on.

How AI Can Automate Your SEO Day2Day

Discover 20+ practical AI-powered tools and automations to streamline your daily SEO workflows, from bulk content creation to technical analysis and reporting.

Avatar for Athens SEO

Athens SEO PRO

May 27, 2026

More Decks by Athens SEO

Other Decks in Marketing & SEO

Transcript

  1. ATHENS SEO 2026 · MAY 22–23 Your photo here HOW

    AI CAN AUTOMATE YOUR SEO DAY2DAY Konstantinos Sfyris SEO Director · SLEED sleed.com CONNECT ON LINKEDIN Scan to connect
  2. SPEAKER About Me SEO Director at SLEED, leading SEO initiatives

    for diverse brands. Bachelor's & Master's graduate in DMST & Marketing from Athens University of Economics and Business. Passionate about leadership, coaching, and creating positive, high-trust work environments. Love consulting and driving measurable business growth. Love for Sports (huge Olympiakos fan), marathon runner, gym, travel , and hanging around with friends.
  3. Today's Agenda AI Automation Ideas Explore what we can automate

    in our SEO lives with AI Practical Tools 20+ tools to streamline daily workflows Real Examples Deep dive into implementation strategies
  4. THE SLEED AI TOOLKIT Tools We Built In-House Flagship automations

    running in production across 250+ clients. Mini Audit in 1 Click 2-4 hour audit in 5 min for €0.07: Ahrefs + terminal + Playwright + scraper + PPT auto- generation SERP Analyzer Tool Input a keyword, get the full SERP with meta titles, DR, CWV, schema, word count per result Core Update Checker Domain vs up to 9 competitors: traffic, keywords, update-by-update impact, CWV, next-step insights Themes Analysis for News Splits GSC, Discover & Google News clicks into themes per channel to spot winners and decliners Bulk Content Creator Keyword or URL in → meta title, description, H1, FAQs and on-page copy out, at scale Custom GPTs per Client Client tone-of-voice GPT with sub-projects for metas, FAQs, briefs, product descriptions Cannibalization Tool #1 (GSC) GSC export in, cannibalization report and detail view out with one click Cannibalization Analysis #2 (SEMRUSH) SEMrush-based deeper cannibalization pass with script-generated results tab CRUX Report with Competitors Chrome User Experience Report data compared against competitors in one view Bulk Recaching Tool Batch cache refresh via the Prerender.io API — no manual warm-up Re-indexing via Indexing API Mass URL re-indexing through Google's Indexing API, orchestrated via Apps Script
  5. THE SLEED AI TOOLKIT Tools We Built In-House Support automations

    for the repetitive work. Alt Text Creator Bulk image alt text from image URLs via GPT-for-Sheets formula Meta Titles Creator Bulk meta title generation from page URLs in a Google Sheet Meta Descriptions Creator Bulk meta description generation from page URLs On-Page Content Creator Bulk on-page SEO copy generation, URL in → description out Product Descriptions Template Tuned GPT-for-Sheets template for product copy at scale Meta Title SERP Checker Verifies how your titles actually render in Google SERPs N-Gram Analysis Runs n-gram patterns over keyword research files to surface clusters Menu Link Extractor Chrome extension that exports any site's full menu tree to CSV FAQs Identifier Bulk-checks URLs for FAQ sections and returns the H1 of each page URL Status Checker Bulk 200/301/302/404/403/500/304 checker with redirect destinations Sitemap Checker Bulk-validates whether a list of URLs appears in the sitemap Backlinking Analysis Feeds a URL list into a prompt that auto-categorizes each referring domain
  6. How much time would you save if you could automate

    your initial 2h-5h audit for an offer or for setting up the stage for your official audit? 2’ Audit in 1 Click
  7. How much time would you save if you could automate

    your initial 2h-5h audit for an offer or for setting up the stage for your official audit? 2’ Audit in 1 Click Translation: haha good he?
  8. We’ve created an auditor running on terminal, having connected an

    LLM, a scraper, a SEO tool, PSI, and a PPT creator etc 2’ Audit in 1 Click
  9. We’ve created an auditor running on terminal, having connected an

    LLM, a scraper, a SEO tool, PSI, and a PPT creator etc 2’ Audit in 1 Click
  10. The main difficulty on the creation of this tool is

    to make it work LIKE YOU. The same procedure. You will find the way to automate it if you write down your WoW! 2’ Audit in 1 Click
  11. • Let’s say you have a client that has a

    “money” keyword that drives 25% of traffic & revenue. SERP Analyzer
  12. • Let’s say you have a client that has a

    “money” keyword that drives 25% of traffic & revenue. • If you lose one position you start worrying and if you win you start popping up SERP Analyzer
  13. • Let’s say you have a client that has a

    “money” keyword that drives 25% of traffic & revenue. • If you lose one position you start worrying and if you win you start popping up If you lose one position, what would you check? SERP Analyzer
  14. • Let’s say you have a client that has a

    “money” keyword that drives 25% of traffic & revenue. • If you lose one position you start worrying and if you win you start popping up If you lose one position, what would you check? - open the first 5 results to audit their on page? - metadata, do they have descriptions, FAQs SERP Analyzer
  15. • Let’s say you have a client that has a

    “money” keyword that drives 25% of traffic & revenue. • If you lose one position you start worrying and if you win you start popping up If you lose one position, what would you check? - open the first 5 results to audit their on page? - metadata, do they have descriptions, FAQs - open 5 tabs of PSI to audit one by one their CWV? SERP Analyzer
  16. • Let’s say you have a client that has a

    “money” keyword that drives 25% of traffic & revenue. • If you lose one position you start worrying and if you win you start popping up If you lose one position, what would you check? - open the first 5 results to audit their on page? - metadata, do they have descriptions, FAQs - open 5 tabs of PSI to audit one by one their CWV? - open 5 tabs for Rich Results + 5 tabs for Schema Validator in order to audit schemas? SERP Analyzer
  17. • Let’s say you have a client that has a

    “money” keyword that drives 25% of traffic & revenue. • If you lose one position you start worrying and if you win you start popping up If you lose one position, what would you check? - open the first 5 results to audit their on page? - metadata, do they have descriptions, FAQs - open 5 tabs of PSI to audit one by one their CWV? - open 5 tabs for Rich Results + 5 tabs for Schema Validator in order to audit schemas? - open up a SEO tool to compare DRs and what changed? SERP Analyzer
  18. • Let’s say you have a client that has a

    “money” keyword that drives 25% of traffic & revenue. • If you lose one position you start worrying and if you win you start popping up If you lose one position, what would you check? - open the first 5 results to audit their on page? - metadata, do they have descriptions, FAQs - open 5 tabs of PSI to audit one by one their CWV? - open 5 tabs for Rich Results + 5 tabs for Schema Validator in order to audit schemas? - open up a SEO tool to compare DRs and what changed? - and maybe create a document that sums it up? SERP Analyzer
  19. • Let’s say you have a client that has a

    “money” keyword that drives 25% of traffic & revenue. • If you lose one position you start worrying and if you win you start popping up If you lose one position, what would you check? - open the first 5 results to audit their on page? - metadata, do they have descriptions, FAQs - open 5 tabs of PSI to audit one by one their CWV? - open 5 tabs for Rich Results + 5 tabs for Schema Validator in order to audit schemas? - open up a SEO tool to compare DRs and what changed? - and maybe create a document that sums it up? CONGRATULATIONS THEN SERP Analyzer
  20. • Let’s say you have a client that has a

    “money” keyword that drives 25% of traffic & revenue. • If you lose one position you start worrying and if you win you start popping up If you lose one position, what would you check? - open the first 5 results to audit their on page? - metadata, do they have descriptions, FAQs - open 5 tabs of PSI to audit one by one their CWV? - open 5 tabs for Rich Results + 5 tabs for Schema Validator in order to audit schemas? - open up a SEO tool to compare DRs and what changed? - and maybe create a document that sums it up? CONGRATULATIONS THEN, you have 21 new tabs SERP Analyzer
  21. • Let’s say you have a client that has a

    “money” keyword that drives 25% of traffic & revenue. • If you lose one position you start worrying and if you win you start popping up If you lose one position, what would you check? - open the first 5 results to audit their on page? - metadata, do they have descriptions, FAQs - open 5 tabs of PSI to audit one by one their CWV? - open 5 tabs for Rich Results + 5 tabs for Schema Validator in order to audit schemas? - open up a SEO tool to compare DRs and what changed? - and maybe create a document that sums it up? CONGRATULATIONS THEN, you have 21 new tabs & brain fog to mix and match everything from this tabs into a Document. SERP Analyzer
  22. Core Update Checker You have a newsroom and thennn.. a

    Core Update hits you! What do you have to do?
  23. Core Update Checker You have a newsroom and thennn.. a

    Core Update hits you! What do you have to do? - Read about the update (and maybe the 2-3 previous ones)
  24. Core Update Checker You have a newsroom and thennn.. a

    Core Update hits you! What do you have to do? - Read about the update (and maybe the 2-3 previous ones) - See your client’s data in order to see if it impacted them (high level at first)
  25. Core Update Checker You have a newsroom and thennn.. a

    Core Update hits you! What do you have to do? - Read about the update (and maybe the 2-3 previous ones) - See your client’s data in order to see if it impacted them (high level at first) - See what your competitors are doing
  26. Core Update Checker You have a newsroom and thennn.. a

    Core Update hits you! What do you have to do? - Read about the update (and maybe the 2-3 previous ones) - See your client’s data in order to see if it impacted them (high level at first) - See what your competitors are doing - and Mix and Match
  27. Core Update Checker How to: You just input your domain

    and optionally 1-9 competitors. Then you get an overview with 5 tabs:
  28. Core Update Checker Tab a) General Overview General Overview with

    organic traffic, total visits, keywords, backlinks, DR & Core Web Vitals Analysis
  29. Core Update Checker Tab b) Keywords Overview Total, Branded, Non

    Branded, Top Pages and before and after rankings after the last Google Update
  30. Core Update Checker Tab c) all Google Updates in one

    place • Firstly 3-4 lines with key insights for each core update and • authoritative references if you want to dive in and dig more. • Also we split the updates in core, spam, discover and other (smaller updates)
  31. Core Update Checker Tab d) Competition Overview How does our

    traffic compare to our competitors last 12 month with lines pointing each update that happened.
  32. Core Update Checker Tab d) Competition Overview How does our

    traffic compare to our competitors last 12 month with lines pointing each update that happened. Sexiest part: how does each core update impacted each site
  33. Core Update Checker Tab e) Core Web Vitals Overview (vs

    Competition) (no need for description obvious from the title )
  34. Core Update Checker Tab e) Insights Tab What if you

    could have an insights tab for your domain that sums up all previous tabs and a comparison with each competitor? Well you can!
  35. CONTENT TOOLS Bulk Content Creator Bulk Content Creator for SEO

    Step 1: Create App Script that allows talking with an LLM in Sheets
  36. Bulk Content Creator for SEO Step 1: Create App Script

    that allows talking with an LLM in Sheets CONTENT TOOLS Bulk Content Creator
  37. Bulk Content Creator for SEO Step 2: Add your prompts

    and inputs, in order to create a meta title, meta description, H1, On page content, FAQs CONTENT TOOLS Bulk Content Creator
  38. Bulk Content Creator for SEO Step 2: Add your prompts

    and inputs, in order to create a meta title, meta description, H1, On page content, FAQs CONTENT TOOLS Bulk Content Creator
  39. Automated analysis tool built in Google Sheets that identifies trending

    themes, content gaps, and topic clusters for news websites. This tool helps us understand what content resonates with audiences and where opportunities exist per SEO Channel. Themes Analysis for News Sites
  40. Let’s take as an example a political Newsroom of Greece

    The task is to understand which pillars of our site are: • perform • which underperform per SEO channel (Google Search, Google News, Google Discover) Themes Analysis for News Sites
  41. Firstly, we export YoY Data from GSC from the 3

    channels Themes Analysis for News Sites
  42. Step 1: Create an App Script (with the assistance of

    an LLM) that allows us to interact with an LLM in G sheets Themes Analysis for News Sites
  43. Step 1: Create an App Script (with the assistance of

    an LLM) that allows us to interact with an LLM in G sheets Themes Analysis for News Sites
  44. Step 4: Filter the theme column with “Politics”. For each

    cell in politics paste the following prompt Themes Analysis for News Sites
  45. Step 5: Create one Pivot Table for Themes and one

    Political Parties Themes Analysis for News Sites
  46. Google Search 2024 Clicks Clicks Diff Clicks Diff % Discover

    2024 Clicks Clicks Diff Clicks Diff % G. News 2024 Clicks Clicks Diff Clicks Diff % Branded 1,646,542 -138,105 -7.74% Politics 3,942,594 3,194,361 426.92% Politics 127,454 93,541 275.83% Politics 268,079 116,097 76.39% General News 1,274,578 1,024,642 409.96% Crime 62,094 50,714 445.64% General News 169,335 114,549 209.08% Crime 1,071,894 1,000,984 1411.63% General News 39,509 29,302 287.08% Sports 79,394 74,240 1440.43% International 1,001,464 963,203 2517.45% Economy/Labor 35,029 26,516 311.48% Earthquake/Fire/ Floods/Disaster s 73,280 61,539 524.14% Economy/Labor 821,379 593,846 260.99% Sports 27,572 23,126 520.15% Economy/Labor 33,587 26,848 398.40% Health 791,025 658,017 494.72% Earthquake/Fire/Flo ods/Disasters 24,777 19,927 410.87% International 32,487 28,929 813.07% Earthquake/Fire/Flood s/Disasters 517,502 386,654 295.50% International 20,884 19,219 1154.29% Crime 25,976 14,219 120.94% Sports 496,664 453,309 1045.57% Wars 11,893 11,440 2525.39% Lifestyle 22,994 16,713 266.09% Wars 326,093 299,041 1105.43% Gossip 11,772 9,976 555.46% Gossip 22,051 16,982 335.02% Media/Communication 238,918 228,636 2223.65% Lifestyle 10,702 6,384 147.85% Environment 17,209 15,810 1130.09% Lifestyle 218,315 190,581 687.17% Health 9,251 5,244 130.87% Health 17,005 15,701 1204.06% Education 125,494 -1,771 -1.39% Olympic Games 9,047 9,047 #DIV/0! Education 15,393 13,441 688.58% Environment 88,816 80,131 922.64% Environment 3,693 3,028 455.34% Media/Communi cation 14,444 9,967 222.63% Olympic Games 39,088 39,088 #DIV/0! Media/Communicati on 3,480 2,574 284.11% Wars 9,719 6,619 213.52% Gossip 11,234 -117,198 -91.25% Technology 1,432 -306 -17.61% Olympic Games 6,640 6,640 Technology 4,386 -707 -13.88% Education 693 49 7.61% Technology 4,422 4,281 3036.17% Branded 0 0 #DIV/0! Branded 0 0 #DIV/0! Grand Total 2,458,557 542,575 19.69% Grand Total 10,969,444 8,991,860 454.69% Grand Total 399,282 309,781 346.12%
  47. INSIGHT #1 Discover is the volume engine. 2024 total clicks

    across our 3 channels, Discover dominates by ~4.5× over Search and ~27× over GNews. DISCOVER 10.96M clicks · 2024 +454% SEARCH 2.46M clicks · 2024 +19.7% GNEWS 399K clicks · 2024 +346% TAKEAWAY · Discover is where reach is won. Search is stable but small. GNews is high-growth but low-volume.
  48. INSIGHT #2 · DISCOVER What's actually driving Discover. Top 6

    themes by 2024 Discover click volume. Politics is the engine, but Crime and International are exploding. 01 Politics 3.94M clicks · 2024 +426% 02 General News 1.27M clicks · 2024 +409% 03 Crime 1.07M clicks · 2024 +1,411% 04 International 1.00M clicks · 2024 +2,517% 05 Economy / Labor 821K clicks · 2024 +260% 06 Health 791K clicks · 2024 +494%
  49. INSIGHT #3 · GNEWS GNews chases events. +346% YoY overall,

    but the wins come from breaking-news verticals. This is velocity traffic — not evergreen authority. STRONGEST SURGES Wars +2,525% International +1,154% Sports +520% Crime +445% WHAT GNEWS REWARDS Breaking news Conflict Crisis Timely coverage TRANSLATION · GNews is velocity traffic, not evergreen authority. Win the breaking story, accept the half-life.
  50. INSIGHT #4 · CROSS-CHANNEL What survives across channels. Same topic,

    very different behavior. These are the patterns worth planning the editorial calendar around. 01 Politics rules everywhere. Same #1 topic across Discover, Search & GNews — a rare alignment. Treat it as the spine of the calendar. 02 Crime: Discover & GNews — not Search. Strong reach on news/feed surfaces, much weaker in Search. Crime is a velocity play, not a queries-based one. 03 Gossip is collapsing on Discover. Major YoY drop. Stop investing creative effort into Discover gossip — the surface no longer rewards it. 04 Lifestyle, Gossip & Technology have headroom. Underperforming relative to opportunity. Targeted improvement here moves the needle without touching politics. 05 Foreign affairs is up massively. Wars +2,525% on GNews, International +2,517% on Discover. Build a foreign-desk playbook before competitors lock it in.
  51. Presentations AI Tool for Automated PPTs The Gamma Example demonstrates

    how AI can transform presentation creation. Instead of spending hours on slide design and formatting, AI tools can generate professional presentations in minutes. These tools understand content structure, apply consistent design principles, and create visually appealing slides that effectively communicate your SEO insights and recommendations.
  52. Custom GPTs per Client Tailored AI Solutions Create custom GPT

    models trained on specific client data, brand guidelines, and industry knowledge. These personalized AI assistants understand your client's unique voice, target audience, and business objectives. Custom GPTs can handle client-specific tasks like content generation in their brand voice, answering FAQs about their products, or providing industry-specific SEO recommendations that align with their business goals.
  53. Creating Guides Faster Onboarding Comprehensive guides help new members get

    up to speed quickly, reducing training time and ensuring consistency in approach across your SEO team. Safeguarding Quality Document your processes, best practices, and quality standards. This ensures that every team member delivers work that meets your high standards, regardless of experience level. Create guides for everything you do in your day-to-day work. This documentation becomes invaluable for scaling your team and maintaining consistent, high-quality SEO deliverables. Make Bots work like you The guidelines how you work, can create an agent like you but “on steroids”
  54. RESOURCES Example of Guides Core SEO Guides • How to

    Use Search Console • How to Use Screaming Frog • How to Keyword Research • How to Track SEO Progress • Technical Audit Guide by SLEED Other Guides • Once Off Audit & Ongoing SEO • SEO Reading Resources • Day-to-Day SEO Tasks • Common SEO Questions • Google Merchant Center Audit • On-Page SEO Issues Guide • Keyword & Content Actions
  55. RESOURCES Example of Guides Core SEO Guides • How to

    Use Search Console • How to Use Screaming Frog • How to Keyword Research • How to Track SEO Progress • Technical Audit Guide by SLEED Other Guides • Once Off Audit & Ongoing SEO • SEO Reading Resources • Day-to-Day SEO Tasks • Common SEO Questions • Branded SEO Guide • Google Merchant Center Audit • On-Page SEO Issues Guide • Keyword & Content Actions These could be trainings and skill files for both your people and your LLMs
  56. ATHENS SEO 2026 · MAY 22–23 Your photo here Konstantinos

    Sfyris SEO Director · SLEED sleed.com CONNECT ON LINKEDIN Scan to connect Thank You!