Hi guys,
It can be hard sometimes to target the right decision makers within a company. Lets say you would like to target the CIO, the Owner or the Head of Recruitment from a list of companies.
I have created this automation where you can loop over a list of companies and search LinkedIn for the right people. Then you can also send them a message or connection invite automatically.
In order to use this blueprint, you need to create an account at Browserflow, where you can get your free API key by signing up for the 7-day trial.
To create this automation workflow ether follow this step by step guide or simply download the blueprint here:
Demo-find-decision-maker-in-linkedin.json (74.5 KB)
-
Step 1: Setup Google Sheets
- First make a copy of this google sheet or create a similar yourself!
- Next start with the ‘Search Rows’ module from Google sheets and link it to the google sheet.
-
Step 2: Setup Browserflow
- Find the “Scrape Profiles from a LinkedIn Search” module from Browserflow for LinkedIn.
- Next, fill the search term for the person you would like to find by typing the job title and link the company from the Google Sheets module.
- Leave the other fields on default
-
Step 3: Create JSON
- Now, to create a JSON of the results, grab the ‘Aggregate to JSON’ module.
- Link the Browserflow module as the source Module
- Now create a new JSON structure. First start with an array, in the array choose collection and then add the following fields: name, linkedinUrl and tagline.
- Save the data structure.
- Now choose ‘Map’ and add the data in the peopleArray field
-
Step4: Choose the right person with GPT
- Now we are going to evaluate which of the results is the most relevant.
- First make sure to get a ChatGPT API key here
- Now choose ‘Create a Chat Completion’ and choose a model (I choose gpt-3.5-turbo as it should be good enough)
- Then create a system message in which you explain what the system should do. I have added my system message below. It is important to give guidelines about the result to make sure a valid JSON is the output.
- Also create a user message in which you add the title you are looking for, the company and the json object (If you cannot select the JSON object, you should run the whole workflow one time to let Make recognise the data).
System Message
Find the most relevant person in the json array and return the name and url as a json object only: { "name":<name>, "linkedinUrl":<linkedinUrl>, "tagline": <tagline> }.
It is very important that the response contains only the json. it should start with { and end with }.
User Message:
The person i'm looking for is the Commercial Director of {{1.`0`}}.
These are the results:
{{6.json}}
-
Step 5: Parse Result as JSON
- Now we will parse the result of Chat GPT as a JSON, in order to do so choose the Parse JSON module.
- Then, use the result of the Chat GPT module in the JSON string field
- Now run the whole workflow so Make can recognise the data.
-
Step 6: Add data to Spreadsheet
- The last module is to save your data back in your spreadsheet
- Choose the Update a Row module from Google Sheets
- Then connect it to the same spreadsheet, now the fields should be visible
- Connect the output of the JSON Parser module to the appropriate fields.
You are done
Now you can start run your workflow to fill up your spreadsheet with the information of the right persons.
Pro tip: You can also attach other Browserflow modules to send messages or connection invite. I have created another Blueprint about this: [BLUEPRINT] 🚀 Scrape LinkedIn Profiles, Generate Custom Messages & Send them Automatically - #3 by Raf
Please let me know if you run into anything!