Generate Personalized Cold Emails with GPT-4o Mini and Google Sheets

This n8n workflow automates the process of generating personalized cold emails using data from a Google Sheet and OpenAI's GPT-4o Mini, then updates the sheet with the generated email content.

What it does

This workflow simplifies and automates the following steps:

1. Triggers Manually: The workflow starts when manually executed.
2. Reads Data from Google Sheets: It fetches a specified range of data from a Google Sheet, likely containing recipient information and context for the emails.
3. Loops Over Items: It processes each row (item) from the Google Sheet individually.
4. Prepares Data for OpenAI: A Code node transforms the incoming Google Sheet data into a structured prompt suitable for the OpenAI API, including a system message and user message to guide the email generation.
5. Generates Personalized Email with OpenAI: It sends the prepared prompt to OpenAI (likely using the gpt-4o-mini model, given the directory name context) to generate a personalized cold email.
6. Updates Google Sheet: It takes the generated email content and updates the corresponding row in the Google Sheet, adding the personalized email to a designated column.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Account: A running instance of n8n.
• Google Sheets Account: Access to a Google Sheet containing the data for your cold email recipients.
• OpenAI API Key: An API key for OpenAI with access to their models (e.g., gpt-4o-mini).

Setup/Usage

1. Import the Workflow:

   • Download the provided JSON file for this workflow.
   • In your n8n instance, go to "Workflows" and click "New".
   • Click the three dots next to the "New Workflow" button and select "Import from JSON".
   • Paste the workflow JSON or upload the file.

2. Configure Credentials:

   • Google Sheets:
     • Click on the "Google Sheets" node.
     • Click "New Credential" and follow the instructions to authenticate your Google account. Ensure it has access to the target spreadsheet.
     • Specify the "Spreadsheet ID" and the "Range" you want to read from (e.g., Sheet1!A:E).
     • In the second "Google Sheets" node (for updating), ensure the same credential is used, and specify the "Spreadsheet ID" and the "Range" for updating (e.g., Sheet1!F if you're writing to column F).
   • OpenAI:
     • Click on the "OpenAI" node.
     • Click "New Credential" and enter your OpenAI API Key.

3. Customize the Code Node:

   • Open the "Code" node.
   • Review the JavaScript code. This is where you define the structure of the prompt sent to OpenAI.
   • Adjust the systemMessage and userMessage to fit your specific cold email strategy, including placeholders for data coming from Google Sheets (e.g., {{ $json.name }}, {{ $json.company }}).
   • Ensure the output of this node matches the expected input for the OpenAI node.

4. Customize the OpenAI Node:

   • Open the "OpenAI" node.
   • Select the desired "Model" (e.g., gpt-4o-mini).
   • Adjust other parameters like Temperature or Max Tokens as needed to control the creativity and length of the generated emails.

5. Test and Activate:

   • Save the workflow.
   • Click "Execute Workflow" to run a test.
   • Review the output in the n8n interface and in your Google Sheet to ensure emails are generated and updated correctly.
   • Once satisfied, activate the workflow.

This workflow provides a powerful foundation for automating personalized outreach, saving significant time and effort.