Cold Email Outreach: Personalized by Business with Gmail, Google Sheet, and Gemini

This n8n workflow automates personalized cold email outreach campaigns. It reads contact and business data from a Google Sheet, uses Google Gemini's AI capabilities to generate highly personalized email content based on business information, and then sends these emails via Gmail. The workflow includes logic to prevent sending emails to contacts who have already been contacted.

What it does

1. Triggers on a Schedule: The workflow starts automatically at predefined intervals (e.g., daily, weekly) to check for new outreach opportunities.
2. Reads Contact Data: It fetches contact and business information from a specified Google Sheet. This sheet should contain details like contact names, email addresses, and relevant business data.
3. Filters Already Contacted Leads: It checks if a contact has already been marked as "Contacted" in the Google Sheet. If so, it skips that contact to avoid duplicate outreach.
4. Prepares Data for AI: For each new contact, it extracts and formats the necessary business information to be used as context for the AI.
5. Generates Personalized Email Content: It leverages the Google Gemini Chat Model via an AI Agent to craft a unique, personalized cold email for each contact, taking into account their specific business details.
6. Sends Personalized Emails: The generated email content is then used to send a personalized email to the contact via Gmail.
7. Updates Google Sheet: After successfully sending an email, the workflow updates the Google Sheet, marking the contact as "Contacted" to maintain an accurate record and prevent future duplicate outreach.

Prerequisites/Requirements

• n8n Instance: A running n8n instance.
• Google Sheets Account: A Google account with access to Google Sheets.
• Gmail Account: A Google account with access to Gmail.
• Google Gemini API Key: Access to the Google Gemini API for the AI Agent. This typically involves setting up a project in Google Cloud and enabling the Gemini API.
• Google Sheets Credential: An n8n credential for Google Sheets (OAuth2 recommended).
• Gmail Credential: An n8n credential for Gmail (OAuth2 recommended).
• Google Gemini Chat Model Credential: An n8n credential for the Google Gemini Chat Model.
• Google Sheet: A Google Sheet structured with columns for contact information (e.g., Name, Email, Business_Details, Contacted).

Setup/Usage

1. Import the Workflow: Import the provided JSON into your n8n instance.
2. Configure Credentials:
   • Set up your Google Sheets credential.
   • Set up your Gmail credential.
   • Set up your Google Gemini Chat Model credential.
3. Configure Google Sheets Node (ID: 18):
   • Specify the Spreadsheet ID of your outreach Google Sheet.
   • Ensure the Sheet Name is correct.
   • Verify the Read Operation is set to read all relevant data.
4. Configure If Node (ID: 20):
   • Adjust the condition to check your "Contacted" column in the Google Sheet. For example, {{ $json.Contacted !== 'TRUE' }}.
5. Configure Edit Fields Node (ID: 38):
   • Map the incoming data from Google Sheets to the fields expected by the AI Agent node. This might involve renaming or combining fields to create a clear prompt for the AI.
6. Configure AI Agent Node (ID: 1119):
   • Select your Google Gemini Chat Model credential.
   • Craft the System Message and User Message to guide Gemini in generating the personalized email. Ensure the prompt clearly instructs the AI on the email's purpose, tone, and what information to use from the input data (e.g., {{ $json.name }}, {{ $json.business_details }}).
   • Define the Output Schema to ensure the AI returns the email subject and body in a structured format that can be used by the Gmail node.
7. Configure Gmail Node (Not explicitly shown in JSON but implied by workflow purpose):
   • Add a Gmail node after the AI Agent.
   • Select your Gmail credential.
   • Map the email subject and body from the AI Agent's output to the respective fields in the Gmail node.
   • Map the recipient email address from the Google Sheet data.
8. Configure Google Sheets Update Node (Not explicitly shown in JSON but implied by workflow purpose):
   • Add another Google Sheets node after the Gmail node.
   • Set the Operation to "Update Row" or "Update Cell".
   • Specify the row to update (e.g., using a unique identifier from the initial read).
   • Set the "Contacted" column to TRUE or a similar indicator.
9. Activate the Workflow: Enable the workflow to start running on its defined schedule.

This workflow provides a powerful and efficient way to scale your cold email outreach while maintaining a high level of personalization, significantly improving engagement rates.