Scraper: How can I separate the first name and last name when scraping data from LinkedIn profiles to Google Sheets?

You can separate the first name and last name from LinkedIn profiles in two ways:

1. Use a Google Sheet formula after scraping the profile name. This is because the LinkedIn profile page has both names within the same selector.

2. Use Bardeen's "Split string" action to separate the names by the space character. However, this might not work in all cases, especially if there are middle names. The workflow for this is: Scrape LinkedIn -> Split string.

Alternatively, you can use our OpenAI actions to separate the names, which will require custom prompting.

For more details, visit the original forum post here.

get bardeen

Don't just connect your apps, automate them.

200,000+ users and counting use Bardeen to eliminate repetitive tasks

Effortless setup
AI powered workflows
Free to use
Little Rocket Ship

Launch your productivity boost today.

By clicking “Accept”, you agree to the storing of cookies. View our Privacy Policy for more information.