This n8n workflow automates the process of fetching new freelance job postings from Upwork, logging them in a Google Sheet, generating concise summaries using AI, and sending email notifications with the summarized information. Designed for freelancers and agency managers, this workflow ensures timely updates on relevant job opportunities. It runs on a daily schedule, making it ideal for maintaining an up-to-date job pipeline without manual effort.

The workflow begins with a scheduled trigger set at a specific time each day, which activates a request to an Apify scraper that retrieves the latest Upwork jobs based on predefined criteria. The data is then formatted to extract key fields such as job title, URL, description, budget, and posting date. These structured entries are appended to a Google Sheet for record-keeping.

Next, the workflow leverages OpenAI’s language models to create human-readable summaries of the fetched jobs. These summaries are parsed into a clear structure and used to craft a comprehensive email. The email, sent via Gmail, delivers a digest of current jobs, providing a quick overview for busy freelancers or teams. Additional enhancements can include filtering specific job types, avoiding duplicates, or integrating Slack notifications for team alerts.

This automation streamlines lead generation, saves time, and enhances workflow efficiency by combining web scraping, AI-based summarization, and automated email alerts, making it perfect for continuous job monitoring and quick response strategies.

Node Count	11 – 20 Nodes
Nodes Used	@n8n/n8n-nodes-langchain.agent, @n8n/n8n-nodes-langchain.lmChatOpenAi, @n8n/n8n-nodes-langchain.outputParserStructured, gmail, googleSheets, httpRequest, scheduleTrigger, set, stickyNote