{"id":151946,"date":"2023-01-30T00:39:42","date_gmt":"2023-01-30T05:39:42","guid":{"rendered":"https:\/\/ahrefs.com\/blog\/?p=151946"},"modified":"2023-01-30T07:25:29","modified_gmt":"2023-01-30T12:25:29","slug":"automate-seo-tasks","status":"publish","type":"post","link":"https:\/\/ahrefs.com\/blog\/automate-seo-tasks\/","title":{"rendered":"How to Automate Dull SEO&nbsp;Tasks"},"content":{"rendered":"\n<div class=\"intro-txt\">Some SEO processes involve repetitively clicking things on a screen. Not the best use of your&nbsp;time.<\/div>\n\n\n\n<p>With the right tools, however, you can automate various SEO processes\u2014and free up resources for tasks that need more creative, human&nbsp;input.<\/p>\n\n\n\n<p>In this post, I\u2019ll share two examples of SEO tasks you can automate.<\/p>\n\n\n\n<div class=\"intro-tok\" id=\"intro_tok\" style=\"display:none;\"><div class=\"intro-title\">Contents<\/div><a href=\"#\" class=\"expand-dots\"><span><\/span><span><\/span><span><\/span><\/a><\/div>\n\n\n\n<div class=\"post-nav-link clearfix\" id=\"section1\"><a class=\"subhead-anchor\" data-tip=\"tooltip__copielink\" rel=\"#section1\"><svg width=\"19\" height=\"19\" viewBox=\"0 0 14 14\" style><g fill=\"none\" fill-rule=\"evenodd\"><path d=\"M0 0h14v14H0z\" \/><path d=\"M7.45 9.887l-1.62 1.621c-.92.92-2.418.92-3.338 0a2.364 2.364 0 0 1 0-3.339l1.62-1.62-1.273-1.272-1.62 1.62a4.161 4.161 0 1 0 5.885 5.884l1.62-1.62L7.45 9.886zM5.527 5.135L7.17 3.492c.92-.92 2.418-.92 3.339 0 .92.92.92 2.418 0 3.339L8.866 8.473l1.272 1.273 1.644-1.643A4.161 4.161 0 1 0 5.897 2.22L4.254 3.863l1.272 1.272zm-.66 3.998a.749.749 0 0 1 0-1.06l2.208-2.206a.749.749 0 1 1 1.06 1.06L5.928 9.133a.75.75 0 0 1-1.061 0z\" style \/><\/g><\/svg><\/a><div class=\"link-text\" data-anchor=\"Example 1. Record and email article assignments to writers\" data-section=\"record-and-email-article-assignments-to-writers\">\n\n\n\n<h2 class=\"wp-block-heading\">Example 1. Record and email article assignments to writers<\/h2>\n\n\n\n<\/div><\/div>\n\n\n\n<p>Imagine being able to record and email article assignments to writers in seconds using a simple form like&nbsp;this:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image21.png\" alt=\"Airtable article assignment form\" class=\"wp-image-151953\" width=\"532\" height=\"747\" srcset=\"https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image21.png 819w, https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image21-303x425.png 303w, https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image21-768x1077.png 768w\" sizes=\"auto, (max-width: 532px) 100vw, 532px\"><\/figure>\n\n\n\n<p>Let\u2019s look at how to set this&nbsp;up.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">1. Set up an Airtable database for your writer and article data<\/h3>\n\n\n\n<p>Sign up for <a href=\"https:\/\/www.airtable.com\/\">Airtable<\/a> and create a new database with a table called \u201cWriters.\u201d The table should have columns for your writers:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Names<\/li>\n\n\n\n<li>Email addresses<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1130\" height=\"320\" src=\"https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image8-2.png\" alt=\"&quot;Writers&quot; table in Airtable\" class=\"wp-image-151955\" srcset=\"https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image8-2.png 1130w, https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image8-2-680x193.png 680w, https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image8-2-768x217.png 768w\" sizes=\"auto, (max-width: 1130px) 100vw, 1130px\"><\/figure>\n\n\n\n<p>In the same Airtable database, create a separate table called \u201cArticles.\u201d&nbsp;<\/p>\n\n\n\n<p>Set up columns in this table for&nbsp;your:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Article titles.<\/li>\n\n\n\n<li>Article outline links.<\/li>\n\n\n\n<li>Article due&nbsp;dates.<\/li>\n\n\n\n<li>Assigned writer (set this column up as a <a href=\"https:\/\/www.airtable.com\/guides\/build\/connect-data-with-linked-records\">linked record<\/a> to your \u201cWriters\u201d table so that Airtable can retrieve data on your writers from&nbsp;it).<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1305\" height=\"305\" src=\"https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image20.png\" alt=\"&quot;Articles&quot; table in Airtable\" class=\"wp-image-151957\" srcset=\"https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image20.png 1305w, https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image20-680x159.png 680w, https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image20-768x179.png 768w\" sizes=\"auto, (max-width: 1305px) 100vw, 1305px\"><\/figure>\n\n\n\n<p>You\u2019ll also need to <a href=\"https:\/\/support.airtable.com\/docs\/lookup-field-overview\">add a lookup field<\/a> to pull the writer\u2019s email address from the \u201cWriters\u201d table.&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1655\" height=\"856\" src=\"https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image3.gif\" alt=\"Add Airtable lookup field\" class=\"wp-image-151960\"><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">2. Create an Airtable article assignment form<\/h3>\n\n\n\n<p>Next, create an article assignment form for the \u201cArticles\u201d table. You\u2019ll use this form to add new article assignments to the \u201cArticles\u201d table.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image11-1.png\" alt=\"Create Airtable article assignment form\" class=\"wp-image-151962\" width=\"526\" height=\"770\" srcset=\"https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image11-1.png 701w, https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image11-1-290x425.png 290w\" sizes=\"auto, (max-width: 526px) 100vw, 526px\"><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">3. Set up a new Zapier automation with a \u201cNew Record in Airtable\u201d trigger<\/h3>\n\n\n\n<p>When you submit your details on the new article assignment via the Airtable form, Airtable will automatically record the new article assignment in your \u201cArticles\u201d table. So that\u2019s the first step of the article assignment workflow sorted.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1907\" height=\"884\" src=\"https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image19.gif\" alt=\"Demo of how Airtable automatically records new article assignments when the article assignment form is filled out\" class=\"wp-image-151959\"><\/figure>\n\n\n\n<p>Now, we\u2019ll use the <a href=\"https:\/\/www.zapier.com\/\">Zapier<\/a> workflow automation tool to automate the next three steps in the workflow\u2014namely:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Create a shared Google Drive submission folder for the article.<\/li>\n\n\n\n<li>Create a Google Doc submission document in the shared Google Drive folder.<\/li>\n\n\n\n<li>Use Gmail to email the writer the article title, outline link, due date, and link to the shared Google Drive submission folder.<\/li>\n<\/ol>\n\n\n\n<div class=\"sidenote\"><div class=\"sidenote-title\">Sidenote.<\/div> Instead of Zapier, you can also use any other workflow automation tool, such as <a href=\"https:\/\/make.com\/\">Make<\/a>, as long as the tool supports the automation triggers and actions you\u2019ll need.<\/div>\n\n\n\n<p>In Zapier, create a new automated workflow (also known as a \u201cZap\u201d) with:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Airtable<\/strong> as the trigger app.<\/li>\n\n\n\n<li><strong>New Record<\/strong> as the trigger event.<\/li>\n<\/ul>\n\n\n\n<p>With this trigger, your Zap will start running when you add a new record to Airtable (such as by submitting your Airtable article assignment form).<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image15-1.png\" alt=\"Trigger step: New Record in Airtable\" class=\"wp-image-151965\" width=\"863\" height=\"887\" srcset=\"https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image15-1.png 1150w, https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image15-1-413x425.png 413w, https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image15-1-768x789.png 768w\" sizes=\"auto, (max-width: 863px) 100vw, 863px\"><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">4. Add a \u201cCreate Folder in Google Drive\u201d action step to your&nbsp;Zap<\/h3>\n\n\n\n<p>Next, add an action step&nbsp;with:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Google Drive<\/strong> as the action app.<\/li>\n\n\n\n<li><strong>Create Folder<\/strong> as the action event.<\/li>\n<\/ul>\n\n\n\n<p>For the action step\u2019s \u201cParent Folder\u201d field, select the Google Drive folder in which the new submission folder should be created.<\/p>\n\n\n\n<p>Also, provide a name for the submission folder in the \u201cFolder Name\u201d field. You can map the article title data from Airtable here to name your submission folder after the article\u2019s title.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image6-3.png\" alt=\"Action step: Create Folder in Google Drive\n\" class=\"wp-image-151966\" width=\"863\" height=\"797\" srcset=\"https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image6-3.png 1150w, https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image6-3-460x425.png 460w, https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image6-3-768x709.png 768w\" sizes=\"auto, (max-width: 863px) 100vw, 863px\"><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">5. Add an \u201cAdd File Sharing Preference in Google Drive\u201d action step to your&nbsp;Zap<\/h3>\n\n\n\n<p>The Google Drive folder created by your Zap will have its sharing permissions disabled by default, so let\u2019s add an action step to grant folder access to anyone who has the link to the folder.<\/p>\n\n\n\n<p>This action step should have:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Google Drive<\/strong> as the action app.<\/li>\n\n\n\n<li><strong>Add File Sharing Preference<\/strong> as the action event.<\/li>\n<\/ul>\n\n\n\n<p>Map the file ID of the Google Drive folder created in the previous action step to the \u201cFile Id\u201d field of this action step.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1091\" height=\"547\" src=\"https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image9.gif\" alt=\"Map file ID of Google Drive folder to &quot;File Id&quot; field\" class=\"wp-image-151967\"><\/figure>\n\n\n\n<p>In addition, set the \u201cSharing Preference\u201d field to \u201cAnyone on the internet who has the link can&nbsp;edit.\u201d<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1080\" height=\"137\" src=\"https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image24.png\" alt=\"Set &quot;Sharing Preference&quot; field to &quot;Anyone on the internet who has the link can edit&quot;\" class=\"wp-image-151969\" srcset=\"https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image24.png 1080w, https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image24-680x86.png 680w, https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image24-768x97.png 768w\" sizes=\"auto, (max-width: 1080px) 100vw, 1080px\"><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">6. Add a \u201cCreate Document from Text in Google Docs\u201d action step to your&nbsp;Zap<\/h3>\n\n\n\n<p>Now, let\u2019s set up the Google Doc that the writer will use to submit their&nbsp;draft.<\/p>\n\n\n\n<p>We\u2019ll have the Zap create this submission Google Doc in the shared Google Drive submission folder. And since the Google Drive folder will have general access enabled, anyone with the link to the Google Drive folder\u2014and this includes you\u2014will also automatically get access to the Google Doc.<\/p>\n\n\n\n<p>No more frustration over writers forgetting to grant access to their Google Docs!<\/p>\n\n\n\n<p>So add a new action step to your Zap&nbsp;with:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Google Docs <\/strong>as the action app.<\/li>\n\n\n\n<li><strong>Create Document from Text<\/strong> as the action event.<\/li>\n<\/ul>\n\n\n\n<p>Map the article title data from Airtable to the action step\u2019s \u201cDocument Name\u201d field, and the folder ID of the shared Google Drive folder to the \u201cFolder\u201d field.<\/p>\n\n\n\n<p>You\u2019ll also need to include some default text in the Google Doc, such as \u201cWrite your article here!\u201d<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image18.png\" alt=\"Action step: Create Document from Text in Google Docs\" class=\"wp-image-151971\" width=\"863\" height=\"836\" srcset=\"https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image18.png 1150w, https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image18-438x425.png 438w, https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image18-768x745.png 768w\" sizes=\"auto, (max-width: 863px) 100vw, 863px\"><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">7. Add a \u201cSend Email in Gmail\u201d action step to your&nbsp;Zap<\/h3>\n\n\n\n<p>Finally, we\u2019ll get the Zap to use your Gmail account to email the writer the article title, outline link, due date, and link to the shared Google Drive submission folder.<\/p>\n\n\n\n<p>Add a last action step to your Zap&nbsp;with:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Gmail <\/strong>as the action app.<\/li>\n\n\n\n<li><strong>Send Email<\/strong> as the action event.<\/li>\n<\/ul>\n\n\n\n<p>Map the writer\u2019s email address from Airtable to the \u201cTo\u201d field for this action step. Also, map the article title, outline link, due date, and Google Drive submission folder link in the email&nbsp;body.<\/p>\n\n\n\n<p>I also recommend adding your own email address to either the \u201cCc\u201d or \u201cBcc\u201d field so you get a copy of the automated email (and can confirm it\u2019s been&nbsp;sent).<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1150\" height=\"422\" src=\"https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image22-2.png\" alt=\"Sample text for automated article assignment email\" class=\"wp-image-151973\" srcset=\"https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image22-2.png 1150w, https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image22-2-680x250.png 680w, https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image22-2-768x282.png 768w\" sizes=\"auto, (max-width: 1150px) 100vw, 1150px\"><\/figure>\n\n\n\n<p>Once you\u2019re happy with your Zap, hit the <strong>Publish<\/strong> button to activate your automation!<\/p>\n\n\n\n<div class=\"post-nav-link clearfix\" id=\"section1\"><a class=\"subhead-anchor\" data-tip=\"tooltip__copielink\" rel=\"#section1\"><svg width=\"19\" height=\"19\" viewBox=\"0 0 14 14\" style><g fill=\"none\" fill-rule=\"evenodd\"><path d=\"M0 0h14v14H0z\" \/><path d=\"M7.45 9.887l-1.62 1.621c-.92.92-2.418.92-3.338 0a2.364 2.364 0 0 1 0-3.339l1.62-1.62-1.273-1.272-1.62 1.62a4.161 4.161 0 1 0 5.885 5.884l1.62-1.62L7.45 9.886zM5.527 5.135L7.17 3.492c.92-.92 2.418-.92 3.339 0 .92.92.92 2.418 0 3.339L8.866 8.473l1.272 1.273 1.644-1.643A4.161 4.161 0 1 0 5.897 2.22L4.254 3.863l1.272 1.272zm-.66 3.998a.749.749 0 0 1 0-1.06l2.208-2.206a.749.749 0 1 1 1.06 1.06L5.928 9.133a.75.75 0 0 1-1.061 0z\" style \/><\/g><\/svg><\/a><div class=\"link-text\" data-anchor=\"Example 2. Finding and verifying prospects\u2019 email addresses for link building outreach\" data-section=\"finding-and-verifying-prospects-email-addresses-for-link-building-outreach\">\n\n\n\n<h2 class=\"wp-block-heading\">Example 2. Finding and verifying prospects\u2019 email addresses for link building outreach<\/h2>\n\n\n\n<\/div><\/div>\n\n\n\n<p>Finding email addresses for link building outreach can be a massive pain.<\/p>\n\n\n\n<p>After all, most prospects don\u2019t advertise their email addresses publicly. And even if you\u2019ve managed to dig up their email addresses (or guess them using trial and error), there\u2019s no guarantee they&nbsp;work.<\/p>\n\n\n\n<p>But using Ahrefs\u2019 <a href=\"https:\/\/ahrefs.com\/content-explorer\">Content Explorer<\/a>, you can generate a huge Google Sheets list of link building prospects that looks like&nbsp;this:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1122\" height=\"265\" src=\"https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image5-3.png\" alt=\"List of prospects in Google Sheets\" class=\"wp-image-151975\" srcset=\"https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image5-3.png 1122w, https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image5-3-680x161.png 680w, https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image5-3-768x181.png 768w\" sizes=\"auto, (max-width: 1122px) 100vw, 1122px\"><\/figure>\n\n\n\n<p>Then as you fill out the \u201cApprove?\u201d column for each prospect with data\u2014such as \u201cYes\u201d or \u201cApproved\u201d\u2014a Zapier automation will automatically do all these for&nbsp;you:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Find the prospect\u2019s email address using the <a href=\"https:\/\/hunter.io\/\">Hunter<\/a> email lookup tool<\/li>\n\n\n\n<li>Add the email address to your Google Sheet list of prospects<\/li>\n\n\n\n<li>Verify the email address using the <a href=\"https:\/\/www.neverbounce.com\/\">NeverBounce<\/a> email verification tool<\/li>\n\n\n\n<li>Add the verified email address to the <a href=\"https:\/\/woodpecker.co\/\">Woodpecker.io<\/a> email outreach tool so you can start sending customized outreach emails<\/li>\n<\/ol>\n\n\n\n<p>Here\u2019s how to set this&nbsp;up.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">1. Get your list of prospects<\/h3>\n\n\n\n<p>Launch Ahrefs\u2019 <a href=\"https:\/\/ahrefs.com\/content-explorer\">Content Explorer<\/a> and search for link prospects.&nbsp;<\/p>\n\n\n\n<p>For example, if you recently published a marketing survey with unique insights and statistics, you may want to look for marketing statistics pages to pitch. To do this, simply run an \u201cIn title\u201d search for \u201cmarketing statistics.\u201d<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1595\" height=\"890\" src=\"https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image23.png\" alt=\"Report of webpages with &quot;marketing statistics&quot; in their title, via Ahrefs' Content Explorer\" class=\"wp-image-151976\" srcset=\"https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image23.png 1595w, https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image23-680x379.png 680w, https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image23-768x429.png 768w, https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image23-1536x857.png 1536w\" sizes=\"auto, (max-width: 1595px) 100vw, 1595px\"><\/figure>\n\n\n\n<p>Next, filter your results to show only webpages that&nbsp;are:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>In English<\/strong> (unless you\u2019re targeting webpages in another language).<\/li>\n\n\n\n<li><strong>Live,<\/strong> as it\u2019d be weird to reach out and say, \u201cHey, I found you through [this webpage that no longer exists].\u201d<\/li>\n\n\n\n<li><strong>On websites with a Domain Rating (DR) of 20 to 80<\/strong> because you want to prioritize pursuing backlinks from authoritative websites but also that your chances of getting backlinks from super high-authority websites are quite&nbsp;low.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1522\" height=\"286\" src=\"https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/ce-search.png\" alt=\"Filtering for live, English webpages on sites with a DR between 20 and 80, via Ahrefs' Content Explorer\" class=\"wp-image-152163\" srcset=\"https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/ce-search.png 1522w, https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/ce-search-680x128.png 680w, https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/ce-search-768x144.png 768w\" sizes=\"auto, (max-width: 1522px) 100vw, 1522px\"><\/figure>\n\n\n\n<p>Add a last filter to show only one page per domain (since you want to reach out to only one prospect per website).<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image2-2.png\" alt=\"Ahrefs' Content Explorer &quot;One page per domain&quot; setting\" class=\"wp-image-151978\" width=\"374\" height=\"225\" srcset=\"https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image2-2.png 748w, https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image2-2-680x409.png 680w\" sizes=\"auto, (max-width: 374px) 100vw, 374px\"><\/figure>\n\n\n\n<p>Click the <strong>Export<\/strong> button to export your list of prospects in a CSV&nbsp;file.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">2. Clean up your list of prospects<\/h3>\n\n\n\n<p>As mentioned, we\u2019ll be using Hunter to help us find our prospects\u2019 email addresses.<\/p>\n\n\n\n<p>Hunter uses the first names, last names, and domains of prospects to find email addresses, so we\u2019ll clean up our list of prospects to provide Hunter with the exact data it&nbsp;needs.<\/p>\n\n\n\n<p>Import your CSV list of prospects in Google Sheets and delete all columns in it except for:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Content Title<\/li>\n\n\n\n<li>Content URL<\/li>\n\n\n\n<li>Author<\/li>\n<\/ul>\n\n\n\n<p>Also, some of the prospects in the CSV don\u2019t have author names, so it\u2019s worth removing these rows from the CSV. To do this, just filter for rows with empty author names and delete them.<\/p>\n\n\n\n<p>Next, use the SPLIT formula to split the author names into their first and last names based on the space between their&nbsp;names.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1320\" height=\"550\" src=\"https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image4-3.png\" alt=\"Using the =SPLIT() formula in Google Sheets to split author names based on the space between the first and last names\" class=\"wp-image-151980\" srcset=\"https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image4-3.png 1320w, https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image4-3-680x283.png 680w, https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image4-3-768x320.png 768w\" sizes=\"auto, (max-width: 1320px) 100vw, 1320px\"><\/figure>\n\n\n\n<p>Finally, add two new columns to the&nbsp;sheet:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Approve?:<\/strong> Adding data to this column will trigger the Zapier automation we\u2019ll be setting up&nbsp;next!<\/li>\n\n\n\n<li><strong>Email Address:<\/strong> This column will store the prospect\u2019s email address (if&nbsp;found).<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1999\" height=\"470\" src=\"https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image27.png\" alt=\"Adding of two new &quot;Approve?&quot; and &quot;Email address&quot; columns to Google Sheets\" class=\"wp-image-151982\" srcset=\"https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image27.png 1999w, https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image27-680x160.png 680w, https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image27-768x181.png 768w, https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image27-1536x361.png 1536w\" sizes=\"auto, (max-width: 1999px) 100vw, 1999px\"><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">3. Set up a new Zapier automation with a \u201cNew or Updated Spreadsheet Row in Google Sheets\u201d trigger<\/h3>\n\n\n\n<p>In Zapier, create a new Zap&nbsp;with:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Google Sheets<\/strong> as the trigger app.<\/li>\n\n\n\n<li><strong>New or Updated Spreadsheet Row <\/strong>as the trigger event.<\/li>\n<\/ul>\n\n\n\n<p>Map the action step\u2019s \u201cTrigger Column\u201d field to your Google Sheet\u2019s \u201cApprove?\u201d column.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image10-1.png\" alt=\"Trigger step: New or Updated Spreadsheet Row in Google Sheets\" class=\"wp-image-151983\" width=\"863\" height=\"882\" srcset=\"https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image10-1.png 1150w, https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image10-1-416x425.png 416w, https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image10-1-768x785.png 768w\" sizes=\"auto, (max-width: 863px) 100vw, 863px\"><\/figure>\n\n\n\n<p>With this setup, you\u2019ll trigger your Zap whenever you add new data\u2014such as \u201cYes\u201d or \u201cApproved\u201d\u2014to the \u201cApprove?\u201d column for any prospect row.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1820\" height=\"384\" src=\"https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image12-1.png\" alt=\"Adding of the word &quot;Yes?&quot; to the &quot;Approve?&quot; column in the Google Sheets list of prospects\" class=\"wp-image-151981\" srcset=\"https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image12-1.png 1820w, https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image12-1-680x143.png 680w, https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image12-1-768x162.png 768w, https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image12-1-1536x324.png 1536w\" sizes=\"auto, (max-width: 1820px) 100vw, 1820px\"><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">4. Add a \u201cFind Email in Hunter\u201d action step to your&nbsp;Zap<\/h3>\n\n\n\n<p>Next, add a new action step&nbsp;with:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Hunter<\/strong> as the action app.<\/li>\n\n\n\n<li><strong>Find Email<\/strong> as the action event.<\/li>\n<\/ul>\n\n\n\n<p>Map the \u201cContent URL,\u201d \u201cFirst Name,\u201d and \u201cLast Name\u201d columns in your Google Sheet to the \u201cDomain or Company,\u201d \u201cFirst Name,\u201d and \u201cLast Name\u201d fields for this action step, respectively.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image14-1.png\" alt=\"Action step: Find Email in Hunter\" class=\"wp-image-151985\" width=\"831\" height=\"1000\" srcset=\"https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image14-1.png 1661w, https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image14-1-353x425.png 353w, https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image14-1-768x924.png 768w, https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image14-1-1276x1536.png 1276w\" sizes=\"auto, (max-width: 831px) 100vw, 831px\"><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">5. Add an \u201cUpdate Spreadsheet Row in Google Sheets\u201d action step to your&nbsp;Zap<\/h3>\n\n\n\n<p>The next action step will update your Google Sheet with a prospect\u2019s email address if Hunter finds it.&nbsp;Use:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Google Sheets <\/strong>as the action app.<\/li>\n\n\n\n<li><strong>Update Spreadsheet Row<\/strong> as the action event.<\/li>\n<\/ul>\n\n\n\n<p>Map the Row Number of the updated row in the trigger step to this action step\u2019s \u201cRow\u201d&nbsp;field.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image16-1.png\" alt=\"Map the row number to the &quot;Row&quot; field\" class=\"wp-image-151987\" width=\"613\" height=\"617\" srcset=\"https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image16-1.png 817w, https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image16-1-422x425.png 422w, https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image16-1-768x774.png 768w, https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image16-1-120x120.png 120w\" sizes=\"auto, (max-width: 613px) 100vw, 613px\"><\/figure>\n\n\n\n<p>Also, map the email address that Hunter found in the previous action step to the \u201cEmail Address\u201d field of this action step.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image17-1.png\" alt=\"Map email address to the &quot;Email Address&quot; field\" class=\"wp-image-151988\" width=\"479\" height=\"126\"><\/figure>\n\n\n\n<div class=\"sidenote\"><div class=\"sidenote-title\">Sidenote.<\/div> This email address does not exist. It is for demo purposes only.<\/div>\n\n\n\n<h3 class=\"wp-block-heading\">6. Add a Filter action that lets the Zap continue only if Hunter has found an email address<\/h3>\n\n\n\n<p>Next, set up a Filter action that lets the Zap proceed only if the email address data found by Hunter contains the \u201c@\u201d symbol.<\/p>\n\n\n\n<p>That\u2019s because all email addresses have the \u201c@\u201d symbol. If Hunter happens to find an email address value that doesn\u2019t include this symbol, we won\u2019t want to waste time verifying it.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1150\" height=\"715\" src=\"https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image1-3.png\" alt=\"Filter action: Only continue if email address contains &quot;@&quot;\" class=\"wp-image-151993\" srcset=\"https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image1-3.png 1150w, https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image1-3-680x423.png 680w, https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image1-3-768x477.png 768w\" sizes=\"auto, (max-width: 1150px) 100vw, 1150px\"><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">7. Add a \u201cVerify Email Address in NeverBounce\u201d action step to your&nbsp;Zap<\/h3>\n\n\n\n<p>Now, we\u2019ll use <a href=\"https:\/\/neverbounce.com\/\">NeverBounce<\/a> to verify the validity of the email addresses that Hunter found. Add a new action step&nbsp;with:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>NeverBounce <\/strong>as the action app.<\/li>\n\n\n\n<li><strong>Verify Email Address<\/strong> as the action event.<\/li>\n<\/ul>\n\n\n\n<p>Map the email address that Hunter found to this action step\u2019s \u201cEmail Address to Verify\u201d field:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1832\" height=\"1170\" src=\"https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image26.png\" alt=\"Action step: Verify Email Address in NeverBounce\" class=\"wp-image-151991\" srcset=\"https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image26.png 1832w, https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image26-665x425.png 665w, https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image26-260x166.png 260w, https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image26-768x490.png 768w, https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image26-1536x981.png 1536w\" sizes=\"auto, (max-width: 1832px) 100vw, 1832px\"><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">8. Add a Filter action that lets the Zap continue only if NeverBounce returns a \u201cValid\u201d or \u201cCatchall\u201d status for the email address<\/h3>\n\n\n\n<p>When NeverBounce verifies an email address, it will return one of four status text codes: Valid, Catchall, Invalid, and Unknown. Email addresses marked with the \u201cValid\u201d and \u201cCatchall\u201d NeverBounce status codes have the highest likelihood of being&nbsp;valid.<\/p>\n\n\n\n<p>So we\u2019ll add a Filter action that lets the Zap proceed only if an email address\u2019s NeverBounce status text code matches either \u201cValid\u201d or \u201cCatchall\u201d exactly.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1150\" height=\"926\" src=\"https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image7-1.png\" alt=\"Filter action: Only continue if NeverBounce status text code is &quot;Valid&quot; or &quot;Catchall&quot;\" class=\"wp-image-151990\" srcset=\"https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image7-1.png 1150w, https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image7-1-528x425.png 528w, https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image7-1-768x618.png 768w\" sizes=\"auto, (max-width: 1150px) 100vw, 1150px\"><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">9. Add a \u201cCreate\/Update Prospect in Woodpecker.co\u201d action step to your&nbsp;Zap<\/h3>\n\n\n\n<p>Finally, we\u2019ll set up the Zap to add the verified email address to Woodpecker.co.<\/p>\n\n\n\n<p>Create a last action step&nbsp;with:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Woodpecker.co <\/strong>as the action app.<\/li>\n\n\n\n<li><strong>Create\/Update Prospect<\/strong> as the action event.<\/li>\n<\/ul>\n\n\n\n<p>Map the verified email address to the action step\u2019s \u201cEmail\u201d field, and your prospect\u2019s first and last name (as obtained from Google Sheets) to the \u201cFirst Name\u201d and \u201cLast Name\u201d fields, respectively.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1826\" height=\"1848\" src=\"https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image25.jpg\" alt=\"Action step: Create\/Update Prospect in Woodpecker.co\" class=\"wp-image-151994\" srcset=\"https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image25.jpg 1826w, https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image25-420x425.jpg 420w, https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image25-768x777.jpg 768w, https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image25-1518x1536.jpg 1518w, https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image25-120x120.jpg 120w\" sizes=\"auto, (max-width: 1826px) 100vw, 1826px\"><\/figure>\n\n\n\n<p>Hit the <strong>Publish<\/strong> button to turn your Zap&nbsp;on.<\/p>\n\n\n\n<p>Now, when you fill out the \u201cApprove?\u201d column for prospects in your Google Sheet, your Zap will automatically do the heavy lifting of finding and verifying their email addresses using Hunter and NeverBounce and adding the verified email addresses to Woodpecker.co.<\/p>\n\n\n\n<p>You can then customize your link building outreach emails in Woodpecker.co for each verified email address and, hopefully, snag yourself some backlinks!<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Final thoughts<\/h2>\n\n\n\n<p>SEO automation takes some initial setup, but it\u2019s amazing to watch your processes run automatically after that. It\u2019s almost like&nbsp;magic.<\/p>\n\n\n\n<p>And apart from the SEO processes we\u2019ve shared here, there are probably plenty others you can automate.<\/p>\n\n\n\n<p>Think of the apps you regularly use for SEO work. If you can connect these apps using Zapier or some other workflow automation tool, automating the workflows they support is likely more than possible.<\/p>\n\n\n\n<p>Got questions? Ping me <a href=\"https:\/\/twitter.com\/SiewAnnsStyle\">on Twitter<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>With the right tools, however, you can automate various SEO processes\u2014and free up resources for tasks that need more creative, human&nbsp;input. In this post, I\u2019ll share two examples of SEO tasks you can automate. Imagine being able to record and<span class=\"ellipsis\">\u2026<\/span><\/p>\n<div class=\"read-more\">Read more \u203a<\/div>\n<p><!-- end of .read-more --><\/p>\n","protected":false},"author":192,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"wp_typography_post_enhancements_disabled":false,"footnotes":""},"categories":[335],"tags":[],"coauthors":[454],"class_list":["post-151946","post","type-post","status-publish","format-standard","hentry","category-general-seo","odd"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Automate Dull SEO Tasks<\/title>\n<meta name=\"description\" content=\"Work smarter by automating your SEO tasks to spend more time on things that require the creative, human touch. Here&#039;s how.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ahrefs.com\/blog\/automate-seo-tasks\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Automate Dull SEO Tasks\" \/>\n<meta property=\"og:description\" content=\"Automate SEO in minutes.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ahrefs.com\/blog\/automate-seo-tasks\/\" \/>\n<meta property=\"og:site_name\" content=\"SEO Blog by Ahrefs\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/Ahrefs\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-01-30T05:39:42+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-01-30T12:25:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image21.png\" \/>\n<meta name=\"author\" content=\"Siew Ann Tan\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:description\" content=\"Automate SEO in minutes.\" \/>\n<meta name=\"twitter:creator\" content=\"@SiewAnnsStyle\" \/>\n<meta name=\"twitter:site\" content=\"@ahrefs\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/ahrefs.com\\\/blog\\\/automate-seo-tasks\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/ahrefs.com\\\/blog\\\/automate-seo-tasks\\\/\"},\"author\":{\"name\":\"Siew Ann Tan\",\"@id\":\"https:\\\/\\\/ahrefs.com\\\/blog\\\/#\\\/schema\\\/person\\\/3a0b83e53b278e41674131e72466cf7f\"},\"headline\":\"How to Automate Dull SEO&nbsp;Tasks\",\"datePublished\":\"2023-01-30T05:39:42+00:00\",\"dateModified\":\"2023-01-30T12:25:29+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/ahrefs.com\\\/blog\\\/automate-seo-tasks\\\/\"},\"wordCount\":2188,\"publisher\":{\"@id\":\"https:\\\/\\\/ahrefs.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/ahrefs.com\\\/blog\\\/automate-seo-tasks\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/ahrefs.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/01\\\/how-to-automate-dull-seo-tasks-by-siew-ann-tan.jpg\",\"articleSection\":[\"General SEO\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/ahrefs.com\\\/blog\\\/automate-seo-tasks\\\/\",\"url\":\"https:\\\/\\\/ahrefs.com\\\/blog\\\/automate-seo-tasks\\\/\",\"name\":\"How to Automate Dull SEO Tasks\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/ahrefs.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/ahrefs.com\\\/blog\\\/automate-seo-tasks\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/ahrefs.com\\\/blog\\\/automate-seo-tasks\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/ahrefs.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/01\\\/image21.png\",\"datePublished\":\"2023-01-30T05:39:42+00:00\",\"dateModified\":\"2023-01-30T12:25:29+00:00\",\"description\":\"Work smarter by automating your SEO tasks to spend more time on things that require the creative, human touch. Here's how.\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/ahrefs.com\\\/blog\\\/automate-seo-tasks\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/ahrefs.com\\\/blog\\\/automate-seo-tasks\\\/#primaryimage\",\"url\":\"https:\\\/\\\/ahrefs.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/01\\\/image21.png\",\"contentUrl\":\"https:\\\/\\\/ahrefs.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/01\\\/image21.png\",\"width\":819,\"height\":1149},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/ahrefs.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/ahrefs.com\\\/blog\\\/\",\"name\":\"SEO Blog by Ahrefs\",\"description\":\"Link Building Strategies &amp; SEO Tips\",\"publisher\":{\"@id\":\"https:\\\/\\\/ahrefs.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/ahrefs.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/ahrefs.com\\\/blog\\\/#organization\",\"name\":\"Ahrefs\",\"url\":\"https:\\\/\\\/ahrefs.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/ahrefs.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/ahrefs.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/06\\\/ahrefs-logo.png\",\"contentUrl\":\"https:\\\/\\\/ahrefs.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/06\\\/ahrefs-logo.png\",\"width\":2048,\"height\":768,\"caption\":\"Ahrefs\"},\"image\":{\"@id\":\"https:\\\/\\\/ahrefs.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/Ahrefs\\\/\",\"https:\\\/\\\/x.com\\\/ahrefs\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/ahrefs\\\/\",\"https:\\\/\\\/www.youtube.com\\\/c\\\/ahrefscom\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/ahrefs.com\\\/blog\\\/#\\\/schema\\\/person\\\/3a0b83e53b278e41674131e72466cf7f\",\"name\":\"Siew Ann Tan\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/ahrefs.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/01\\\/siewanntan.jpgef9c684585230625677509c6f0aa80eb\",\"url\":\"https:\\\/\\\/ahrefs.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/01\\\/siewanntan.jpg\",\"contentUrl\":\"https:\\\/\\\/ahrefs.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/01\\\/siewanntan.jpg\",\"caption\":\"Siew Ann Tan\"},\"description\":\"Freelance B2B SaaS content writer. Writes about digital marketing with a focus on SEO and email. Is unapologetically proud of the number of personal and business workflows she has automated (35+ and counting!).\",\"sameAs\":[\"https:\\\/\\\/siewann.style\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/SiewAnn\\\/\",\"https:\\\/\\\/x.com\\\/SiewAnnsStyle\"],\"url\":\"https:\\\/\\\/ahrefs.com\\\/blog\\\/author\\\/siew-ann-tan\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Automate Dull SEO Tasks","description":"Work smarter by automating your SEO tasks to spend more time on things that require the creative, human touch. Here's how.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/ahrefs.com\/blog\/automate-seo-tasks\/","og_locale":"en_US","og_type":"article","og_title":"How to Automate Dull SEO Tasks","og_description":"Automate SEO in minutes.","og_url":"https:\/\/ahrefs.com\/blog\/automate-seo-tasks\/","og_site_name":"SEO Blog by Ahrefs","article_publisher":"https:\/\/www.facebook.com\/Ahrefs\/","article_published_time":"2023-01-30T05:39:42+00:00","article_modified_time":"2023-01-30T12:25:29+00:00","og_image":[{"url":"https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image21.png","type":"","width":"","height":""}],"author":"Siew Ann Tan","twitter_card":"summary_large_image","twitter_description":"Automate SEO in minutes.","twitter_creator":"@SiewAnnsStyle","twitter_site":"@ahrefs","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/ahrefs.com\/blog\/automate-seo-tasks\/#article","isPartOf":{"@id":"https:\/\/ahrefs.com\/blog\/automate-seo-tasks\/"},"author":{"name":"Siew Ann Tan","@id":"https:\/\/ahrefs.com\/blog\/#\/schema\/person\/3a0b83e53b278e41674131e72466cf7f"},"headline":"How to Automate Dull SEO&nbsp;Tasks","datePublished":"2023-01-30T05:39:42+00:00","dateModified":"2023-01-30T12:25:29+00:00","mainEntityOfPage":{"@id":"https:\/\/ahrefs.com\/blog\/automate-seo-tasks\/"},"wordCount":2188,"publisher":{"@id":"https:\/\/ahrefs.com\/blog\/#organization"},"image":{"@id":"https:\/\/ahrefs.com\/blog\/automate-seo-tasks\/#primaryimage"},"thumbnailUrl":"https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/how-to-automate-dull-seo-tasks-by-siew-ann-tan.jpg","articleSection":["General SEO"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/ahrefs.com\/blog\/automate-seo-tasks\/","url":"https:\/\/ahrefs.com\/blog\/automate-seo-tasks\/","name":"How to Automate Dull SEO Tasks","isPartOf":{"@id":"https:\/\/ahrefs.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/ahrefs.com\/blog\/automate-seo-tasks\/#primaryimage"},"image":{"@id":"https:\/\/ahrefs.com\/blog\/automate-seo-tasks\/#primaryimage"},"thumbnailUrl":"https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image21.png","datePublished":"2023-01-30T05:39:42+00:00","dateModified":"2023-01-30T12:25:29+00:00","description":"Work smarter by automating your SEO tasks to spend more time on things that require the creative, human touch. Here's how.","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ahrefs.com\/blog\/automate-seo-tasks\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/ahrefs.com\/blog\/automate-seo-tasks\/#primaryimage","url":"https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image21.png","contentUrl":"https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/image21.png","width":819,"height":1149},{"@type":"WebSite","@id":"https:\/\/ahrefs.com\/blog\/#website","url":"https:\/\/ahrefs.com\/blog\/","name":"SEO Blog by Ahrefs","description":"Link Building Strategies &amp; SEO Tips","publisher":{"@id":"https:\/\/ahrefs.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ahrefs.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/ahrefs.com\/blog\/#organization","name":"Ahrefs","url":"https:\/\/ahrefs.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/ahrefs.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/06\/ahrefs-logo.png","contentUrl":"https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/06\/ahrefs-logo.png","width":2048,"height":768,"caption":"Ahrefs"},"image":{"@id":"https:\/\/ahrefs.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/Ahrefs\/","https:\/\/x.com\/ahrefs","https:\/\/www.linkedin.com\/company\/ahrefs\/","https:\/\/www.youtube.com\/c\/ahrefscom"]},{"@type":"Person","@id":"https:\/\/ahrefs.com\/blog\/#\/schema\/person\/3a0b83e53b278e41674131e72466cf7f","name":"Siew Ann Tan","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/siewanntan.jpgef9c684585230625677509c6f0aa80eb","url":"https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/siewanntan.jpg","contentUrl":"https:\/\/ahrefs.com\/blog\/wp-content\/uploads\/2023\/01\/siewanntan.jpg","caption":"Siew Ann Tan"},"description":"Freelance B2B SaaS content writer. Writes about digital marketing with a focus on SEO and email. Is unapologetically proud of the number of personal and business workflows she has automated (35+ and counting!).","sameAs":["https:\/\/siewann.style\/","https:\/\/www.linkedin.com\/in\/SiewAnn\/","https:\/\/x.com\/SiewAnnsStyle"],"url":"https:\/\/ahrefs.com\/blog\/author\/siew-ann-tan\/"}]}},"as_json":null,"_links":{"self":[{"href":"https:\/\/ahrefs.com\/blog\/wp-json\/wp\/v2\/posts\/151946","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ahrefs.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ahrefs.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ahrefs.com\/blog\/wp-json\/wp\/v2\/users\/192"}],"replies":[{"embeddable":true,"href":"https:\/\/ahrefs.com\/blog\/wp-json\/wp\/v2\/comments?post=151946"}],"version-history":[{"count":0,"href":"https:\/\/ahrefs.com\/blog\/wp-json\/wp\/v2\/posts\/151946\/revisions"}],"wp:attachment":[{"href":"https:\/\/ahrefs.com\/blog\/wp-json\/wp\/v2\/media?parent=151946"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ahrefs.com\/blog\/wp-json\/wp\/v2\/categories?post=151946"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ahrefs.com\/blog\/wp-json\/wp\/v2\/tags?post=151946"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/ahrefs.com\/blog\/wp-json\/wp\/v2\/coauthors?post=151946"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}