{"product_id":"scrape-lawn-care-jobs-auto-post-linkedin-with-n8n-sheets-groq-gemini","title":"Scrape Lawn Care Jobs \u0026 Auto-Post LinkedIn with n8n, Sheets, Groq \u0026 Gemini","description":"\u003ch3\u003eTurn new lawn care job listings into ready-to-post LinkedIn updates—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow scrapes lawn care job openings from multiple career sites, keeps everything updated in Google Sheets, cleans each job’s page text, and then uses Google Gemini + Groq (via LangChain) to generate compliance-focused LinkedIn posts that can be published and tracked with Telegram reporting.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eStarts via Telegram or schedule:\u003c\/b\u003e Triggered by a Telegram bot command or a cron timetable.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eScrapes from multiple sources \u0026amp; updates Sheets:\u003c\/b\u003e Pulls job listings from company career pages (e.g., TruGreen, SavATree, Perennial Services Group, Senske\/UKG, Paylocity job boards, Breezy HR, and SilkRoad) and appends\/updates records in \u003cb\u003eGoogle Sheets\u003c\/b\u003e using \u003cb\u003eReq ID\u003c\/b\u003e as the key.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eRoutes by brand-specific URL patterns:\u003c\/b\u003e Validates each record has an \u003cb\u003eOriginal URL\u003c\/b\u003e, then sends it through the correct scraper based on the URL.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eExtracts clean job text:\u003c\/b\u003e Fetches each job detail page, sanitizes the HTML into plain text, and writes it back to Sheets with fields like \u003cb\u003eText created\u003c\/b\u003e and \u003cb\u003eDate Text Created\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eDrafts LinkedIn-ready posts with Gemini + Groq:\u003c\/b\u003e For posting, loads cleaned job text, validates \u003cb\u003eJob Text\u003c\/b\u003e, and prompts a \u003cb\u003eLangChain\u003c\/b\u003e agent using \u003cb\u003eGoogle Gemini\u003c\/b\u003e and \u003cb\u003eGroq\u003c\/b\u003e to draft a compliance-focused LinkedIn organization post.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003ePublishes and logs results:\u003c\/b\u003e Publishes approved posts to \u003cb\u003eLinkedIn\u003c\/b\u003e and writes the LinkedIn post URL, published status, post text, and publish date back to Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eTracks status + produces reports:\u003c\/b\u003e Sends \u003cb\u003eTelegram\u003c\/b\u003e updates and generates total, daily, and weekly posting reports from Google Sheets metrics.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAutomation engineers maintaining a job lead pipeline for lawn care hiring.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators who want structured job data in Google Sheets and automated LinkedIn promotion.\u003c\/li\u003e\n  \u003cli\u003eTeams that need repeatable scraping, text extraction, LLM drafting, and publication logging.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003en8n nodes:\u003c\/b\u003e if, set, code, html, switch, linked in\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eIntegrations:\u003c\/b\u003e Telegram (trigger + status), Google Sheets (storage + reporting), LinkedIn (publishing + logging)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eLLM generation:\u003c\/b\u003e LangChain agent using \u003cb\u003eGoogle Gemini\u003c\/b\u003e and \u003cb\u003eGroq\u003c\/b\u003e for LinkedIn post drafting\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45974321135795,"sku":"N8N-19286","price":5.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/jpQK5y0bi0H0_3JphqdDe_QSfkHHZ8.png?v=1788772416","url":"https:\/\/buyflowscripts.com\/products\/scrape-lawn-care-jobs-auto-post-linkedin-with-n8n-sheets-groq-gemini","provider":"N8N Commerce","version":"1.0","type":"link"}