Automate Linkedin Connection Requests
Automate the process of sending personalized LinkedIn connection requests to a list of contacts managed in a Google Sheet.
This automation streamlines your LinkedIn networking efforts. Here's how it works:
- Checks Your Login: It starts by navigating to LinkedIn to ensure you are already signed in.
- Reads Your Contact List: The automation reads a list of contacts from a Google Sheet URL that you provide (copy this one ). It intelligently filters for contacts that haven't been processed yet.
- Processes Each Contact: For each contact in your list, the automation:
- Navigates to their LinkedIn profile.
- Checks your current connection status with them. It automatically skips anyone you're already connected with ("1st" degree) or have a "Pending" request for.
- If you are not connected, it reliably finds and clicks the "Connect" button, prioritizing the "More" -> "Connect" flow that works on most profiles.
- If you've provided a custom message in your Google Sheet for that contact, it adds the note before sending the request. Otherwise, it sends the request without a note.
- Updates Your Sheet: After each attempt, it updates the corresponding row in your Google Sheet with the status—marking it as "completed," "skipped," or noting any errors encountered.
- Provides a Summary: Once finished, the automation provides a summary of how many requests were sent, skipped, and how many failed.
Usage Ideas
- Automate sales outreach to a list of prospects generated from a lead-sourcing tool.
- Quickly expand your professional network by connecting with attendees from a conference or webinar.
- Streamline your recruitment process by sending initial connection requests to a list of potential candidates.
- Build a community by connecting with influencers or key opinion leaders in your industry.
Customization Ideas
This template is designed to be highly adaptable to your specific needs. You can easily customize it to:
- Use any Google Sheet: Simply provide the URL of your sheet containing LinkedIn profile URLs.
- Personalize at scale: Write custom connection messages for each contact directly in your spreadsheet. The automation will use them automatically.
- Control the pace: Set the maximum number of contacts to process in one go to manage your outreach efforts.
- Adapt to your data: The automation can be modified to work with your existing spreadsheet, even if your column names are different from the template's defaults (e.g., using "Profile URL" instead of "Linkedin_URL").
- Change the data source: While it's set up for Google Sheets, the logic can be reconfigured to pull contact lists from other sources like Airtable or your CRM.