How to Automate Dull SEO Tasks

Some SEO processes involve repetitively clicking things on a screen. Not the best use of yourtime.

With the right tools, however, you can automate various SEO processes—and free up resources for tasks that need more creative, humaninput.

In this post, I’ll share two examples of how I automate SEOtasks.

Imagine being able to record and email article assignments to writers in seconds using a simple form likethis:

Let’s look at how to set thisup.

1. Set up an Airtable database for your writer and article data

Sign up for Airtable and create a new database with a table called “Writers.” The table should have columns for your writers:

In the same Airtable database, create a separate table called “Articles.”

Set up columns in this table foryour:

• Article titles.
• Article outline links.
• Article duedates.
• Assigned writer (set this column up as a linked record to your “Writers” table so that Airtable can retrieve data on your writers fromit).

You’ll also need to add a lookup field to pull the writer’s email address from the “Writers” table.

2. Create an Airtable article assignment form

Next, create an article assignment form for the “Articles” table. You’ll use this form to add new article assignments to the “Articles” table.

3. Set up a new Zapier automation with a “New Record in Airtable” trigger

When you submit your details on the new article assignment via the Airtable form, Airtable will automatically record...