Link Building with Google Sheets: Start Guest Posting in 15 Minutes

#wordpress #Webhosting #websites #videos #learning and much more

Lightning fast hosting for a shockingly low price! 50% off GoDaddy Hosting plans


Want to automate part of your link building? This tutorial will show you how to use Google Sheets to find and validate prospects (with email addresses) in under 15 minutes.
Subscribe ► https://www.youtube.com/AhrefsCom?sub_confirmation=1

***************************************
Additional Link Building Resources

Copy My Link Building System: How to Get Backlinks “At Scale” ► https://www.youtube.com/watch?v=Ovu2ZYWgOJQ&list=PLvJ_dXFSpd2tjUTuAHpHidz5e2hAedP_m&index=6

Guest Posting at Scale: Get Tons of High Quality Backlinks ► https://www.youtube.com/watch?v=aQK1Vbgb-RY&list=PLvJ_dXFSpd2tjUTuAHpHidz5e2hAedP_m&index=4

How to Build Unique Backlinks With Resource Page Link Building ► https://www.youtube.com/watch?v=8f4YTubL6cM&list=PLvJ_dXFSpd2tjUTuAHpHidz5e2hAedP_m&index=5

How to Get Backlinks By “Stealing” From Low-Quality Pages ► https://www.youtube.com/watch?v=wPjPjNK-bDM&list=PLvJ_dXFSpd2tjUTuAHpHidz5e2hAedP_m&index=3

How to Write Outreach Emails (That Won’t Get Ignored) ► https://www.youtube.com/watch?v=nAIWG8883uo&list=PLvJ_dXFSpd2tjUTuAHpHidz5e2hAedP_m&index=2

Link Building Tutorials (Step-By-Step) ► https://www.youtube.com/playlist?list=PLvJ_dXFSpd2tjUTuAHpHidz5e2hAedP_m

***************************************

Copy our Google Sheet template here ► https://docs.google.com/spreadsheets/d/1_vRXSCpHdad2Efuuc5nTAyNO8rPqSkKb3NjtPon7ffY/copy
In this tutorial, you’ll learn some Google Sheets formulas you can use to automate parts of your link building.

The example template we’ll be building will be to kick off a guest posting campaign in 15-minutes. In order to do that, you’ll need three data points.

The URL or domain of the prospect
Someone’s first name
and their last name.

You’ll learn which tools to use to acquire these data points within just a couple of minutes.

Once you have them, it’s time to create your own Google Sheets template and start getting backlinks.

If you’re an Ahrefs user, you can copy the sheet to your own Google Drive, follow the instructions on the Instructions tab and make reference to this video for specific steps.

Otherwise, you can follow along with the tutorial to set up Google Sheets for a guest posting campaign.

When you’re done, you’ll have a nice list of websites, names and email addresses you can add to your favorite outreach tool and start building some backlinks.

The best part is: you’ll be able to apply your Google Sheets knowledge to build other templates for link building in the future.

#linkbuilding #guestblogging #howtousegooglesheets #googlesheets

Time Stamps

0:38 – Find link prospects with contact details
2:31 – Create an outreach template
7:46 – Find emails for outreach
8:51 – Validate email addresses
10:05 – Match valid email addresses with the outreach template

Be sure to subscribe for more actionable marketing and SEO tutorials.
https://www.youtube.com/AhrefsCom?sub_confirmation=1

STAY TUNED:
Ahrefs ► https://ahrefs.com/
YouTube ► https://www.youtube.com/AhrefsCom?sub_confirmation=1
Facebook ►https://www.facebook.com/Ahrefs
Twitter ►https://twitter.com/ahrefs


source

22 thoughts on “Link Building with Google Sheets: Start Guest Posting in 15 Minutes”

  1. Hey all. Hope you enjoyed the video. Here's a list of all formulas + the Google Sheet used in this tutorial. Enjoy 🙂

    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 against your NeverBounce import

    =IFERROR(ArrayFormula(VLOOKUP(G2:G,'Email Validation'!A:B,2,FALSE)))

    NOTE: You may need to change cell references if any of the tools' export files changes over time.

    Copy the Google Sheet ► https://docs.google.com/spreadsheets/d/1_vRXSCpHdad2Efuuc5nTAyNO8rPqSkKb3NjtPon7ffY/copy

  2. How to do keyword resarch?
    Ahrefs: use Google sheets formula like What's app text.
    Me: what Was that , I was dumb at Math formulas , is link building means formulas 😟

    Well Learn lot

  3. Great video but has this feedback been sent to the ahrefs dev team to provide this type of filtering and custom column ordering directly on the site to prevent these workflows from even being needed?

Leave a Reply

Your email address will not be published. Required fields are marked *