n8n Automated Template Delivery System with Stripe, GPT-4o, and Gmail

This n8n workflow automates the delivery of personalized templates to customers upon successful Stripe payments. It leverages AI (GPT-4o via Azure OpenAI) to generate custom content based on customer data and then sends this content as an email via Gmail.

What it does

This workflow simplifies the process of delivering digital products or personalized content after a purchase, ensuring a seamless and automated customer experience.

1. Triggers on a Schedule: The workflow is set to run periodically to check for new Stripe payments.
2. Fetches Stripe Payments: It retrieves recent successful payments from Stripe.
3. Filters for New Payments: It checks if a payment has already been processed by comparing it against a Google Sheet of processed orders.
4. Generates Personalized Content (AI Agent): For each new payment, an AI Agent (using Azure OpenAI Chat Model) generates a personalized template or message based on the customer's purchase details.
5. Parses AI Output: A Structured Output Parser extracts the relevant information from the AI Agent's response.
6. Sends Personalized Email: The generated content is then used to send a personalized email to the customer via Gmail.
7. Records Processed Orders: The details of the processed order are added to a Google Sheet to prevent duplicate processing.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Account: A running instance of n8n.
• Stripe Account: Configured with a webhook or API access to fetch payment data.
• Azure OpenAI Account: With access to a GPT-4o (or similar) chat model.
• Gmail Account: To send personalized emails.
• Google Sheets Account: To maintain a record of processed orders.

Setup/Usage

1. Import the Workflow: Import the provided JSON into your n8n instance.
2. Configure Credentials:
   • Stripe: Set up your Stripe API credentials.
   • Azure OpenAI: Configure your Azure OpenAI Chat Model credentials, including API key, endpoint, and model name (e.g., gpt-4o).
   • Gmail: Set up your Gmail OAuth 2.0 credentials.
   • Google Sheets: Configure your Google Sheets OAuth 2.0 credentials.
3. Configure Google Sheets Node (ID: 18):
   • Specify the Spreadsheet ID and Sheet Name where processed orders will be recorded.
   • Ensure the sheet has columns for relevant order details (e.g., Stripe Payment ID, Customer Email, Template Sent Date).
4. Configure Stripe Node (ID: 499):
   • Set the Operation to retrieve payments.
   • Adjust the Limit and Date Range as needed for your polling interval.
5. Configure AI Agent Node (ID: 1119):
   • Select the Azure OpenAI Chat Model (ID: 1253) as the Language Model.
   • Provide a clear System Message and User Message to guide the AI in generating the desired template content. The user message should include dynamic data from the Stripe payment (e.g., {{ $json.data.customer_details.email }} or {{ $json.data.amount_total }}).
   • Define the Tools the AI Agent can use if necessary (though none are explicitly configured in this basic structure).
6. Configure Structured Output Parser Node (ID: 1179):
   • Define the Schema for the expected JSON output from the AI Agent (e.g., { "subject": "string", "body": "string" }).
7. Configure Gmail Node (ID: 356):
   • Set the Recipient Email using an expression like {{ $json.customer_email }} from the parsed AI output or Stripe data.
   • Set the Subject and Body of the email using expressions from the Structured Output Parser's output (e.g., {{ $json.subject }} and {{ $json.body }}).
8. Activate the Workflow: Enable the workflow to start running on its defined schedule.

Make sure to test the workflow thoroughly with test payments in Stripe before deploying it to a production environment.