Library / Web Scraping & Research
Web Scraping & Research
Scrape LinkedIn Jobs to Google Sheets with OpenAI
When a form is submitted, it scrapes LinkedIn job posts through Bright Data, cleans them with OpenAI and saves them to Google Sheets.
What it does
# Stickynote Workflow ## Overview Automated workflow: Stickynote Workflow. This workflow integrates 10 different services: stickyNote, httpRequest, formTrigger, wait, splitOut. It contains 26 nodes and follows best practices for error handling and security. ## Workflow Details - Total Nodes: 26 - Node Types: 10 - Error Handling: ✅ Implemented - Security: ✅ Hardened (no sensitive data) - Documentation: ✅ Complete ## Node Breakdown - Sticky Note9: stickyNote - Snapshot Progress: httpRequest - Sticky Note10: stickyNote - Sticky Note1: stickyNote - On form submission - Discover Jobs: formTrigger - HTTP Request- Post API call to Bright Data: httpRequest - Wait - Polling Bright Data: wait - If - Checking status of Snapshot - if data is ready or not: if - HTTP Request - Getting data from Bright Data: httpRequest - Google Sheets - Adding All Job Posts: googleSheets - ... and 16 more nodes ## Usage Instructions 1. Configure Credentials: Set up all required API keys and credentials 2. Update Variables: Replace any placeholder values with actual data 3. Test Workflow: Run in test mode to verify functionality 4. Deploy: Activate the workflow for production use ## Security Notes - All sensitive data has been removed or replaced with placeholders - Error handling is implemented for reliability - Follow security best practices when configuring credentials ## Troubleshooting - Check error logs if workflow fails - Verify all credentials are properly configured - Ensure all required services are accessible
The steps
- Snapshot Progress
- On form submission - Discover Jobs
- HTTP Request- Post API call to Bright Data
- Wait - Polling Bright Data
- If - Checking status of Snapshot - if data is ready or not
- HTTP Request - Getting data from Bright Data
- Google Sheets - Adding All Job Posts
- Split Out
- OpenAI Chat Model
- Google Sheets
- Basic LLM Chain - Checking Fit
- Error Handler
- Stopanderror 1
- Stopanderror 2
42 steps in total.
Similar automations
Web Scraping & ResearchScrape Upwork Jobs with Apify and Email Daily Reports20 stepsWeb Scraping & ResearchScrape LinkedIn Jobs with Bright Data and OpenAI42 stepsWeb Scraping & ResearchScrape LinkedIn and Indeed Jobs with Bright Data16 stepsWeb Scraping & ResearchScrape LinkedIn Jobs with Apify and Rate with Gemini6 steps