All templates By NappAI team Enviar correos en frío
Este flujo automatiza el envío masivo y personalizado de promociones. Primero, unifica la información de un producto (entrada manual) con una base de datos de contactos desde Google Sheets. Posteriormente, inicia un bucle de procesamiento donde, para cada
graph TD
%%{init: {'theme': 'mc','layout': 'elk'}}%%
Airtable-ojvmv[Airtable]
style Airtable-ojvmv stroke:#a170ff
Switch-yspgu[Switch]
style Switch-yspgu stroke:#a170ff
Airtable-8tft9[Airtable2]
style Airtable-8tft9 stroke:#a170ff
TextInput-1io3j[<div><img src="/_astro/type.Dy26vmDy.svg" style="height: 20px !important;width: 20px !important"/></div>Text Input]
style TextInput-1io3j stroke:#a170ff
CreateData-btrwx[Create Data]
style CreateData-btrwx stroke:#a170ff
Prompt-9hzqr[<div><img src="/_astro/square-terminal.BMOXc-nZ.svg" style="height: 20px !important;width: 20px !important"/></div>Prompt]
style Prompt-9hzqr stroke:#a170ff
GoogleGenerativeAIModel-q8ex2[Gemini]
style GoogleGenerativeAIModel-q8ex2 stroke:#a170ff
Prompt-i300b[<div><img src="/_astro/square-terminal.BMOXc-nZ.svg" style="height: 20px !important;width: 20px !important"/></div>Prompt2]
style Prompt-i300b stroke:#a170ff
GoogleGenerativeAIModel-n8rva[Gemini2]
style GoogleGenerativeAIModel-n8rva stroke:#a170ff
GmailMesageComponent-72pt4[<div><img src="/_astro/gmail.CLxyIGOu.svg" style="height: 20px !important;width: 20px !important"/></div>Gmail Message]
style GmailMesageComponent-72pt4 stroke:#a170ff
Airtable-ojvmv -.- Switch-yspgu
linkStyle 0 stroke:#a170ff
Switch-yspgu -.- Airtable-8tft9
linkStyle 1 stroke:#a170ff
Airtable-8tft9 -.- CreateData-btrwx
linkStyle 2 stroke:#a170ff
TextInput-1io3j -.- CreateData-btrwx
linkStyle 3 stroke:#a170ff
CreateData-btrwx -.- Prompt-9hzqr
linkStyle 4 stroke:#a170ff
Prompt-9hzqr -.- GoogleGenerativeAIModel-q8ex2
linkStyle 5 stroke:#a170ff
GoogleGenerativeAIModel-q8ex2 -.- Prompt-i300b
linkStyle 6 stroke:#a170ff
Prompt-i300b -.- GoogleGenerativeAIModel-n8rva
linkStyle 7 stroke:#a170ff
GoogleGenerativeAIModel-n8rva -.- GmailMesageComponent-72pt4
linkStyle 8 stroke:#a170ff
Enviar correos en frío
🧩 Overview
This workflow automates the process of sending personalized promotional emails to a list of contacts. It begins by gathering product information and a list of recipient emails, then processes each contact individually to generate a custom email body and subject line using AI. Finally, it sends the email and updates the contact database to track the outreach.
⚙️ Main Features
- Fetches a list of recipient email addresses and their status from an Airtable database.
- Filters contacts to target only those who have not yet been contacted.
- Dynamically creates personalized email content, including a professionally designed HTML body and a concise subject line, using Google's Gemini AI models.
- Automatically sends the generated emails via Gmail.
- Updates the contact record in Airtable to mark the email as sent, preventing duplicate outreach.
🔄 Workflow Steps
| Component Name | Role in the Workflow | Key Inputs | Key Outputs |
|---|---|---|---|
| Airtable | Reads contact records from a specified Airtable base and table. | Base name, table name, field selection. | List of contact records, including email addresses and a sent status. |
| Switch | Filters the contact list, routing only records where the email has not been marked as sent. | Contact data list, condition to check the 'sent' status. | Filtered list of contacts eligible for outreach. |
| Airtable2 | Updates the filtered contact records in the database to mark them as "sent". | Contact record IDs, new status value. | Confirmation of the updated records. |
| Text Input | Provides a manual input for the product or service description to be promoted. | User-defined JSON or text describing the product. | Structured product/service information. |
| Create Data | Merges the filtered contact data (email) with the product description into a unified dataset for processing. | Contact email, product description. | A combined data object for each contact. |
| Prompt | Constructs a detailed instruction for the AI to generate the HTML body of the promotional email. | Product description from the unified data. | A formatted prompt message for the AI model. |
| Gemini | Generates a persuasive, professionally styled HTML email body based on the provided product details. | Prompt for email body generation. | The generated HTML email content. |
| Prompt2 | Constructs a concise instruction for the AI to generate a short and compelling email subject line. | Contact email address (for context). | A formatted prompt message for subject line generation. |
| Gemini2 | Creates a personalized and attractive email subject line. | Prompt for subject line generation. | The generated email subject text. |
| Gmail Message | Sends the final email using the recipient's address, the AI-generated subject, and the AI-generated HTML body. | Recipient email, email subject, email body. | Confirmation of the sent email. |
🧠 Notes
- The workflow is designed for batch processing, handling multiple contacts sequentially and in parallel.
- It requires valid API credentials for Airtable, Google Gemini AI, and Gmail to function.
- The initial Airtable component must be configured to read the correct fields, including the email address and a status field (e.g., 'enviado').
- The Switch component acts as a critical gatekeeper, ensuring emails are only sent to new contacts.
- The AI-generated email body is designed with inline CSS for maximum compatibility across email clients.