This n8n workflow streamlines the process of scraping Glassdoor job listings tailored to specific search parameters and storing the results in Google Sheets for easy analysis. It integrates Bright Data for web scraping, uses a form trigger for customization, and leverages AI for crafting outreach pitches.
The workflow begins with a sticky note providing an overview and support info. It includes a form trigger where users can input job search criteria such as location, keyword, and country code. When the form is submitted, an HTTP POST request is sent to Bright Data to initiate a new dataset snapshot based on those filters.
A wait node polls for the dataset’s completion. Once ready, another HTTP request retrieves the scraped job data from Bright Data. This data is then parsed and appended to a Google Sheet using a predefined template, enabling users to have a structured database of job listings.
The workflow further splits each job listing to analyze relevant fields like company name, job title, and description. It then uses a language model (GPT-4) to generate tailored outreach pitches based on the job details, specifically targeting roles related to marketing, content creation, or engagement. These pitches can be used for outreach or prospecting.
Finally, the generated pitches are saved back to Google Sheets, completing an automated and customizable prospecting process suitable for recruiters, marketers, or agencies seeking targeted job opportunities and outreach automation.
This workflow is highly practical for automating the retrieval of new job openings, creating personalized outreach messages, and maintaining an organized record of opportunities for proactive recruitment or marketing outreach.
Reviews
There are no reviews yet.