📬 [Template] Send Automated Messages to LinkedIn Connections with Google Sheets (Without Sales Navigator) 📬

Showcase
, , ,
1

I have recently shared a guide In which I described how you can automate your Linkedin outreach in Make.com. I got some questions from people that wished to send messages to their connections instead of doing cold outreach. Therefore, I created this new guide, in which I show you how you can send messages to your LinkedIn connections using Make.com, Browserflow and Google Sheets. And best of all, you don’t need Sales Navigator for this work flow!

800×380 51.2 KB

To get started, you’ll need a few things. Of course you’ll need an account with Make.com. Also, we use Browserflow for the scraping part. So if you don’t already have a Browserflow account, you should make one here.

Step 1: Login to Browserflow and Download the Template

  1. Log In to your Browserflow account at app.browserflow.io/login.
  2. Get API Key: Once logged in, go to the settings page and copy your API key.

800×161 13.9 KB

3. Download the LinkedIn Outreach Template:

  • Navigate to the Templates tab.
  • Search for “Send Message to Linkedin Connection” and click Download Template.

800×360 34.8 KB

4. Store LinkedIn Cookies (First-Time Setup Only):

  • If you are asked to store your LinkedIn cookie, click Get Required Cookies.

700×450 102 KB

  • A login session window will open (this may take a minute). When the LinkedIn login page loads, enter your credentials. You may need to verify with a security code.
  • After logging in, click Save Login Cookies. Your template download will begin once cookies are saved.

Step 2: Import Blueprint in Make.com and Set Variables

  1. Login to your Make.com account and go to the Scenarios section.
  2. Create a New Scenario:
  • Click Create a new scenario in the top-right corner.
  • In the bottom-center toolbar, click the three dots and select Import Blueprint.
  • Choose the downloaded template file and upload it.
  • The flow should look like this:

800×380 51.2 KB

3. Add Browserflow API Key:

  • In the scenario, click on the first module named: “Start Browserflow Session”.
  • Select Add Connection and paste your Browserflow API key.

4. Test the Setup:

  • Go to the Set Variables module, and add the following variables:
    A LinkedIn URL of one contact and a message.
  • !VERY IMPORTANT!: You must be connected on Linkedin with this person already. Otherwise you will need this guide to automate.

800×554 94.4 KB

  • Click Run to test the flow with this one contact.

Step 3: Monitor the Bot in Browserflow

  1. Go to app.browserflow.io/advanced to view your session.

800×330 46.4 KB

  1. In the ‘Your running bots’ overview on the left, click View to see your bot’s progress in real-time. (This may take a minute to load.)

  2. You can interact with the session as it runs, but the flow should proceed smoothly without intervention.

800×486 120 KB

Step 4: Set Up a Webhook and Make It Live

  1. Create a Webhook:
  • In Make.com, create a new Webhooks module before the Start Browserflow Session module.

300×172 12.4 KB

  • Select Custom Webhook, then Add Webhook and give it a name.
  • Save the webhook, then copy the Webhook Address to the clipboard.

Step 5: Connect Google Sheets and Iterate over Rows

  1. Copy Google Sheets Template:

2. Add Webhook to Google Sheets:

  • Open your version of the Google Sheets document and paste the webhook URL into the designated field (e.g., a “Send” button).

3. Add Google Sheets Module in Make.com:

  • After the Start Browserflow Session module, add the Google Sheets “Search Rows (Advanced)” module.
  • Connect your Google account, and select your copied LinkedIn Send Message sheet (if you can’t locate the file, see 3).

4. Set Spreadsheet and Sheet ID (alternative):

  • If you can’t locate the file, select Enter Manually in the Search Method dropdown.
  • Go to your Google Sheets, copy the sheet ID from the URL, and paste it into the Spreadsheet ID field.

218×400 26.8 KB

  • For Sheet ID, enter the name of your sheet tab (e.g., Connections).

5. Set Query:

  • In the Query field, input:

Select * where (E != “Send?” OR E != true ) AND C != “”

  • Click OK, right-click the module, and choose Run this module only to test the connection.

247×308 15.4 KB

6. Map Fields to Set Variables:

  • Update the Set Variables module with data from the sheet.

800×735 106 KB

7. Mark Rows as Sent:

  • At the end of the flow, add a Google Sheets “Update a Cell” module.
  • Point it to the Google Sheets the same way as the other module
  • Set the Sheet name to Connections
  • Set the Cell to E{Row Number} and Value to true.

717×758 57.4 KB

Step 6: Publish and Run the Workflow

  1. Save and Publish:
  • Save your scenario by pressing Ctrl + S. Return to the All Scenarios page, locate your flow, and turn it on.

2. Run the Flow:

  • Whenever you click on “Send” in your Google Sheet, the flow will begin.
  • You can view its live progress in the Browserflow session viewer at app.browserflow.io/advanced.

Happy Automating!

Please be mindful of LinkedIn’s limitations and policies. The platform imposes restrictions on message length, the number of connection invitations, and profile visits based on your LinkedIn subscription plan. Additionally, it’s your responsibility to familiarize yourself with the terms and conditions of LinkedIn and any other parties mentioned in this article.

1 Like
2

The template seems to be removed. Is there a way to share it another way?

3

@JSliepen, I just checked and the template is still there. You mean the template in Browserflow Right?
Just copy and paste, it might be capital sensitive:
Send Message to Linkedin Connection

Or do you mean the google sheets template?