Generate Personalized Sales Outreach from LinkedIn Job Signals with Apify & Google Gemini

This n8n workflow automates the process of generating highly personalized sales outreach messages by leveraging LinkedIn job signals. It uses Apify to scrape job data, Google Gemini to craft tailored messages, and Google Sheets to manage the input and output.

What it does

This workflow streamlines your sales outreach by:

1. Triggering Manually: Initiates the workflow upon manual execution.
2. Fetching Job Data: Retrieves a specified number of job postings from a Google Sheet.
3. Filtering Data: Ensures only valid job entries (where a 'jobUrl' exists) are processed.
4. Extracting Job ID: Uses a Code node to extract the unique job ID from the LinkedIn job URL.
5. Scraping LinkedIn Job Details (Apify): Utilizes an HTTP Request node to call the Apify API, specifically the "LinkedIn Job Scraper" actor, to get detailed information about the job posting using the extracted job ID.
6. Parsing Scraped Data: Processes the JSON output from Apify to make it usable for the next steps.
7. Generating Personalized Outreach (Google Gemini): Employs a Basic LLM Chain with the Google Gemini Chat Model to generate a personalized sales outreach message based on the scraped job description and other relevant details.
8. Structuring LLM Output: Uses a Structured Output Parser to extract the generated outreach message and a summary of the job description into a defined JSON format.
9. Merging Data: Combines the original job data with the newly generated outreach message and job summary.
10. Removing Duplicates: Ensures that only unique outreach messages are processed further.
11. Limiting Output: Restricts the number of items processed to avoid overwhelming downstream systems (e.g., for testing or batch processing).
12. Updating Google Sheet: Writes the generated personalized outreach message and job summary back to the original Google Sheet, associating them with the respective job entries.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running instance of n8n.
• Google Sheets Account: To store and retrieve job posting data.
• Apify Account: With access to the "LinkedIn Job Scraper" actor and an API token.
• Google Gemini API Key: For the Google Gemini Chat Model.
• n8n Credentials: Configured for Google Sheets, Apify (HTTP Request), and Google Gemini.

Setup/Usage

1. Import the Workflow: Download the JSON provided and import it into your n8n instance.
2. Configure Credentials:
   • Google Sheets: Set up a Google Sheets credential. Specify the spreadsheet ID and sheet name where your job data is stored and where the outreach messages will be written. Ensure the sheet has columns for jobUrl, personalized_outreach, and job_description_summary.
   • Apify (HTTP Request): Create an HTTP Request credential for Apify. You will need your Apify API token.
   • Google Gemini: Set up a Google Gemini Chat Model credential with your API key.
3. Review Node Configurations:
   • Google Sheets (Read): Ensure the "Spreadsheet ID" and "Sheet Name" are correctly set to read the initial job data.
   • HTTP Request (Apify): Verify the Apify API endpoint and the token parameter in the URL query. Ensure the jobId is correctly passed from the previous node.
   • Google Gemini Chat Model: Review the prompt to ensure it aligns with your desired outreach message style and content.
   • Structured Output Parser: Confirm the schema matches the expected output from the Gemini model.
   • Google Sheets (Update): Ensure the "Spreadsheet ID" and "Sheet Name" are correctly set to write the results, and the "Update Key" is set to jobUrl (or another unique identifier) to match the correct rows.
4. Activate the Workflow: Once configured, activate the workflow.
5. Execute Manually: Click "Execute Workflow" to run it. The workflow will fetch jobs, generate outreach, and update your Google Sheet.