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.