Skip to main content

Simplifying Recruitment from LinkedIn to Google Sheets with

Imagine a scenario where you can seamlessly connect with potential candidates, gather CVs from multiple sources, and manage your recruitment pipeline with ease. In this blog, I'll unveil the ingenious solution that not only bridges the gap between LinkedIn Recruitment Lite and other job posting websites but also simplifies the entire process using readily available tools. From's mailhook feature to the power of Google Sheets, I'll walk you through each step of streamlining your recruitment efforts. So, if you're curious about how automation can transform your HR processes and save you valuable time, read on till the end. 

Connecting to LinkedIn Recruitment Lite

In my situation, I faced the challenge of needing to post job openings on LinkedIn to reach a wider pool of candidates. However, I encountered a hurdle – LinkedIn's lack of an API, and LinkedIn Recruitment Lite requiring a higher plan to invite colleagues to join the platform. This left me searching for a solution to efficiently share CVs across our team and consolidate all CVs into our company database. offered a solution. While it also lacked an API to directly connect to LinkedIn Recruitment, it had a mailhook feature that became my lifesaver. Here's how it works: I created a new email address within and had LinkedIn send notification emails to this address. Then, I set up a scenario in to download CVs to Google Drive, parse the email content to extract candidate information, write this information to a Google Sheet, and forward the email to my colleagues. The beauty of it? It runs automatically, ensuring a smooth and seamless process.

Linkedin CV, fwd and save to Google Sheet

Expanding CV Collection to Job Posting Websites

It wasn't just LinkedIn; other job listing websites in my country didn't support APIs either. However, the method I implemented with for LinkedIn worked like a charm for these platforms as well. It enabled us to gather CVs from various sources and centralize them efficiently.

my scenerios on

Managing the Recruitment Process with Google Sheets and Preparing for the Transition

With CVs pouring in from multiple sources, Google Sheets emerged as our trusted ally. It provided a centralized hub to collect all CVs in one place. Moreover, I created a separate sheet specifically for potential candidates. This sheet housed detailed information about candidates, including columns to track their progress throughout the interview and onboarding processes. This not only helped manage new candidates but also provided a means to engage with past candidates, inviting them to apply for new positions as they became available.

However, Google Sheets has its limitations, particularly when it comes to complex logic and establishing relationships between tables. My long-term vision includes developing a mini HRM (Human Resource Management) solution for our company, and this calls for a more robust no-code database management tool. As we move forward, I'll explore alternatives like AppSheet or Airtable to better meet our evolving needs.

If you found this blog post insightful, I encourage you to check back frequently for updates on our HR technology journey. Have questions or insights of your own? Don't hesitate to ask or share in the comments section below. Together, we can navigate the ever-evolving landscape of recruitment and HR automation.


Popular posts from this blog

A Guide to Drawing Flat Vector Illustrations with MidJourney

Flat vector illustrations have become increasingly popular due to their versatility and clean aesthetic. Creating captivating flat vector illustrations requires both artistic skills and the right tools. MidJourney, a powerful digital illustration platform, offers a seamless and intuitive experience for artists of all levels. In this article, we will explore how to effectively use MidJourney to draw stunning flat vector illustrations. The flat vector illustration emphasizes simplicity and the use of simple details on a flat plane, as well as a focus on color combinations to create a complete design. Typically, it does not utilize 3D effects but instead relies on solid colors without color gradients. Due to its minimalist and user-friendly nature, flat vector illustration is often used in website and app design, as well as in print graphic design. The topic of flat vector illustration is vast, and I will gradually share more in future articles. Today, let's focus on the application o

Revolutionizing Recruitment and Onboarding with AI and Automation

Hello, I'm Terry, the Vice President of Operations at a technology company that specializes in SaaS products, cloud-native applications, and cutting-edge AI solutions. In addition to our technical expertise, we offer digital marketing services to our clients, making us a dynamic player in the tech industry. Before stepping into my current role, I accrued several years of experience in various aspects of the tech world. I delved into the intricacies of SEO, mastered the art of performance marketing with platforms like Google Ads and Facebook Ads, and even led as a Project Manager for a cloud platform project. Today, as the VP of Operations, my responsibilities span a broad spectrum, and among them is the crucial task of recruiting and onboarding top talent. In this blog series, I'll take you on a journey as I embark on a transformative mission within our company. My goal? To apply the power of automation to our recruitment process, with the twin aims of reducing the HR team'