LinkedIn Job Scraping and Store Results in Google Sheets

This workflow automates LinkedIn job scraping using Bright Data and stores results in Google Sheets. Key nodes include Job Search Form Trigger (captures search inputs), Form Input Validator (checks inputs), Request Parameter Builder (formats parameters), Bright Data Job Search API (fetches job data), Polling nodes (manage API response timing), Job Data Cleaner and Formatter (processes data), Google Sheets Job Data Appender (saves data), and response nodes (Success Response, Form Validation Error, Bright Data API Error, Timeout Error, No Jobs Found, Google Sheets Error).\n\nSetup Requirements and Configuration: Install n8n from n8n.io for self-hosting or sign up at cloud.n8n.io. Follow setup prompts or create a cloud account. Create a Bright Data account at brightdata.com, navigate to ‘Datasets,’ select LinkedIn Jobs, and copy the API key and dataset ID. Create a Google Sheet named ‘LinkedIn Jobs Data’ with headers: Job Posting ID, Job Title, Company Name, Job Location, Job Description, Salary Min, Salary Max, Apply Link, Posted Date, Search Timestamp. Obtain Google Sheets OAuth credentials via Google Cloud Console: enable Sheets API, create credentials. In n8n, import the JSON workflow. Configure Bright Data Job Search API with API key and dataset ID. Set the Google Sheets Appender with OAuth credentials and document ID. Ensure HTTPS for webhook (Job Search Form Trigger). Verify server supports API calls.\n\nTesting and Deployment Steps: Activate the workflow to get the form URL. Access it in a browser, enter job details (e.g., Location: ‘New York,’ Keywords: ‘Software Engineer,’ Country: ‘US’), and submit. Success response (200) returns jobs_found, search_parameters, and processing_time_seconds. Error responses include 400 (invalid inputs), 408 (timeout), 404 (no jobs), 503 (API failure), or 500 (Sheets error). Check logs for errors like ‘Invalid API key,’ ‘Invalid country code,’ or ‘Sheets access denied.’ Validate Google Sheet output: ensure columns like Job Title, Apply Link, and Search Timestamp are populated correctly. Debug using n8n logs for network or credential issues. Ensure stable internet for API reliability.