Automated image processing for e-commerce product catalog
Use cases
- Monitor a Google Drive folder, process each image based on the prompt defined in
Workflow Configuration
and save the new image to the specified output Google Drive folder.
- Maintain a processing log in Google Sheets.
👍 This use case can be extended to any scenario requiring batch image processing, for example, unifying the look and feel of team photos on a company website.
How it works
- Trigger: Watches a Google Drive folder for new or updated files.
- Downloads the image, processes it using Google Gemini (Nano Banana), and uploads the new image to the specified output folder.
How to use
- Google Drive and Google Sheets nodes:
- Create Google credentials with access to Google Drive and Google Sheets. Read more about Google Credentials.
- Update all Google Drive and Google Sheets nodes (6 nodes total) to use these credentials
- Gemini AI node:
- Create a Google Sheets spreadsheet following the steps in
Google Sheets Configuration
(see right ➡️). Ensure the spreadsheet can be accessed as Editor
by the account used for the Google Credentials.
- Create input and output directories in Google Drive. Ensure these directories are accessible by the account used for the credentials.
- Update the
File Created
, File Updated
and Workflow Configuration
node following the steps in the green Notes (see right ➡️).
Requirements
- Google account with Google API access
- Google AI Studio account with ability to create a Google Gemini API key.
- Basic n8n knowledge: understanding of triggers, expressions, and credential management
Who’s it for
Anyone wanting to batch process images for product catalog.
Other use cases are applicable. Please reach out reach out if you need help customizing this workflow.
🔒 Security
All credentials are stored securely using n8n's credential system.
The only potentially sensitive information stored in the workflow is the Google Drive folder and Sheet IDs. These should be secured according to your organization’s needs.
Need Help?
Reach out on LinkedIn or Ask in the Forum!