Creating your own SEO tools & SEO automations - Tevfik Mert Azizoglu - International Search Summit - Barcelona

In this session, Mert will talk about how you can create mini SEO tools and SEO automation that include complex functionalities like crawling, data extraction, and building reports automatically by using those outputs.

Transcript

1. Barcelona
   International Search Summit
   Tevfik Mert Azizoğlu
   SEO Sherpa
   Creating your own SEO tools
   & SEO automations
   #IntSS @mertazizoglu
   slideshare.net/TevfikMertAzizolu
   

   View Slide

2. T. Mert Azizoğlu
   #IntSS @mertazizoglu
   crawlt.com
   📍 Istanbul & Dubai 🌴
   🎓 Computer Engineer
   🔎 Sr. Tech. SEO @SEO Sherpa
   🔎 ex: SEO Director @Zeo
   ⚡ SEO Automation Geek
   󰞨 SEO Lecturer
   

   View Slide

3. Sometimes we need automations,
   #IntSS @mertazizoglu
   crawlt.com
   but not like this.
   

   View Slide

4. Tools
   Zapier
   G-Sheets
   XPath
   What we will cover today?
   #IntSS @mertazizoglu
   crawlt.com
   

   View Slide

5. Tools
   Zapier
   G-Sheets
   XPath
   Let’s start!
   #IntSS @mertazizoglu
   crawlt.com
   

   View Slide

6. What is XPath?
   //div[@class="seo-content"]
   #IntSS @mertazizoglu
   crawlt.com
   XPath is a syntax for defining parts of an
   XML document. - w3schools
   

   View Slide

7. node
   ● all page elements
   Example: a, p, h3, div, li
   XPath Syntax
   #IntSS @mertazizoglu
   crawlt.com
   

   View Slide

8. //
   ● points to all relevant
   nodes on the page
   Example: //h3
   XPath Syntax
   #IntSS @mertazizoglu
   crawlt.com
   

   View Slide

9. attribute
   ● specifies the
   property of the node
   Example: class, id, href
   XPath Syntax
   #IntSS @mertazizoglu
   crawlt.com
   

   View Slide

10. @
    ● indicates the
    attribute property
    Example:
    //div[@class="mert"]
    XPath Syntax
    #IntSS @mertazizoglu
    crawlt.com
    

    View Slide

11. XPath Overview
    #IntSS @mertazizoglu
    crawlt.com
    

    View Slide

12. count(XPath)
    count(//node[@attribute="attribute_name"]/a)
    count(//div[@class="seo-content"]/a)
    #IntSS @mertazizoglu
    crawlt.com
    

    View Slide

13. Element Validation
    02
    Writing XPath
    03
    01
    What Data Do
    We Need?
    XPath
    Lifecycle
    

    View Slide

14. #IntSS @mertazizoglu
    crawlt.com
    What Data
    Do We Need?
    01
    

    View Slide

15. #IntSS @mertazizoglu
    crawlt.com
    Element
    Validation
    02
    

    View Slide

16. #IntSS @mertazizoglu
    crawlt.com
    Is The Same Element Valid For All Pages?
    02
    

    View Slide

17. #IntSS @mertazizoglu
    crawlt.com
    Writing XPath 03
    //div[@class="bui-panel"]
    
    

    View Slide

18. XPath Helper Chrome Extension
    Testing w/ XPath Helper
    

    View Slide

19. XPath Helper Chrome Extension
    Testing w/ XPath Helper
    

    View Slide

20. 500
    URLs
    (Free)
    “custom extraction
    not included”
    #IntSS @mertazizoglu
    crawlt.com
    Custom Extraction w/
    Screaming Frog
    

    View Slide

21. #IntSS @mertazizoglu
    crawlt.com
    FAQ Extraction w/ XPath
    

    View Slide

22. //div[@class="lp-faq__content"]//ul//li//h3
    #IntSS @mertazizoglu
    crawlt.com
    FAQ Extraction w/ XPath
    

    View Slide

23. #IntSS @mertazizoglu
    crawlt.com
    FAQ Extraction w/ Screaming Frog
    

    View Slide

24. #IntSS @mertazizoglu
    crawlt.com
    FAQ Extraction w/ Screaming Frog
    

    View Slide

25. #IntSS @mertazizoglu
    crawlt.com
    Results!
    

    View Slide

26. #IntSS @mertazizoglu
    crawlt.com
    Chrome >
    DevTools > Copy >
    Copy XPath
    

    View Slide

27. Scraper Chrome Extension
    Finding XPath w/ Scraper
    

    View Slide

28. Tools
    Zapier
    G-Sheets
    XPath
    #IntSS @mertazizoglu
    crawlt.com
    

    View Slide

29. * Web-based Excel from Google!
    ❏ Free
    ❏ Cloud-based
    ❏ Easy integrations, Add-ons
    ❏ Apps Script & JS
    ❏ Accessibility
    #IntSS @mertazizoglu
    crawlt.com
    Google Sheets
    

    View Slide

30. =IMPORTXML("url";"xpath")
    Gif
    #IntSS @mertazizoglu
    crawlt.com
    IMPORTXML Formula
    (The Best Assistant!)
    

    View Slide

31. View Slide

32. developers.google.com/apps-script/guides/sheets
    #IntSS @mertazizoglu
    crawlt.com
    Apps Script =getStatusCode("url")
    Gif
    

    View Slide

33. developers.google.com/apps-script/guides/sheets
    #IntSS @mertazizoglu
    crawlt.com
    

    View Slide

34. developers.google.com/apps-script/guides/sheets
    #IntSS @mertazizoglu
    crawlt.com
    Triggers in Apps Script
    

    View Slide

35. developers.google.com/apps-script/guides/sheets
    #IntSS @mertazizoglu
    crawlt.com
    Triggers in Apps Script
    

    View Slide

36. Tools
    Zapier
    G-Sheets
    XPath
    #IntSS @mertazizoglu
    crawlt.com
    

    View Slide

37. #IntSS @mertazizoglu
    crawlt.com
    What is Zapier ?
    

    View Slide

38. #IntSS @mertazizoglu
    crawlt.com
    zapier.com/explore
    Plenty of Integrations!
    

    View Slide

39. #IntSS @mertazizoglu
    crawlt.com
    zapier.com/explore
    Quick Workflows / Zaps
    

    View Slide

40. #IntSS @mertazizoglu
    crawlt.com
    SEO Sheets Zaps
    

    View Slide

41. Tools
    I. On-Page SEO
    Health Checker
    II. Sitemap Watcher
    III. Internal Link Catcher
    * Bonus
    Zapier
    G-Sheets
    What we’ve learnt so far!
    XPath
    #IntSS @mertazizoglu
    crawlt.com
    

    View Slide

42. #IntSS @mertazizoglu
    crawlt.com
    On-Page SEO Health Checker
    Tools #1 On-Page SEO Health Checker
    

    View Slide

43. #IntSS @mertazizoglu
    crawlt.com
    On-Page SEO Health Checker
    Tools #1 On-Page SEO Health Checker
    

    View Slide

44. #IntSS @mertazizoglu
    crawlt.com
    Tools #2 Sitemap Watcher / Sheets
    //*[local-name()='url']/*[local-name()='loc']
    

    View Slide

45. #IntSS @mertazizoglu
    crawlt.com
    Tools #2 Sitemap Watcher / Zapier
    

    View Slide

46. #IntSS @mertazizoglu
    crawlt.com
    Tools #2 Sitemap Watcher / Zapier
    //*[local-name()='url']/*[local-name()='loc']
    

    View Slide

47. #IntSS @mertazizoglu
    crawlt.com
    Tools #2 Sitemap Watcher / Zapier
    

    View Slide

48. #IntSS @mertazizoglu
    crawlt.com
    Tools #2 Sitemap Watcher / Gmail
    

    View Slide

49. #IntSS @mertazizoglu
    crawlt.com
    Tools #3 Internal Link Catcher
    XPath Sitemap
    

    View Slide

50. #IntSS @mertazizoglu
    crawlt.com
    Tools #3 Internal Link Catcher
    

    View Slide

51. #IntSS @mertazizoglu
    crawlt.com
    Tools #3 Internal Link Catcher
    

    View Slide

52. #IntSS @mertazizoglu
    crawlt.com
    Tools #3 Internal Link Catcher
    

    View Slide

53. #IntSS @mertazizoglu
    crawlt.com
    Tools #3
    XPath Helper Chrome Extension
    //div[@class="div_name"]//a[c
    ontains(translate(.,'ABCÇDEF
    GĞHIİJKLMNOÖPQRSŞTUÜV
    WXYZ','abcçdefgğhıijklmnoöp
    qrsştuüvwxyz'),
    'keyword')]//@href =
    '/url_name'
    

    View Slide

54. #IntSS @mertazizoglu
    crawlt.com
    Tools #3 Internal Link Catcher
    

    View Slide

55. #IntSS @mertazizoglu
    crawlt.com
    Tools #3 Internal Link Catcher
    

    View Slide

56. #IntSS @mertazizoglu
    crawlt.com
    Tools #3
    

    View Slide

57. #IntSS @mertazizoglu
    crawlt.com
    Tools #3 Internal Link Catcher
    

    View Slide

58. #IntSS @mertazizoglu
    bit.ly/content-brief-generator
    Bonus #1 Content Brief Generator
    +
    

    View Slide

59. #IntSS @mertazizoglu
    n8n.io
    Bonus #2 n8n.io
    

    View Slide

60. #IntSS @mertazizoglu
    seonocode.com
    Bonus #2 Message When
    Content Changes
    n8n.io/workflows/1471
    

    View Slide

61. #IntSS @mertazizoglu
    crawlt.com
    Bonus #3 Robomotion.io
    Robomotion - Content Checker
    

    View Slide

62. #IntSS @mertazizoglu
    //div[@class="thank"]/you
    //twitter/@mertazizoglu
    crawlt.com
    seonocode.com
    

    View Slide