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

Wednesday, 4th December 2024
12pm – 2:30pm

You may also enjoy reading...

Struggling with "black hole" job applications? Discover insights from Paul Martin, Director & Co-Founder of Therefore Talent where CX experts explored how Customer Experience (CX) principles can transform recruitment and reduce candidate frustration. Paul highlights the power of closing job ads after 7 days, a data-driven approach that boosts hiring efficiency and candidate satisfaction. Learn how a CX-focused 7-day ad strategy, inspired by industry data, improves applicant experiences, streamlines processes, and helps talent teams maintain a positive brand image.
This Week in Talent: future planning and graduate recruitment is top of the list for Adam this week, sharing his experience at MYOB's future makers academy and his top tips for making an assessment day work. Did he back a winner at the Cup? Pretty sure it was a roughie. Read on.
This Week in Talent: ATC2024 has come and gone, and Jamie Holder is wrapping things up for us while it's still fresh in our minds. From the rise of AI in recruitment to Kevin Wheeler’s provocative predictions, there’s plenty to dive into. Spoiler: AI isn’t here to replace you, but it will make you better—if you embrace it. Want to revolutionise your hiring process? Skills-based hiring, predictive analytics, and personalisation are where it’s at. Plus, some serious fangirling over Kevin. If you missed ATC2024, don’t worry—this recap will get you up to speed.