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
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
3. Sometimes we need automations, #IntSS @mertazizoglu crawlt.com but not like this.
4. Tools Zapier G-Sheets XPath What we will cover today? #IntSS @mertazizoglu crawlt.com
5. Tools Zapier G-Sheets XPath Let’s start! #IntSS @mertazizoglu crawlt.com
6. What is XPath? //div[@class="seo-content"] #IntSS @mertazizoglu crawlt.com XPath is a syntax for defining parts of an XML document. - w3schools
7. node • all page elements Example: a, p, h3, div, li XPath Syntax #IntSS @mertazizoglu crawlt.com
8. // • points to all relevant nodes on the page Example: //h3 XPath Syntax #IntSS @mertazizoglu crawlt.com
9. attribute • specifies the property of the node Example: class, id, href XPath Syntax #IntSS @mertazizoglu crawlt.com
10. @ • indicates the attribute property Example: //div[@class="mert"] XPath Syntax #IntSS @mertazizoglu crawlt.com
11. XPath Overview #IntSS @mertazizoglu crawlt.com
12. count(XPath) count(//node[@attribute="attribute_name"]/a) count(//div[@class="seo-content"]/a) #IntSS @mertazizoglu crawlt.com
13. Element Validation 02 Writing XPath 03 01 What Data Do We Need? XPath Lifecycle
14. #IntSS @mertazizoglu crawlt.com What Data Do We Need? 01
15. #IntSS @mertazizoglu crawlt.com Element Validation 02
16. #IntSS @mertazizoglu crawlt.com Is The Same Element Valid For All Pages? 02
17. #IntSS @mertazizoglu crawlt.com Writing XPath 03 //div[@class="bui-panel"] <div class="bui-panel">
18. XPath Helper Chrome Extension Testing w/ XPath Helper
19. XPath Helper Chrome Extension Testing w/ XPath Helper
20. 500 URLs (Free) “custom extraction not included” #IntSS @mertazizoglu crawlt.com Custom Extraction w/ Screaming Frog
21. #IntSS @mertazizoglu crawlt.com FAQ Extraction w/ XPath
22. //div[@class="lp-faq__content"]//ul//li//h3 #IntSS @mertazizoglu crawlt.com FAQ Extraction w/ XPath
23. #IntSS @mertazizoglu crawlt.com FAQ Extraction w/ Screaming Frog
24. #IntSS @mertazizoglu crawlt.com FAQ Extraction w/ Screaming Frog
25. #IntSS @mertazizoglu crawlt.com Results!
26. #IntSS @mertazizoglu crawlt.com Chrome > DevTools > Copy > Copy XPath
27. Scraper Chrome Extension Finding XPath w/ Scraper
28. Tools Zapier G-Sheets XPath #IntSS @mertazizoglu crawlt.com
29. * Web-based Excel from Google! ❏ Free ❏ Cloud-based ❏ Easy integrations, Add-ons ❏ Apps Script & JS ❏ Accessibility #IntSS @mertazizoglu crawlt.com Google Sheets
30. =IMPORTXML("url";"xpath") Gif #IntSS @mertazizoglu crawlt.com IMPORTXML Formula (The Best Assistant!)
32. developers.google.com/apps-script/guides/sheets #IntSS @mertazizoglu crawlt.com Apps Script =getStatusCode("url") Gif
33. developers.google.com/apps-script/guides/sheets #IntSS @mertazizoglu crawlt.com
34. developers.google.com/apps-script/guides/sheets #IntSS @mertazizoglu crawlt.com Triggers in Apps Script
35. developers.google.com/apps-script/guides/sheets #IntSS @mertazizoglu crawlt.com Triggers in Apps Script
36. Tools Zapier G-Sheets XPath #IntSS @mertazizoglu crawlt.com
37. #IntSS @mertazizoglu crawlt.com What is Zapier ?
38. #IntSS @mertazizoglu crawlt.com zapier.com/explore Plenty of Integrations!
39. #IntSS @mertazizoglu crawlt.com zapier.com/explore Quick Workflows / Zaps
40. #IntSS @mertazizoglu crawlt.com SEO Sheets Zaps
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
42. #IntSS @mertazizoglu crawlt.com On-Page SEO Health Checker Tools #1 On-Page SEO Health Checker
43. #IntSS @mertazizoglu crawlt.com On-Page SEO Health Checker Tools #1 On-Page SEO Health Checker
44. #IntSS @mertazizoglu crawlt.com Tools #2 Sitemap Watcher / Sheets //*[local-name()='url']/*[local-name()='loc']
45. #IntSS @mertazizoglu crawlt.com Tools #2 Sitemap Watcher / Zapier
46. #IntSS @mertazizoglu crawlt.com Tools #2 Sitemap Watcher / Zapier //*[local-name()='url']/*[local-name()='loc']
47. #IntSS @mertazizoglu crawlt.com Tools #2 Sitemap Watcher / Zapier
48. #IntSS @mertazizoglu crawlt.com Tools #2 Sitemap Watcher / Gmail
49. #IntSS @mertazizoglu crawlt.com Tools #3 Internal Link Catcher XPath Sitemap
50. #IntSS @mertazizoglu crawlt.com Tools #3 Internal Link Catcher
51. #IntSS @mertazizoglu crawlt.com Tools #3 Internal Link Catcher
52. #IntSS @mertazizoglu crawlt.com Tools #3 Internal Link Catcher
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'
54. #IntSS @mertazizoglu crawlt.com Tools #3 Internal Link Catcher
55. #IntSS @mertazizoglu crawlt.com Tools #3 Internal Link Catcher
56. #IntSS @mertazizoglu crawlt.com Tools #3
57. #IntSS @mertazizoglu crawlt.com Tools #3 Internal Link Catcher
58. #IntSS @mertazizoglu bit.ly/content-brief-generator Bonus #1 Content Brief Generator +
59. #IntSS @mertazizoglu n8n.io Bonus #2 n8n.io
60. #IntSS @mertazizoglu seonocode.com Bonus #2 Message When Content Changes n8n.io/workflows/1471
61. #IntSS @mertazizoglu crawlt.com Bonus #3 Robomotion.io Robomotion - Content Checker
62. #IntSS @mertazizoglu //div[@class="thank"]/you //twitter/@mertazizoglu crawlt.com seonocode.com