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:
-
Take column C "company nameââ
-
Scrape LinkedIn Company page, search for Director
-
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âŚ
Fatima Deeney
AI Advisor & Business Transformation Specialist
London, United Kingdom
+44 7597 506 156
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