Google Sheets Microsoft Outlook Email Google Docs Http

AI-driven lead management and inquiry automation with ERPNext & n8n

This smart automation bridge connects ERPNext with AI to instantly vet new leads and classify their intent with precision. By dynamically routing inquiries to the correct team members via Google Sheets and drafting professional replies, it ensures no high-value opportunity ever slips through the cracks. Say goodbye to manual triage and hello to an AI-powered sales assistant that works around the clock.

Run this with your team's AI

What This Recipe Does

This sales automation workflow transforms how your team manages the transition from prospect to closed deal. By integrating essential tools like Google Sheets, Microsoft Outlook, and Google Docs, it creates a seamless bridge between data management and client communication. The process begins by capturing lead information and instantly organizing it within your central tracking system. From there, the automation intelligently evaluates the lead data to determine the next steps, such as generating customized sales proposals or contracts directly in Google Docs. By eliminating the need to manually copy and paste information between platforms, your sales representatives can focus on relationship building rather than administrative tasks. The automation ensures that every potential client receives a timely, professional response through Microsoft Outlook, complete with the necessary documentation attached. This speed and precision not only increase your team's productivity but also significantly improve the customer experience. Whether you are managing a high volume of inbound inquiries or complex enterprise deals, this workflow provides the structural support needed to scale your sales operations without increasing your overhead costs.

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, Microsoft Outlook Email, Google Docs, Http connected for the team, not per person

How It Works

  1. 1

    Open the recipe and connect your accounts

    Connect Google Sheets and Microsoft Outlook Email 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 manually enter data into the Google Doc templates?

No, the automation pulls data directly from your lead source or spreadsheet and populates the document automatically.

Can I change the email messaging sent through Outlook?

Yes, you can fully customize the email body and subject line within the workflow to match your brand's voice.

Does this work with my existing sales spreadsheet?

The workflow is designed to connect to your specific Google Sheets, allowing you to map existing columns to the automation steps.

What happens if a lead does not meet certain criteria?

The built-in logic allows the workflow to filter leads, ensuring that documents and emails are only generated for qualified prospects.

Coming from n8n?

This recipe uses nodes like Langchain.agent, Langchain.lmChatOpenAi, GoogleSheetsTool, Set and 7 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.agent Langchain.lmChatOpenAi GoogleSheetsTool Set If MicrosoftOutlook Code GoogleDocsTool StickyNote HttpRequest Webhook

Based on n8n community workflow. View original

Related Recipes

HubSpot BigMailer

Build targeted prospect lists: find & enrich leads with Surfe to HubSpot

Manually building prospecting lists is a significant bottleneck for sales teams, often consuming hours that should be spent closing deals. This automation streamlines the entire process by capturing prospect data from external sources and instantly syncing it with your CRM. Instead of copying and pasting information between tabs, this workflow uses intelligent filtering to ensure only high-quality leads enter your pipeline. Once a prospect is identified and verified, the system automatically creates or updates a record in HubSpot, maintaining data integrity and eliminating manual entry errors. Furthermore, it bridges the gap between discovery and outreach by integrating directly with Gmail, allowing you to trigger personalized notifications or initial contact the moment a new lead is qualified. By automating the repetitive task of list building, your sales team can focus on high-value interactions and strategic outreach. This workflow ensures your pipeline stays full of actionable opportunities without the administrative overhead usually required to maintain it.

See the recipe
Google Sheets

Automate scraping Y Combinator startups with Apify & Google Sheets

Staying ahead in the venture capital and startup ecosystem requires immediate access to data on the world's most promising new companies. This automation simplifies the process of tracking Y Combinator startups by bridging the gap between web data and your internal database. By integrating Apify's powerful scraping capabilities with Google Sheets, this workflow automatically extracts detailed information on YC-backed companies and organizes it into a structured, shareable format. Instead of manually searching directories and copying data point by data point, business development teams can now generate comprehensive lead lists in minutes. This tool ensures your CRM or investment pipeline is always populated with the latest information from the most recent cohorts, allowing you to focus on outreach and analysis rather than manual data entry. Whether you are looking for potential partners, investment opportunities, or competitive intelligence, this automation provides a reliable, scalable way to monitor the startup landscape.

See the recipe
DaySchedule Google Sheets Telegram

Reddit freelance job monitor with Google Sheets tracking and Telegram alerts

This sales intelligence and lead notification automation bridges the gap between data discovery and active outreach. By scheduling regular checks across external data sources and internal databases, the system identifies high-potential sales opportunities without manual intervention. The automation fetches fresh lead data through web requests, filters the results based on your specific business criteria, and synchronizes the information with Google Sheets to maintain a centralized source of truth. This process eliminates the need for sales representatives to manually refresh dashboards or hunt for new prospects across different platforms. Instead, the system pushes real-time alerts directly to Telegram, ensuring your team can respond to new leads within minutes. This proactive approach significantly increases conversion rates by shortening the response time and keeps your prospecting data organized and actionable. By automating the repetitive tasks of lead monitoring and data entry, your sales team can focus their energy entirely on high-value activities like closing deals and building client relationships.

See the recipe
Salesforce

Automated AI lead enrichment: Salesforce to Explorium for enhanced prospect data

Manual lead research is a significant bottleneck for high-growth sales teams, often resulting in outdated information and missed opportunities. This automation eliminates the manual grind by connecting Salesforce directly to Explorium's external data engine. Whenever a new lead is created or updated in Salesforce, the workflow automatically triggers a data enrichment process. It filters the incoming data, processes it through custom logic, and pulls deep firmographic and demographic insights from Explorium to fill the gaps in your CRM. By ensuring every prospect record is automatically populated with accurate, high-quality data, your sales representatives can stop hunting for phone numbers and company details and start focusing on high-value outreach. The result is a more efficient sales pipeline, better lead scoring accuracy, and a significantly higher conversion rate driven by personalized, data-backed communication.

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