Merge multiple rows coming from a single link into one row and output to Google sheet

[c0546]

Hello Community,

Is it possible to merge multiple rows which are outputs from scraping of a single link into one row and output to a single row in Google sheet?

I’m trying to output the multiple rows output which are previous experiences of a single linkedin profile into one row.

Please let me know if anyone has any idea.

[Jess]

Hi @c0546

I believe this is possible with the “Merge Text” action and possibly might need the “Get rows into table” action.

If you shared your automation, it might help me understand the use case better to confirm.

Thank you,
Jess

[c0546]

Hi @Jess,

Thanks for responding back!

I believe “Merge Text” action merges the columns and not the rows. I’ve tried using it but only possible for columns.

For example, this is my output from the automation. Role, company and duration in three different columns and multiple rows. But it all belongs to a single person, so I want them to be combined into one row.

Founder	Stealth Startup · Full-time	Oct 2023 - Present · 1 mo
Head of Research And Development	contextflow · Full-time	Nov 2020 - Sep 2023 · 2 yrs 11 mos
Chief Scientific Officer	ThinkSono	Feb 2018 - Sep 2020 · 2 yrs 8 mos
Entrepreneur In Residence	Entrepreneur First	Aug 2017 - Dec 2017 · 5 mos
Consultant	ThinkSono	Jan 2017 - Sep 2017 · 9 mos
Research Associate	Imperial College London	Oct 2015 - Jul 2017 · 1 yr 10 mos
Scientist	Siemens Healthcare	Jul 2014 - Sep 2015 · 1 yr 3 mos

Here’s my automation:

{{playbook_title}}

Any help would be highly appreciated. This is directly related to my other post -

Scraping the complete experiences of the Linkedin profile (Including company names, roles, durations)

Hello Bardeen Community, I am embarking on a project where I need to scrape the experience section of LinkedIn profiles, encompassing company names, roles, and durations. However, I have hit a roadblock due to the variable nature of the HTML structure of LinkedIn, which seems to fluctuate from profile to profile. The conventional methods I’ve tried so far are falling short in capturing all the necessary details consistently. I am reaching out to see if anyone here has tackled similar challenge…

[Jess]

Okay so it appears you are scraping the Experience Section from LinkedIn Profiles and these are your results:

Founder	Stealth Startup · Full-time	Oct 2023 - Present · 1 mo
Head of Research And Development	contextflow · Full-time	Nov 2020 - Sep 2023 · 2 yrs 11 mos
Chief Scientific Officer	ThinkSono	Feb 2018 - Sep 2020 · 2 yrs 8 mos
Entrepreneur In Residence	Entrepreneur First	Aug 2017 - Dec 2017 · 5 mos
Consultant	ThinkSono	Jan 2017 - Sep 2017 · 9 mos
Research Associate	Imperial College London	Oct 2015 - Jul 2017 · 1 yr 10 mos
Scientist	Siemens Healthcare	Jul 2014 - Sep 2015 · 1 yr 3 mos

And you’re wanting to put them into one row? Could you provide an example of what your end goal would look like? I’m trying to imagine but struggling.

Thank you,
Jess

[c0546]

Sure, No worries. Thanks again.

I would prefer the output in a single row such as the below:

As it all belongs to a single person. Bardeen is considering each item as a separate entity and consuming a lot of credits right now.

Please let me know if you require more information.

[Jess]

Okay thank you, a few further questions for you below:

Would you mind sharing a link to your playbook so I can trial/error on my end?

@c0546

consuming a lot of credits right now.

Is this the only reason you are wanting to consolidate your results into one row?

If so, I’m not sure it’s possible to decrease the number of credits even if we find a way to do this. I will say that I am not very familiar with the premium scraper action pricing so I could be wrong too!

[c0546]

Sure, Please find the playbook below.

{{playbook_title}}

My goal is to extract the complete information of previous jobs from a Linkedin profile. I’m happy to know if there’s a different way to do it. The Linkedin scraper that Bardeen has only extracts the current job information.

[Jess]

Thank you @c0546, I was able to accomplish your use case to consolidate the row into one table through this playbook: https://www.bardeen.ai/playbook/community/Scraping-www.linkedin.com-1p5ezy2kZUjIM92ksE

As mentioned above, consolidating your results into one row can be accomplished with the “Merge Text” action AND the “Get rows into Table”

Make sure to select this option and separate each column per Merge Text action out:

Thank you,
Jess

[c0546]

Thanks so much @Jess. Getting the outcome as expected.

However, its still consuming the same number of credits. Do you think there’s a way to get all experiences from a profile using CSS selectors instead of using the list scraper mode in Bardeen which makes consume extra credits?

[Jess]

If you run the automation on “Scrape data in the active tab” action, it won’t consume any credits. The list scraper templates don’t consume credits.

Per the pricing page, only premium action results require credits:
Pricing (bardeen.ai)

If you have any further questions, please create a new post. Thank you!

[c0546]

Thanks @Jess. I’ll try that for now