🤖 Automated Linkedin Messaging / Outreach using Google Spreadsheet

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.

  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.

–

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:

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.

15

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.

16

–

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

This is great, thank you a lot!:fire:

1 Like

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.

1 Like

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!

1 Like

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?

1 Like

Hi @Sergio_Pereira,

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

Ah, my bad. I was trying connections. I thought non-connections had much higher restrictions and wasn’t really possible to automate.

Let me try again.
Thanks again!

I’m unable to log into Linkedin. I test it and when I view it in Browserflow, its stuck at the Linkedin login. I gave it the cookies credentials… not sure why…

Also, Browserflow discord link doesn’t work…

Hi @Sergio_Pereira Based on your description, i think there is something wrong with your login cookie. I think you can best delete your cookies and login again with the cookie portal. You can do this as the following:

  1. Go to the Advanced page in Browserflow and click on Delete all saved cookies.
  2. Then, return to the templates section and download the LinkedIn template.
  3. You should now see the screen to save cookies again.

Make sure to log in to your LinkedIn account before clicking Save cookies. This will allow the workflow to capture the complete set of cookies from your logged-in profile, enabling it to perform actions using your LinkedIn account.

After this you can just run your current Make scenario, you wont need the new downloaded template but it is just the easiest way to give Browserflow the new cookies.