Required:

  • Google Sheets
  • Google Search Console
  • SEMRush API

Create the a Google Sheet file with the following named sheets:

  • Calendar
  • Content Approved
  • Content Idea
  • Snippets
  • Stats
  • Page Analysis
  • scratch pad
  • KW Data

Calendar – Column names

  • Publish Date
  • Day
  • Author
  • Title
  • URL
  • Content Type
  • Description
  • Keywords
  • Social Media
  • Published
Paste to B4
Paste to C4
Paste to D4
Paste to E4
Paste to F4
Paste to G4
Paste to H4
Paste into I4 (Data Validation)
Paste into J4 (Data Validation)

Content – Approved

  • Publish Date
  • Days Left
  • Sign Off
  • Author
  • Title Tag
  • Content Type
  • Category
  • SERP Feature
  • Description
  • Resources
  • Content Length (Words)
  • H1
  • H2
  • Subheadings
  • URL
  • Internal Link
  • Internal Link Keyword
  • Images Required
  • Twitter Description
  • Twitter Title
  • Facebook Description
  • Facebook Title
  • LinkedIn Description
  • LinkedIn Title
  • Published State
Paste into B3
Paste into C3 (Data Validation)
Paste into D3 (Data Validation)
Paste into E3
Paste into F3
Paste into G3
Paste into H3
Paste into J3
Paste into P3
Paste into X3

Content Ideas

  • Title
  • Content Type
  • Category
  • Buyers Stage
  • SERP Feature
  • Description
  • Resources
  • Comments
  • Keywords
  • Suggested by
  • Word Count
  • Date
  • Status
Paste into J4 (Data Validation)
Paste into J4 (Data Validation)
Paste into J4 (Data Validation)
Paste into J4 (Data Validation)
Paste into J4 (Data Validation)
Paste into J4 (Data Validation)
Paste into J4 (Data Validation)

Snippets

  • Content Creators
  • Cost per word
  • Categories
  • Type
  • Buyer Stage
  • Social
  • Published
  • Suggested
  • Content Approved
  • Not Selected Content
  • API
  • Date
  • Suggest By
  • Keywords Chosen
  • Dates as Strings
  • SERP Feature
Paste into J4 (Data Validation)
Paste into J4 (Data Validation)
Paste into J4 (Data Validation)
Paste into J4 (Data Validation)

Stats

  • Month
  • Content Cost
  • Category
  • Published
  • Content Type
  • Published
Paste into J4 (Data Validation)
Paste into J4 (Data Validation)
Paste into J4 (Data Validation)
Paste into J4 (Data Validation)

Page Analysis

  • URL
  • Last Modified
  • Frequency
  • Priority
  • Title
  • Title Length
  • H1
  • H1 Length
  • More Info
Paste into J4 (Data Validation)

Category Keywords

  • Sub Category 1
  • Sub Category 2
  • Sub Category 4
  • Sub Category 5
  • Sub Category 6
  • Sub Category 7
  • Sub Category 8
  • Sub Category 9
Paste into J4 (Data Validation)
Paste into J4 (Data Validation)
Paste into J4 (Data Validation)
Paste into J4 (Data Validation)
Paste into J4 (Data Validation)
Paste into J4 (Data Validation)
Paste into J4 (Data Validation)
Paste into J4 (Data Validation)
Paste into J4 (Data Validation)