🤖 Automated Linkedin Messaging / Outreach using Google Spreadsheet

[Raf]

I made a scenario / blueprint for sending LinkedIn messages on autopilot from within Make.com.

The setup uses a Google Spreadsheet to create a list of prospects, and with Browserflow, we send them LinkedIn Messages directly from within Make.

Of course you need your Make account to create the scenario. Also we use Browserflow, so it is recommend before start to create your account there at browserflow.io/activate if you don’t have an account.

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.

3. Download the LinkedIn Outreach Template:

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

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

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

• 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 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:

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 LinkedIn URL of one contact to test and an initial message.

• Note: LinkedIn has character limits on messages, so ensure your message is concise.
• 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.

2. 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.)

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

–

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.

• 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:

• Use this Google Sheets template to get started. Make a copy of the sheet using the Gmail account connected to Make.com.

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 outreach 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.

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

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.

6. Map Fields to Set Variables:

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

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 Cell to E{Row Number} and Value to true.

–

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.

[Kees_Bosch]

This is great, thank you a lot!

[Niklas]

Thanks, Raf. Would be truly great if this worked. Unfortunately, the scenario throws an error midway: As you can see, the scenario never reaches any of the three “Click on Send Invite” buttons. Can you please look at that? Many thanks.

[Raf]

Hi @Niklas, great to hear you tried it out, and thank you for your feedback. You may have found an edge case that I have not encountered myself! I’ve uploaded a new version of the template that should fix the issue. Please let me know if you run into anything else!

[Sergio_Pereira]

Hi, thanks for this.

I tried running it and it seems to me that its not able to pick up the element data from linkedin. Is this correct?

[Raf]

Hi Sergio,

It should pick it up, I am running the flow on a daily basis and I’m not experiencing any trouble.

Let me try to help you though,
Can you maybe share in a bit more detail which step gives an error and what error?

Also, just to check; You are trying to send messages to people that you aren’t connected with yet right?

There is another flow for sending messages to connections.