Skip to content
NEWError doctor and Watchtower: failed n8n runs explained in plain words, and emailed to you. See what is new

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

  1. Snapshot Progress
  2. On form submission - Discover Jobs
  3. HTTP Request- Post API call to Bright Data
  4. Wait - Polling Bright Data
  5. If - Checking status of Snapshot - if data is ready or not
  6. HTTP Request - Getting data from Bright Data
  7. Google Sheets - Adding All Job Posts
  8. Split Out
  9. OpenAI Chat Model
  10. Google Sheets
  11. Basic LLM Chain - Checking Fit
  12. Error Handler
  13. Stopanderror 1
  14. Stopanderror 2

42 steps in total.

Similar automations