Automate Digital Product Sales & Delivery with Stripe and Email

This n8n workflow automates the process of selling and delivering digital products using Stripe for payments and email for delivery. It ensures that once a customer purchases a product, they automatically receive access to it, and the transaction is logged for tracking.

What it does

This workflow streamlines your digital product sales and delivery by performing the following steps:

1. Monitors Stripe for New Sales: It acts as a webhook listener, triggering whenever a new successful checkout.session.completed event occurs in Stripe.
2. Records Sales in Google Sheets: For each successful sale, it adds a new row to a specified Google Sheet, logging details like customer information and product purchased.
3. Retrieves Product Information: It fetches details about the purchased product from a Google Sheet, which likely contains information such as the product name, download link, or access instructions.
4. Filters for Unique Products: It removes any duplicate product entries to ensure each unique product is processed only once per order.
5. Delivers Digital Product via Email:
   • It constructs an email containing the product delivery information (e.g., download links, access keys).
   • It sends this email to the customer using Microsoft Outlook.
6. Manages Product Access (Optional/External): It includes a placeholder for executing a sub-workflow, indicating that further actions related to product access (e.g., granting access to a platform, generating unique keys) could be integrated here.
7. Logs HTTP Requests (Optional): It includes an HTTP Request node, which could be used for logging, sending data to another API, or triggering external systems based on the sale.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Account: A running instance of n8n.
• Stripe Account: Configured with products and checkout sessions.
• Stripe Credentials: An n8n credential for Stripe to listen for events.
• Google Account: With access to Google Sheets and Google Drive.
• Google Sheets Credentials: An n8n credential for Google Sheets to read product data and log sales.
• Google Drive Credentials: An n8n credential for Google Drive (though its specific use isn't directly connected in the provided JSON, it's present in the workflow).
• Microsoft Outlook Account: To send delivery emails.
• Microsoft Outlook Credentials: An n8n credential for Microsoft Outlook.

Setup/Usage

1. Import the Workflow: Import the provided JSON into your n8n instance.
2. Configure Credentials:
   • Set up your Stripe credential for the "Stripe Trigger" node.
   • Set up your Google Sheets credential for the "Google Sheets" nodes.
   • Set up your Google Drive credential for the "Google Drive" node (if you intend to use it).
   • Set up your Microsoft Outlook credential for the "Microsoft Outlook" node.
3. Configure Stripe Trigger:
   • Activate the "Stripe Trigger" node. This will provide you with a webhook URL.
   • Go to your Stripe Dashboard > Developers > Webhooks and add a new endpoint.
   • Paste the webhook URL from n8n.
   • Select checkout.session.completed as the event to listen for.
4. Configure Google Sheets:
   • In the "Google Sheets" node that logs sales, specify the Spreadsheet ID and Sheet Name where you want to record new sales.
   • In the "Google Sheets" node that retrieves product information, specify the Spreadsheet ID and Sheet Name where your product details (e.g., product name, download link) are stored.
5. Configure Microsoft Outlook:
   • In the "Microsoft Outlook" node, configure the recipient email (using data from the Stripe trigger, e.g., {{ $json.data.object.customer_details.email }}).
   • Compose the email subject and body, including dynamic data from previous nodes to provide the product download link or access instructions. The "HTML" node can be used to format the email content.
6. Review and Activate:
   • Examine the "Edit Fields (Set)", "Remove Duplicates", "Switch", "Execute Sub-workflow", and "HTTP Request" nodes to understand their current configuration and adjust them if needed for your specific use case. The "Sticky Note" nodes provide context within the workflow.
   • Once configured, activate the workflow to start automating your digital product sales and delivery.