Create personalized recruiting emails from LinkedIn search and save to Google Sheets

This Playbook will get profile information from the currently opened LinkedIn people search page, enrich their information and save it to a Google Sheets spreadsheet. It will then create a personalized draft recruiting email in Gmail.
Bardeen no longer supports Autobooks & Playbooks. Learn more about the new Bardeen.
Scrape data on active tab
Action
Scrape data in the background
Action
Get a person's data from email address
Action
Merge text
Action
Add data to sheet tab
Action
Generate customized email
Action
Create draft email
Action
Steps:

Streamlining the recruitment process is crucial for businesses looking to attract top talent efficiently. Bardeen's Playbook creates personalized recruiting emails from LinkedIn search results and saves them to Google Sheets, then drafts emails in Gmail. This integration saves time for recruiters by automating data extraction and email creation, allowing them to focus on engaging with prospects more personally.

Here's how this workflow creates personalized recruiting emails and saves them for future use:

  • Step 1: Scrape LinkedIn profiles - The Scraper tool extracts profile information from your current LinkedIn search page. Specify the number of profiles you want to scrape, and Bardeen takes care of the rest.
  • Step 2: Scrape background data - Bardeen continues to scrape data in the background, ensuring all relevant profile URLs are captured using the LinkedIn profile scraper template.
  • Step 3: Get contact info with Apollo - Integrating with Apollo.io, Bardeen retrieves detailed contact information for each LinkedIn profile, streamlining lead prospecting.
  • Step 4: Merge profile data - This step combines all scraped profile fields into a single text string, preparing the data for the next steps.
  • Step 5: Save to Google Sheets - The data is organized and added to a Google Sheets spreadsheet, where it can be reviewed and utilized for further actions.
  • Step 6: Generate personalized emails - Bardeen's AI Actions create customized draft emails tailored for each contact, enhancing the personal touch in your outreach.
  • Step 7: Create Gmail draft - Finally, each email is saved as a draft in Gmail, ready for your final review and personalization before sending to potential candidates.

The new Bardeen – Find leads no one else does:

With our new Bardeen version, you can easily extract data from any website and discover new leads across the web. After extracting data from a website, use Bardeen’s powerful automation tools to validate and enrich your data, run additional scrapers on linked pages, or leverage AI to qualify leads and generate content automatically. Once your data is ready, you can easily export it to CSV, Google Sheets, Airtable, or Notion for further analysis and reporting.

How Bardeen integrates with your existing system:
With Bardeen, you can easily import and export data to spreadsheets or CSV files, then push it to your favorite CRM or outreach tool — like Salesforce, HubSpot, Pipedrive, Apollo.io, or any platform that supports CSV. Most tools offer built-in import options or third-party solutions, making integration seamless and keeping your workflow uninterrupted.
Data Sync between Bardeen and your Tech Stack

"Our Sales and Ops teams can do more in less time to help serve our customers better."

Alex Bouaziz
Co-Founder & CEO at deel.
Enterprise-grade security

SOC 2 Type II, GDPR and CASA Tier 2 and 3 certified — so you can automate with confidence at any scale.

Frequently asked questions

What is Bardeen?
What tools does Bardeen replace for me?
Who benefits the most from using Bardeen?
How does Bardeen integrate with existing tools and systems?
What are common use cases I can accomplish with Bardeen?
By clicking “Accept”, you agree to the storing of cookies. View our Privacy Policy for more information.