How to Automate Sales Emails & Follow-ups With AI (No Coding!)
Most sales teams waste hours each week researching leads and writing repetitive emails. This AI sales assistant automatically handles client outreach, writes personalized messages, and keeps your pipeline organized - saving you 40+ hours per month without writing a single line of code.
The Hidden Cost of Manual Sales Outreach
Sales teams typically spend 2-3 hours per lead on research, email writing, and follow-ups. At 20 leads per week, that's 40-60 hours monthly - nearly two full work weeks wasted on repetitive tasks. The worst part? Most of this effort disappears into unorganized inboxes and forgotten spreadsheets.
The breakthrough came when we realized AI could handle the research and writing tasks that consume most of this time. By combining lead research APIs with generative AI, we built a system that creates personalized outreach automatically.
Key insight: 78% of sales emails never get opened because they're too generic. The AI assistant solves this by creating truly personalized messages based on real-time company research.
How the AI Sales Assistant Works
The system follows a simple but powerful sequence: First, it takes lead information from your Google Sheets. Next, it researches the company using Tavly's API. Then, OpenAI generates personalized email and SMS content referencing the company's recent news and your relevant products.
Everything gets saved back to Google Sheets, creating a complete record of each interaction. The workflow runs automatically whenever you add new leads - no manual triggering needed.
Before vs After: Manual outreach requires constant context switching between research tabs, email clients, and CRM systems. The AI assistant keeps everything in one synchronized workflow that runs in the background.
Step 1: Get the Pre-Built Workflow
The fastest way to start is with our pre-built sales assistant template. You'll need a n8n instance running (we recommend hosting on Webspace Kit for simplicity).
After downloading the workflow file, import it into your n8n account by selecting "Start from scratch" then "Import from file." The workflow will appear with warning icons indicating which connections still need configuration.
Step 2: Connect Google Sheets
Google Sheets serves as both your lead database and the output destination for all AI-generated content. First, make a copy of our template sheet (linked in the description).
In n8n, open the Google Sheets node and create new credentials. You'll need to set up a project in Google Cloud Console to get your client ID and secret. The video at 4:30 shows this process step-by-step.
Pro Tip: Fill your Google Sheet with detailed product descriptions and real client success stories. The AI uses this information to craft more persuasive emails.
Step 3: Connect OpenAI
OpenAI provides the language model that generates your email and SMS content. You'll need an OpenAI API key (requires adding a payment method to your account).
Simply paste your API key into the OpenAI node in n8n. The second OpenAI node will connect automatically. At 7:15 in the video, you can see exactly how to get and enter your API key.
Step 4: Connect Tavly for Lead Research
Tavly's API provides real-time company data that makes your outreach relevant. After getting your Tavly API key (shown at 8:40 in the video), paste it into the Tavly node in n8n.
The system will now automatically research each lead's company before generating content. This ensures your emails reference recent company news and developments.
Result: Emails that demonstrate you've done your homework, increasing open rates by 2-3x compared to generic templates.
See It In Action: Automated Outreach Results
After running the workflow, check your Google Sheet. You'll find complete company overviews, suggested solutions, email subjects, full email text, and SMS messages automatically generated for each lead.
The system even structures the information in a way that makes it easy to copy-paste into your email client or CRM. At 9:50 in the video, you can see the exact output format.
Watch the Full Tutorial
See the complete setup process from start to finish in the video below. The 10-minute tutorial shows every click and configuration needed to get your AI sales assistant running.
Key Takeaways
This AI sales assistant proves you don't need a big team or technical skills to automate outreach. With the right workflow, even solo entrepreneurs can deliver enterprise-level personalization at scale.
In summary: Connect Google Sheets for lead data, OpenAI for content generation, and Tavly for research. The system handles the rest, freeing you to focus on closing deals rather than administrative tasks.
Frequently Asked Questions
Common questions about this topic
The AI sales assistant automates three key sales tasks: First, it researches leads by gathering company information automatically. Second, it generates personalized email and SMS content tailored to each lead. Third, it organizes all lead data in Google Sheets so you have a complete record of every interaction.
Unlike basic email templates, this system creates messages that reference specific details about each lead's company, making your outreach feel genuinely personal rather than generic.
- Researches companies using Tavly's API
- Writes emails referencing recent company news
- Structures all information in an organized Google Sheet
No coding is required. The workflow uses a visual interface where you simply connect pre-built components. The most technical part is copying API keys from services like OpenAI and Google Sheets - but we provide step-by-step instructions for each connection.
The entire setup process takes about 30 minutes if you follow along with the video tutorial. Most users complete it in one sitting without any technical assistance.
- Visual interface with drag-and-drop components
- Detailed video instructions for each step
- No programming languages or scripts to write
Most sales teams spend 2-3 hours per lead on research and outreach. This automation reduces that to about 10 minutes of setup time per lead, then runs automatically. For teams handling 20+ leads weekly, this saves 40-60 hours per month.
The time savings compound because the system maintains all your lead information in one organized place. No more hunting through old emails or trying to remember previous conversations.
- 90% reduction in time spent per lead
- All historical data remains searchable
- No context switching between tools
Yes, the system pulls from your Google Sheets where you can add your product details, success stories, and preferred messaging style. The AI then uses this information to craft emails that sound like you wrote them personally.
For best results, include 3-5 detailed client success stories in your sheet. The AI will reference these naturally in conversations, helping build credibility without sounding salesy.
- Add your brand voice examples
- Include detailed product descriptions
- Provide real client success stories
The core workflow integrates with Google Sheets for data storage, OpenAI for content generation, and Tavly for lead research. You can optionally connect it to your email service provider or CRM to send the automated emails directly.
Many users start by copying the AI-generated content into their existing email workflow, then gradually automate more steps as they become comfortable with the system.
- Required: Google Sheets, OpenAI, Tavly
- Optional: Your email service (Gmail, Outlook, etc)
- Optional: Your CRM (HubSpot, Salesforce, etc)
The content quality depends on the information you provide in your Google Sheets. With detailed product descriptions and real client success stories, the AI produces highly relevant emails. We recommend reviewing the first few automated emails before sending to ensure they meet your standards.
The system improves over time as you refine your Google Sheet content. Many users report better results after the first month as they add more examples of their preferred messaging style.
- Quality improves with more input data
- First drafts may need light editing
- Becomes more accurate with usage
The only limits are your Google Sheets capacity and OpenAI API usage. Google Sheets can handle thousands of leads, while OpenAI charges per API call. For most small businesses, the cost is under $20/month even with heavy usage.
Enterprise users may want to upgrade to n8n's paid plans for higher execution limits, but the free tier works perfectly for teams processing up to 100 leads weekly.
- Google Sheets: 10 million cell limit
- OpenAI: Pay-as-you-go pricing
- n8n: Free tier handles 100+ leads weekly
GrowwStacks helps businesses implement automation workflows, AI integrations, and scalable systems tailored to their operations.
Whether you need a custom workflow, AI automation, or a full multi-platform automation system, the GrowwStacks team can design, build, and deploy a solution that fits your exact requirements.
- Custom automation workflows built for your business
- Integration with your existing tools and platforms
- Free consultation to discuss your automation goals
Ready to Automate Your Sales Outreach?
Every hour spent on manual research and email writing is an hour not spent closing deals. Let GrowwStacks build you a custom AI sales assistant that works while you sleep.