Telegram Google Sheets BigMailer Jotform

Automated B2B lead generation & cold emails with OpenAI, Apify, Gmail & Telegram

This end-to-end automation transforms your sales process by scraping B2B prospects via Apify and using AI to extract verified contact information. It intelligently drafts personalized outreach emails with customized tones, delivers them through Gmail, and provides real-time progress updates directly to Telegram. Every lead and interaction is neatly logged in Google Sheets, ensuring your pipeline remains organized and automated from start to finish.

Run this with your team's AI

What This Recipe Does

This automated lead generation system transforms how sales teams capture and nurture prospects. Instead of manually tracking inquiries and drafting individual follow-ups, this workflow creates a seamless pipeline from initial contact to active engagement. When a prospect submits a form, the system immediately logs their data in Google Sheets, categorizes the lead, and triggers a personalized outreach campaign via Gmail. To ensure you never miss a high-priority opportunity, the automation sends real-time notifications to your Telegram account, allowing you to respond instantly from any device. By utilizing intelligent wait steps and batch processing, the workflow maintains a natural communication cadence that increases response rates while preventing your inbox from being flagged as spam. This solution eliminates the administrative burden of lead management, ensuring that every inquiry is captured, tracked, and contacted without a single manual step. It allows your sales team to focus on closing deals rather than managing spreadsheets and drafting repetitive emails.

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

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

How It Works

  1. 1

    Open the recipe and connect your accounts

    Connect Telegram 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

Do I need to keep the application open to send emails?

No. Once the workflow is activated, it runs automatically in the background 24/7, even when your computer is turned off.

Can I customize the delay between the initial contact and follow-up emails?

Yes. The wait nodes can be adjusted to any timeframe, such as minutes, hours, or days, to match your specific sales cycle.

Is it possible to connect a different messaging platform instead of Telegram?

While this recipe is optimized for Telegram, the notification step can be swapped for Slack, Microsoft Teams, or SMS alerts.

How does the system prevent sending too many emails at once?

The workflow includes batch processing logic that staggers outgoing communications, ensuring your email deliverability remains high and your account stays secure.

Coming from n8n?

This recipe uses nodes like Telegram, GoogleSheets, If, Filter 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.

Telegram GoogleSheets If Filter Gmail Set Langchain.lmChatOpenAi Langchain.informationExtractor Wait SplitInBatches HttpRequest FormTrigger StickyNote

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