Competitive Hiring Intelligence System using Phantombuster and Google Sheets - n8n Workflow

1. HR Analysts and Recruiters needing market intelligence on competitor hiring.


2. Data teams requiring periodic, structured data extraction from public web sources.


3. Users looking for advanced n8n templates integrating external scraping APIs (like Phantombuster).


4. Businesses needing a recurring n8n trigger to manage scheduled data flows.

Keeping track of competitors' hiring strategies is crucial for market positioning. Manually checking job boards is time-consuming and inefficient. This specialized n8n workflow solves this problem by creating a fully automated Competitive Hiring Intelligence System. The system uses a scheduled n8n trigger to periodically read a list of target companies from a Google Sheet, initiate a LinkedIn scraping job via the Phantombuster API, wait for the results, and then automatically format and append the structured data (Job Title, Description, Location, etc.) to a results sheet. This powerful n8n automation template ensures you always have up-to-date, organized intelligence without manual intervention. Every n8n node in this flow is configured for reliability and efficiency.

This n8n workflow operates on a weekly cycle to ensure fresh data:

1. Scheduled Kick-off: The process starts with the '⏰Schedule Trigger' n8n trigger, configured to run every Monday at 9:00 AM.


2. Input Retrieval: The '📄Read Companies Sheet' n8n node connects to a Google Sheet to fetch a list of target companies. It specifically filters for companies marked 'Pending' to process only new entries.


3. Scraper Initiation: For each company retrieved, the '🚀 Trigger Phantombuster Scraper' HTTP Request n8n node calls the Phantombuster API to launch a specific scraping agent, passing the LinkedIn profile URL as an argument.


4. Execution Pause: The '⏳ Wait for Scraper to Finish' n8n node pauses the execution for 3 minutes, giving the external Phantombuster agent time to complete the scrape operation.


5. Output Fetch: The '📦 Fetch Scraped CSV Link' HTTP Request n8n node uses the container ID received earlier to retrieve the public URL of the scraped data output (CSV).


6. Data Structuring: The '🛠️Format Job Data' n8n node processes the raw data, mapping the output fields into clean, standardized variables (Job Title, Company Name, Job Link, etc.).


7. Final Storage: The final step, using the '📊Write to Results Sheet' Google Sheets n8n node, appends the fully formatted job data, along with the current scrape date, into the designated 'Job Results' spreadsheet, completing the execution of this comprehensive n8n workflow.

1. Import the n8n Workflow: Copy the provided JSON data and paste it directly into your n8n instance under the 'Workflows' section.


2. Phantombuster Credentials: You need a paid Phantombuster account. Edit the '🚀 Trigger Phantombuster Scraper' and '📦 Fetch Scraped CSV Link' n8n nodes. Replace YOURPHANTOMBUSTERAPIKEYHERE with your actual API key in the header parameters. Also, update YOURPHANTOMBUSTERAGENTID.


3. Google Sheets Credentials: Configure a Google Sheets OAuth2 credential. Replace the placeholder IDs (YOURGOOGLESHEETSCREDENTIALID, YOURGOOGLESHEETIDHERE, YOURRESULTSSHEETID_HERE) in both Google Sheets n8n nodes with your actual credential ID and spreadsheet IDs.


4. Sheet Setup: Ensure you have two Google Sheets: one 'Companies List' with a 'LinkedIn' column and a 'Status' column (for input), and a 'Job Results' sheet (for output).


5. Activation: Set the n8n workflow to 'Active' to enable the weekly schedule.

⏰ Schedule Trigger (n8n trigger):
Function: Initiates the entire recurring n8n workflow.
Key Configuration: Runs every Monday at 9:00 AM (CRON: 0 9 1).
📄 Read Companies Sheet (Google Sheets n8n node):
Function: Retrieves input data (LinkedIn URLs) from the specified spreadsheet.
Key Configuration: Filters rows where the column 'Status' equals 'Pending'.
🚀 Trigger Phantombuster Scraper (HTTP Request n8n node):
Function: Makes an API call to Phantombuster to start the scraping job.
Key Configuration: Uses a POST method, includes the Phantombuster API Key header, and passes the LinkedIn URL from the sheet using an n8n expression ({{ $json.LinkedIn }}).
⏳ Wait for Scraper to Finish (Wait n8n node):
Function: Ensures the n8n workflow pauses until the external scraping job is likely complete.
Key Configuration: Configured to wait for 3 minutes.
📦 Fetch Scraped CSV Link (HTTP Request n8n node):
Function: Retrieves the link to the generated output data file from Phantombuster.
Key Configuration: Uses the containerId dynamically fetched from the output of the preceding 'Trigger Phantombuster Scraper' n8n node.
🛠️ Format Job Data (Set n8n node):
Function: Standardizes and organizes the messy, raw scraped data into defined fields for clean entry.
Key Configuration: Defines output fields like 'Company Name', 'Job Title', 'Job Link', and 'Date Posted'.
📊 Write to Results Sheet (Google Sheets n8n node):
Function: Writes the clean, structured data as new rows into the results spreadsheet.
* Key Configuration: Operation set to 'Append', and automatically adds a 'Scraped Date' using the current date via a simple n8n expression.