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

2October 2019

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

Digital Marketing Agency

Our job is to help your business grow. Get in touch with us today for a FREE consultation.