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.
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)))