AUtomation flow Creation Google sheet to LinkedIn URL Profile Help

Hi
Does anyone know how to create a flow that will that take all the company listed in a column google sheet and go to linkedin company page for each and copy url link of ‘‘director’’ company and paste in a new column of the google sheet?

Hi there,

You can indeed build an automation that will scrape links provided in a google sheet column. The following help article should be helpful for you: https://support.bardeen.ai/hc/en-us/articles/29931926537613-How-to-Integrate-Google-Sheets-with-Playbooks

Regarding the scraping part of the automation, I can suggest you first check if one of our pre-built scraper models is fetching the information you need from LinkedIn. If no, then you can build your own custom scraper model.

You can see the list of our official scrapers in playbook builder, they have (by Bardeen) in title:

If you will decide to build your own model, please review our guide here: https://support.bardeen.ai/hc/en-us/articles/23925200748173-How-to-use-Bardeen-scraper

Also here is a Getting Started guide which introduces you to Bardeen Basics https://www.bardeen.ai/tutorials/getting-started and here is a list of tutorials https://www.bardeen.ai/tutorials.

Hope this helps!
Victoria

Customer Support - bardeen.ai
Knowledge Base https://support.bardeen.ai/hc/en-us
Explore | @bardeenai | Bardeen Community

Hi Support

That doesn’t answer my question.

Here is the flow I am trying to create:

  1. Take column C "company name’’

  2. Scrape LinkedIn Company page, search for Director

  3. Add LinkedIn URL profile in Column D

Can you tell me how does it look like on Bardeen to a flow that works as above?

See below…
Screenshot 2024-09-19 at 15.58.17.png

Fatima Deeney

AI Advisor & Business Transformation Specialist

London, United Kingdom

+44 7597 506 156

www.aibotsconsultancy.com

Hi Fatima,

My apologies for misunderstanding. Now I see that you have a column not with links, but with company names. To implement a flow like that, you can connect automation to google sheet’s column with company names and as next action use a scraper configured to scrape from LinkedIn company search page with that name pasted as search parameter. Then, depending on what exactly you would like to scrape from found LinkedIn company page, you can either use our pre-built scraper template or build your custom model. I could not find any example page with Director value available, would it be possible to share an example? Is Director a standard field or some value that you would like to find using AI?

Please also review this video explanation: https://www.loom.com/share/8ba776203c5149799e577d3c5f9528b7?sid=0aaf9762-89ee-43e1-a068-3eb06f8fc90c

Also feel free to use this playbook as a starting point for your automation: https://www.bardeen.ai/playbook/community/Company-List-Enrichment-Playbook-LinkedIn-BbKWO8RYaOMoPqIjxj

Hope this helps!
Victoria

Customer Support - bardeen.ai
Knowledge Base https://support.bardeen.ai/hc/en-us
Explore | @bardeenai | Bardeen Community

Thank you Victoria
I will have a try now and see if it works out for me.

Fatima Deeney

AI Advisor & Business Transformation Specialist

London, United Kingdom

+44 7597 506 156

www.aibotsconsultancy.com