Turn raw product shots into polished photos without leaving your spreadsheet. A list of image links in Google Sheets becomes finished assets in Google Drive, with prompts and results recorded for tracking. Great for ecommerce teams that need consistent product visuals fast.

Once you start the run, the flow reads image URLs from a sheet, downloads each file, and asks an AI model to describe the image in under five words. That short description then powers a prompt builder that crafts a clear product photography prompt. The original image and the new prompt are paired by position and sent to an AI image edit model to create the enhanced photo. The file is returned as base64, converted to a real file, uploaded into a Drive folder, and the web link plus the exact prompt are written back to the same row for full traceability. A simple image generation path is also included for quick tests.

You will need Google Sheets, Google Drive, and an OpenAI API key. Set the sheet ID, the tab, and the Drive folder ID, then adjust the prompt text to match your brand style. Expect faster asset production, clean records for audit, and helpful file names based on the short description, which makes search easier. Ideal for catalogs, marketplace listings, ad creatives, and social content where speed and consistency matter.

• Manual start for controlled runs and easy testing
• Reads image URLs from a selected Google Sheets tab
• Downloads source images from each URL for processing
• Creates a short AI description to guide the photo style
• Builds a focused product photography prompt from the description
• Merges the prompt and original image by position for accuracy
• Sends both to an OpenAI image edit model to enhance the photo
• Converts base64 output into a downloadable file
• Uploads the finished image to a chosen Google Drive folder with a descriptive name
• Writes the Drive link, the used prompt, and the original URL back to the sheet

• Reduce manual image prep from 2 hours to 10 minutes per batch
• Automate 90% of repetitive editing and upload steps
• Connect Google Sheets, OpenAI, and Google Drive in one flow
• Track every output with a saved prompt and a web link
• Handle hundreds of product images in a single run
• Improve naming consistency with AI based descriptions

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Google Sheets, Google Drive and OpenAI. See the Tools Required section above for links to create accounts with these services.
3. In the n8n credentials manager, create an OpenAI credential. Get an API key from your OpenAI dashboard and paste it into the API key field. Name the credential clearly, for example OpenAI Product Photos.
4. For Google Sheets and Google Drive, double click each related node, choose the credential dropdown, click Create new credential, and follow the on screen steps to grant access. Use the same Google account that owns the sheet and the target Drive folder.
5. Open the Google Sheets read node and select the correct spreadsheet and tab. Confirm the sheet has a column for the image URL and that it contains public or accessible links.
6. Open the HTTP Request node that downloads images and map the URL field to the image URL column from the sheet. Make sure the request returns a valid image file.
7. Check the AI analysis node and confirm it receives the image data and produces a short description. Keep the description brief so the later prompt stays focused.
8. Review the prompt builder node and tailor the wording to your brand style. Keep product details, lighting, background, and camera angle clear and concise.
9. Open the image edit request node and confirm the model field is set correctly. If you see errors, try smaller image sizes or fewer simultaneous items.
10. In the Drive upload node, choose the target folder ID. The file name uses the short description so you can search later by product type.
11. Open the sheet update node and map three fields: the new Drive web link, the prompt text, and the original image URL. Point the update to the same tab used for the read step.
12. Click Test workflow to run a small batch. Confirm new files appear in the Drive folder and that the sheet shows the web link and the exact prompt for each row.
13. If items mismatch, check the merge node that combines the prompt with the image. It pairs by position, so both branches must keep the same item order. Fix any rows with broken links or blocked images and run again.