How to: guest post outreach email

Here is a copy of the spreadsheet. You MUST make a copy of the spreadsheet as you cannot edit this version.

CLICK HERE FOR A COPY OF THE SPREADSHEET

Just in case you lose the formulas:

Import just the title, URL, author name, and Domain Rating from a Content Explorer export =IFERROR(QUERY('CE Import'!B:P,"SELECT B,C,E,D WHERE D is not NULL AND D contains ' '"))

Get the first word from a full author name =IFERROR(ARRAYFORMULA(LEFT(D2:D,FIND(" ",D2:D)-1)))

Get the last word from a full author name =IFERROR(ArrayFormula(TRIM(RIGHT(SUBSTITUTE(D2:D," ",REPT(" ",100)),100))))

Lookup email addresses to see if they're valid  =IFERROR(ArrayFormula(VLOOKUP(I2:I,'Email Validation'!A:B,2,FALSE)))

Scroll to Top