Automated Product Ad Image Creation with AI and Google Workspace

This n8n workflow automates the creation of product advertisement images by leveraging AI (OpenAI) to generate image prompts and then using a hypothetical image generation service (via HTTP Request) to create the images. The process is triggered on a schedule, reads product data from Google Sheets, and stores the generated images in Google Drive.

Description

This workflow streamlines the marketing process for products by automating the generation of unique and engaging ad images. It eliminates manual effort in crafting image prompts and managing image assets, allowing businesses to scale their advertising efforts efficiently.

What it does

1. Triggers on a Schedule: The workflow starts at predefined intervals (e.g., daily, weekly) to check for new product data.
2. Reads Product Data from Google Sheets: It connects to a specified Google Sheet to fetch product information, such as product names, descriptions, and any other relevant details for ad creation.
3. Generates Image Prompts with OpenAI: For each product, it uses OpenAI to generate creative and compelling image prompts based on the product data. This step ensures unique and contextually relevant image ideas.
4. Creates Ad Images (via HTTP Request): It sends the generated image prompts to an external image generation service (simulated by an HTTP Request node). This service is expected to return the generated image data.
5. Converts Image Data: The raw image data received from the image generation service is converted into a file format.
6. Stores Images in Google Drive: The generated image files are then uploaded and stored in a designated folder within Google Drive for easy access and management.
7. Extracts File Information: After storing, the workflow extracts relevant information about the newly created file in Google Drive.
8. Processes File Data (Code Node): A Code node is used to perform any custom processing or manipulation of the file data, such as renaming, adding metadata, or preparing it for further use.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running n8n instance.
• Google Sheets Account: With access to the spreadsheet containing your product data.
• Google Drive Account: For storing the generated ad images.
• OpenAI API Key: For the OpenAI node to generate image prompts.
• Image Generation Service: An external API endpoint for an image generation service that accepts prompts and returns image data (configured in the HTTP Request node). This workflow currently uses a placeholder HTTP Request. You will need to replace this with your actual image generation service.

Setup/Usage

1. Import the Workflow: Download the provided JSON and import it into your n8n instance.
2. Configure Credentials:
   • Set up your Google Sheets credential to access your product data spreadsheet.
   • Set up your Google Drive credential to store the generated images.
   • Configure your OpenAI credential with your API key.
3. Customize Google Sheets Node (Node ID 18):
   • Specify the Spreadsheet ID and Sheet Name where your product data is located.
   • Ensure the "Read All Rows" operation is configured correctly to fetch all necessary product details.
4. Customize OpenAI Node (Node ID 1250):
   • Adjust the prompt for image generation to best suit your product data and desired ad image style. You might want to reference specific fields from your Google Sheets data (e.g., {{ $json.productName }}).
5. Configure HTTP Request Node (Node ID 19):
   • Crucially, replace the placeholder HTTP Request with your actual image generation service.
   • Set the URL to your image generation API endpoint.
   • Configure the Method (e.g., POST) and Headers (e.g., API key, Content-Type) as required by your image generation service.
   • Map the Body to send the image prompt generated by the OpenAI node.
   • Ensure the response type is correctly handled (e.g., binary data).
6. Customize Convert to File Node (Node ID 1234):
   • Ensure the "File Format" matches the expected output of your image generation service (e.g., Image (PNG)).
7. Customize Google Drive Node (Node ID 58):
   • Specify the Folder ID in Google Drive where you want to save the generated images.
   • Configure the "File Name" to be dynamic, perhaps using product names or a timestamp to ensure uniqueness.
8. Customize Code Node (Node ID 834):
   • Modify the JavaScript code within this node to perform any specific data manipulation or formatting needed for your workflow.
9. Set Schedule Trigger (Node ID 839):
   • Adjust the schedule to your desired frequency (e.g., every day, once a week).
10. Activate the Workflow: Once configured, activate the workflow to start automating your product ad image creation.