10 must have Google Sheets add-ons for sourcers and recruiters

This powerful add-on allows you to create a personalised, mass email campaigns without accessing candidates’ spam folder. Track open/reply rate, do follow-ups based on specific groups of leads (who opened/not seen etc.).
It is also cool that it creates separate labels for each campaign so you can quickly access that data. Here’s a short tutorial on how it works.

#2: Power Tools

Set of tools for daily tasks: change case; sum by colour; remove duplicates; split, merge, compare, find, clean up data and more.
Working with the massive amount of data? This add-on is your way to go. Easily remove repeatable emails from the recently aggregated list of prospects/attendees/candidates etc. And much more data processing features included.

#3: Split Names

Quickly split full names to several columns with first, middle, last names, titles, and/or post-nominal letters. 

#4: Crop Sheet

Tired from scrolling up and down through the spreadsheet. Me too! This add-on provides the ability to remove extra rows and columns from a sheet quickly. Fantastic.

#5: LinkedIn Profiles Search

This add-on is helpful if you have a candidate list and is looking to cross-reference the names on it with LinkedIn profiles in bulk. 

#6: Blockspring

Do anything in a spreadsheet. Connect Google Sheets to 100s of web apps and services to automate more of your work. Check out the video below to find out more.
https://youtu.be/iogmAtZipKU

#7: Save As Doc

Convert any Google Sheets spreadsheet into a Google Document for improved legibility of lengthy cell text entries using this app.

#8: Files Cabinet

Quickly list all the files of a Google Drive folder in a spreadsheet, and automatically display it in an Awesome Table view. Love it!

#9: FindThatLead

So basically FindThatLead is a somewhat more sales oriented tool. However, I do use it for sourcing as well.
Their extension allows you to generate/guess an email (both personal and corporate one) of your contacts/aggregated leads/attendee list etc. right from a Google Spreadsheet. Create an account, install the add-on, connect the API key, and you are all ready to go.

#10: Text2Link

Convert cells into links based on the cells’ data. Fast and convenient way to link to more information. Super powerful!

Cover image: Shutterstock

This article was first published on SourceCon blog on April 5, 2018.


Talent Acquisition (TA) is on the cusp of a new wave of innovation and the 12th Australasian Talent Conference will be shining the light on it – say hi to Artificial Intelligence (A.I.). Find out more here.

Article By

No items found

Get more articles direct to your inbox

Upcoming Events

14 & 15 October 2024

Wednesday, 4th December 2024

You may also enjoy reading...

Matthew Lant took time out of his busy schedule as Head of Recruitment and Employer Brand at the Australian Financial Complaints Authority (AFCA) to answer 3 quick questions about getting started in talent and his upcoming session at ATC2024: Unified Hiring: how we redefined AFCA's needs and aligned Hiring Leaders. 
This Week In Talent: Why conducting user interviews and focus groups is key to understanding the talent and people problems you’re solving for. Why should you start with your Minimum Viable Product first, and not jump straight to all the version with all the bells and whistles? How can stakeholder interviews save you time, money, and effort? How can you set up the interviews so people feel comfortable to tell you what they’re REALLY thinking? Well, read on and you’ll find out …
Jody Smith editor This Week in Talent
This Week in Talent: We welcome back Jody Smith to the editor seat, who brings us an intro to Human Centred Design (HCD) thinking, a bunch of design tools and resources you should bookmark, and Jody’s recommendation of which ATC Events session to attend if HCD is your jam.