Turn a job description into a clean list of LinkedIn profiles saved in Google Sheets. Recruiters and HR teams can build a first pass candidate list fast and avoid manual searching.

A chat message starts the flow. Your text goes to OpenAI, which creates a Boolean search string for Google. The system creates a new sheet with a timestamped name and adds a linkedin_url column. It calls Google Search with your cookie header, waits 5 seconds between pages, and pulls 10 results at a time. A code step extracts only LinkedIn profile links from the HTML and writes them to the sheet. Pagination keeps going until the limit you set in the If step is reached.

You need an OpenAI API key, a Google Sheets account, and a valid cookie header from your browser to run authenticated Google searches. Most teams get a list in minutes and save hours each week on sourcing. Tune the page limit for more or fewer results, and use this for any role where LinkedIn is a key channel.

• Chat intake collects the job description or ideal candidate profile
• OpenAI builds a Boolean search string tailored to your role text
• Creates a new Google Sheet with a timestamped title automatically
• Adds a dedicated linkedin_url column for clean data storage
• Authenticates Google Search via header and cookie for consistent results
• Waits 5 seconds between page requests to reduce rate limits
• Parses Google HTML and extracts LinkedIn profile links with code
• Appends each batch to the sheet and paginates 10 results per loop
• Stops when the start value passes your target count set in the If node

• Reduce manual research from hours to minutes
• Automate 100 percent of copy and paste link collection
• Improve data accuracy by saving only LinkedIn profile URLs
• Handle 50 results by default and scale to hundreds with one change
• Connect OpenAI and Google Sheets without custom code

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with OpenAI and Google Sheets. See the Tools Required section above for links to create accounts with these services.
3. Open the Generate a Boolean Search String node. In the Credential to connect with field, click Create new credential and add your OpenAI API key from your OpenAI account API page. Save and test the credential.
4. Open each Google Sheets node and select Credential to connect with. Click Create new credential and follow the on screen steps to authorize your Google account. Choose the spreadsheet or allow n8n to create a new one.
5. Set up HTTP header auth for Google Search. Install a cookie editor extension in your browser, visit google.com, perform a search, export the header string, then in the n8n credentials manager create an HTTP Header Auth credential and paste the cookie value as provided by the export.
6. In the Google Boolean Search node, confirm the User Agent header is present and the cookie header credential is selected under Credential to connect with.
7. Open the If node and set the limit. The condition checks if start is less than 50 by default. Change 50 to the total number of results you want.
8. Open the Wait node and confirm it is set to delay about 5 seconds between page requests to avoid rate limiting.
9. Check the Create a new sheet node and ensure the Google Sheets document target is correct. The following nodes will add the linkedin_url column and write rows to this sheet.
10. Activate the workflow. Click Open Chat in n8n and paste a job description or your ideal candidate profile.
11. Watch the execution logs. Confirm the search string is generated, the HTTP requests return data, and rows appear in your sheet.
12. If no links appear, verify the cookie header is valid, confirm your Google account access to the target spreadsheet, and review the code node for successful extraction.