It sounds like you’ve scraped LinkedIn data and added it into Google Sheets. And now you’d like to add more Company data from LinkedIn and update your Google Sheet - is that right?
Would you mind sharing your automation? and Google Sheet Publicly?
Bardeen has a pre-built scraper template called “LinkedIn employee count insights (by Bardeen)” that can scrape the total amount of employees for you.