Google Sheets Bot for Slack

Automate personalized cold emails with Apollo lead scraping and GPT-4.1

Transform your sales prospecting by combining Apollo lead scraping with advanced AI analysis to build highly targeted outreach lists. The workflow automatically visits prospect websites and employs GPT-4 to generate bespoke icebreakers and subject lines tailored to each company's unique value proposition. This end-to-end automation bridges the gap between raw lead data and meaningful, personalized engagement at scale.

Run this with your team's AI

What This Recipe Does

The Custom Cold Email Icebreaker Writer automates the most time-consuming part of outbound sales: research and personalization. By connecting your Google Sheets prospect list to advanced AI processing, this automation analyzes lead data to generate unique, contextually relevant opening lines for every email. Instead of sending generic templates that prospects ignore, your sales team can deliver high-touch messages at scale. The system processes leads in batches, filters for data quality, and delivers the results directly to your team via Slack for review or pushes them back to your database. This significantly improves email open rates and response metrics by ensuring every recipient feels like the message was written specifically for them, all while saving hours of manual research time every week.

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

Google Sheets, Bot for Slack connected for the team, not per person

How It Works

  1. 1

    Open the recipe and connect your accounts

    Connect Google Sheets and Bot for Slack 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 information do I need to provide for the icebreakers to be effective?

The automation works best when your Google Sheet includes the prospect's name, company, and a link to their website or LinkedIn profile to provide the AI with sufficient context.

Can I adjust the tone of the generated icebreakers?

Yes, you can define the specific style, length, and professional tone within the application settings to match your brand's unique voice.

How does the batching process work?

The system processes your prospect list in manageable groups to ensure data accuracy and avoid hitting API limits, making it reliable for lists of any size.

Where are the final icebreakers delivered?

The generated lines are automatically updated in your source Google Sheet and can also be sent to a Slack channel for immediate team visibility and approval.

Coming from n8n?

This recipe uses nodes like Langchain.openAi, SplitInBatches, ManualTrigger, GoogleSheets and 6 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.

Langchain.openAi SplitInBatches ManualTrigger GoogleSheets Set Filter HttpRequest Code Slack 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