BigMailer Google Sheets

Automate job discovery & AI proposals across Upwork, Freelancer, Guru & PPH with OpenRouter

This advanced automation system monitors multiple freelance platforms like Upwork and Guru in real-time to capture new job postings instantly. It intelligently generates tailored AI proposals through OpenRouter and logs every lead into a centralized Google Sheet for effortless pipeline management. By automating the discovery and outreach cycle, freelancers can significantly increase their response speed and win more high-value projects.

Run this with your team's AI

What This Recipe Does

Staying competitive on freelance platforms like Upwork requires constant monitoring and lightning-fast response times. This automation transforms your lead generation process by monitoring Vollna RSS feeds for new job postings in real-time. Instead of manually refreshing browser tabs, this workflow automatically captures relevant job listings, filters them based on your specific criteria, and initiates the outreach process immediately. By integrating Gmail and Google Sheets, the system sends personalized application emails and maintains a comprehensive log of every lead pursued. This ensures you are consistently among the first to apply, significantly increasing your chances of winning contracts. The automation handles the repetitive tasks of data entry and initial outreach, allowing you to focus entirely on closing deals and delivering high-quality work. It provides a scalable way to grow your freelance business or agency without increasing your administrative overhead. By centralizing all lead data in Google Sheets, you gain a clear overview of your sales pipeline and application performance.

What your team gets

Something anyone can use

Forms and dashboards, so it is not a script only one person understands

It keeps running

Runs on your schedule in the cloud, so it does not stop when a laptop closes

Your other tools can call it

Endpoints, so the rest of your stack can trigger the same work

Accounts connected once

BigMailer, Google Sheets connected for the team, not per person

How It Works

  1. 1

    Open the recipe and connect your accounts

    Connect BigMailer and Google Sheets once, in your team cloud, and nobody has to do it again on their own machine

  2. 2

    Tell your own agent what is different about your process

    Claude, ChatGPT, Cursor, whichever your team already uses. It adapts the recipe to how you actually work

  3. 3

    Run it, then leave it running

    It lives in your team cloud, so it keeps going after you close the laptop and every teammate's AI can use it

Who Uses This

Frequently Asked Questions

What accounts do I need to use this automation?

You will need an active Vollna account (or a similar RSS feed provider), a Gmail account for sending outreach, and a Google account to log data in Google Sheets.

Can I filter for specific types of jobs?

Yes, the workflow includes filtering steps where you can define specific keywords, budget requirements, or client criteria to ensure you only apply for relevant roles.

Is it possible to customize the application email?

Absolutely. You can customize the Gmail template within the workflow to include your specific pitch, portfolio links, and personal branding.

How does this help my sales tracking?

Every job identified and every email sent is automatically logged in a Google Sheet, providing you with a real-time audit trail and a structured sales pipeline.

Coming from n8n?

This recipe uses nodes like RssFeedReadTrigger, SplitInBatches, Code, Set and 9 more. On Runwork, you don't need to learn n8n's workflow syntax. Describe what you want to your own AI agent in plain English.

RssFeedReadTrigger SplitInBatches Code Set Langchain.lmChatOpenRouter Filter Gmail GoogleSheets Langchain.agent Wait Aggregate Html Limit

Based on n8n community workflow. View original

Related Recipes

nocodb

Automated personalized email outreach with AI, database tracking & scheduling

This automated solution bridges the gap between your data management and active sales outreach by systematically processing leads from NocoDB and delivering them directly to your inbox. By utilizing a scheduled trigger, the system eliminates the need for manual data entry and constant spreadsheet monitoring. It intelligently filters through your database to identify specific records based on your criteria, ensuring that only the most relevant opportunities are prioritized. The integration of date-time formatting ensures that all communication is timestamped and organized, allowing sales teams to act on fresh information without delay. This automation transforms a static database into a proactive sales engine, reducing administrative overhead and allowing your team to focus on closing deals rather than managing rows of data. It ensures a consistent follow-up cadence and prevents high-value prospects from falling through the cracks, ultimately driving higher conversion rates and more efficient resource allocation.

See the recipe
Http

Score Upwork jobs and generate proposals with Apify, Google Sheets and Telegram

Finding high-quality freelance opportunities on Upwork often feels like a full-time job in itself. The Upwork Job Scraper with AI Scoring automates the tedious process of searching, filtering, and evaluating job postings, allowing you to focus entirely on winning projects. This automation monitors the Upwork marketplace in real-time, pulling new listings directly into a structured Google Sheet. Instead of manually reading every description, the integrated AI analyzes each posting against your specific criteria to assign a compatibility score. This ensures you only spend time on leads that match your expertise and budget requirements. To keep you ahead of the competition, the system sends instant notifications via Telegram the moment a high-scoring opportunity is identified. By reducing the time spent on lead generation from hours to minutes, this tool provides a significant competitive advantage, ensuring you are among the first to apply for the most lucrative projects in your niche.

See the recipe
Jotform Http Jina AI Airtable-pat

Generate B2B leads from any city & business type using GMaps, Jina.ai & GPT-5

The Lead-Generator-GMaps automation transforms how sales teams identify and qualify potential clients by bridging the gap between local search data and actionable outreach. Instead of manually scouring Google Maps and copy-pasting business details, this workflow automates the entire discovery process. It captures leads via a simple form, scrapes relevant business information using Jina AI, and enriches the data to ensure high quality. Once processed, the automation organizes these leads directly into Airtable for long-term tracking and sends instant notifications to Slack, allowing your sales team to act on fresh opportunities immediately. By automating the research phase, your team can focus on closing deals rather than data entry. This tool ensures that your pipeline is constantly fed with verified local business data, significantly reducing the time spent on manual prospecting and improving the speed of your outreach cycles.

See the recipe
Jotform Airtable-pat Gmail

Qualify & auto-reply to leads with OpenAI, Airtable, and Gmail

The AI Lead Qualifier & Auto Draft Reply agent transforms how your sales team handles incoming inquiries. Instead of manually sorting through every form submission, this automation uses artificial intelligence to instantly analyze lead data, determine potential value, and categorize prospects in Airtable. It eliminates the delay between a customer's interest and your response by automatically generating a personalized email draft in Gmail, tailored specifically to the lead's inquiry. To ensure your team never misses a high-value opportunity, the system sends immediate notifications via Slack and WhatsApp. By automating the initial qualification and drafting phase, your sales representatives can stop performing administrative data entry and focus their energy on closing deals with the most promising prospects. This workflow ensures a consistent, rapid response time that significantly increases conversion rates and professionalizes your initial touchpoint.

See the recipe

Run this with the AI your team already uses

Your agent adapts it, your team cloud keeps it running, and everyone's AI can find it.

Open this recipe in Runwork