AcademyWorkflowsSales

Personalized Cold Emails from Google Sheets with Gemini

Sales and outbound teams that keep prospects in a spreadsheet and want a tailored first-touch draft for each one.

Use it nowWant it running at your company?
  • Recommendedour rating
  • 3,462views on n8n

Use it now

Open inClaudeChatGPTGeminiPerplexity
Open on n8n.io ↗

Paste it straight onto an n8n canvas with Ctrl+V or Cmd+V.

Third party software. By copying, downloading or installing it you accept the Academy legal notice: you are responsible for reviewing its code and permissions before use.

automate-cold-outreach-with-email-personalization-using-gemini-and-google-sheets.json

Loading the file...

What it does

Reads a lead list from Google Sheets on a schedule you set and skips rows that already have a generated email. For each new lead it sends details like name, company, role and notes to Google Gemini, which writes a personalized email draft that is saved back to the sheet.

Use cases

  1. 01Draft first-touch emails for a new prospect list
  2. 02Tailor messages by industry or job title
  3. 03Add pain points in a column and get matching copy

Connects

Google Sheets · Basic LLM Chain · Structured Output Parser · Google Gemini Chat Model

Questions about
Personalized Cold Emails from Google Sheets with Gemini.

What is Personalized Cold Emails from Google Sheets with Gemini used for?

Sales and outbound teams that keep prospects in a spreadsheet and want a tailored first-touch draft for each one. Reads a lead list from Google Sheets on a schedule you set and skips rows that already have a generated email. For each new lead it sends details like name, company, role and notes to Google Gemini, which writes a personalized email draft that is saved back to the sheet.

How do I import Personalized Cold Emails from Google Sheets with Gemini into n8n?

Copy the workflow JSON from this page and paste it onto the n8n canvas with Ctrl+V or Cmd+V. Then connect your credentials in each node.

Is Personalized Cold Emails from Google Sheets with Gemini safe to use?

It passed our automatic scan for credential theft, hidden instructions and risky install commands. Third party open source software. Sabemos AI does not maintain it. Check the code and permissions before you connect it to company data.

Related resources

Read the guide: AI sales agents and lead generation ↗

  1. 001Business Contact FinderSales and outreach teams that need to find a working way to contact a company.OfficialMCP server · ★ 7.3k
  2. 002Sales EngineerSales and pre-sales teams preparing technical demos and proposals for prospects.RecommendedSubagent
  3. 003Google Maps Scraper KitSales and business development teams building prospect lists of local businesses for outreach.RecommendedSkill · ★ 1.4k
  4. 004Building Your First WhatsApp ChatbotSales teams that want a WhatsApp assistant to answer product questions from a catalog.RecommendedWorkflow · 332k views
  5. 005Scrape business emails from Google MapsSales and business development teams that need a list of local business contacts for outreach.RecommendedWorkflow · 150k views
  6. 006Generate Leads with Google MapsSales teams that build local prospect lists from Google Maps data and keep them in a spreadsheet.RecommendedWorkflow · 82k views