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.

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
11. 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
12. 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
13. Ready for a Deep Dive? Let’s see some of them
14. 2’ Audit in 1 click! Instead of 2-5 hours
15. 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
16. 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?
17. 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
18. 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
19. 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
20. SERP Analyzer Instead of 21 opened tabs
21. • Let’s say you have a client that has a “money” keyword that drives 25% of traffic & revenue. SERP Analyzer
22. • 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
23. • 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
24. • 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
25. • 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
26. • 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
27. • 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
28. • 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
29. • 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
30. • 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
31. • 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
32. SERP Analyzer
33. Core Update Checker All-in-One
34. Core Update Checker You have a newsroom and thennn..
35. Core Update Checker You have a newsroom and thennn.. a Core Update hits you!
36. Core Update Checker You have a newsroom and thennn.. a Core Update hits you! What do you have to do?
37. 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)
38. 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)
39. 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
40. 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
41. Core Update Checker How to: You just input your domain and optionally 1-9 competitors. Then you get an overview with 5 tabs:
42. Core Update Checker Tab a) General Overview General Overview with organic traffic, total visits, keywords, backlinks, DR & Core Web Vitals Analysis
43. Core Update Checker Tab b) Keywords Overview Total, Branded, Non Branded, Top Pages and before and after rankings after the last Google Update
44. 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)
45. 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.
46. 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
47. Core Update Checker Tab e) Core Web Vitals Overview (vs Competition) (no need for description obvious from the title )
48. 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!
49. Bulk Content Creator All-in-One #2
50. CONTENT TOOLS Bulk Content Creator Bulk Content Creator for SEO
51. CONTENT TOOLS Bulk Content Creator Bulk Content Creator for SEO Step 1: Create App Script that allows talking with an LLM in Sheets
52. Bulk Content Creator for SEO Step 1: Create App Script that allows talking with an LLM in Sheets CONTENT TOOLS Bulk Content Creator
53. 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
54. 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
55. Themes Analysis For News Sites
56. 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
57. Let’s take as an example a political Newsroom of Greece Themes Analysis for News Sites
58. 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
59. Firstly, we export YoY Data from GSC from the 3 channels Themes Analysis for News Sites
60. Themes Analysis for News Sites Then we have this export x3
61. 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
62. 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
63. Step 2: Create 3 columns Branded/ Non Branded, Theme, Politics theme. Themes Analysis for News Sites
64. Step 3: Paste the following prompt in the “Theme” column Themes Analysis for News Sites
65. Your output will look like this Themes Analysis for News Sites
66. Step 4: Filter the theme column with “Politics”. For each cell in politics paste the following prompt Themes Analysis for News Sites
67. Your output will look like this Themes Analysis for News Sites
68. Step 5: Create one Pivot Table for Themes and one Political Parties Themes Analysis for News Sites
69. 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%
70. Insights in Plain English …powered by AI too
71. 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.
72. 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%
73. 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.
74. 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.
75. Other Proposals For Automations
76. 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.
77. 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.
78. Custom GPTs per Client
79. 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”
80. 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
81. 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
82. ATHENS SEO 2026 · MAY 22–23 Your photo here Konstantinos Sfyris SEO Director · SLEED sleed.com CONNECT ON LINKEDIN Scan to connect Thank You!