Upscale and watermark real estate photos with Google Drive, Gemini, and Sheets
Ready for 3.0What this workflow does
This workflow has 12 nodes and runs on Google Drive events (file created). Along the way it connects Google Drive and Google Sheets. It also calls generativelanguage.googleapis.com and i.ibb.co over HTTP.
How it runs
Trigger: On Google Drive events (file created).
- Read Row in Sheets (Google Sheets): uses Google Sheets
- If: checks a condition and branches into true / false
- Download Image File (Google Drive): download
- Extract File Metadata (Extract from File): extracts data from a file (binary to propery)
- Post to Gemini API (HTTP Request): calls generativelanguage.googleapis.com (POST)
- Convert Response to File (Convert to File): converts data to a file (to binary)
- Fetch Watermark Logo (HTTP Request): calls i.ibb.co
- Calculate Watermark Position (Code): runs custom JavaScript code
- Apply Watermark to Image (Edit Image): composite
- Upload Watermarked Image (Google Drive): uses Google Drive
…plus 1 more step. See the full node list below.
Services it uses
HTTP calls to: generativelanguage.googleapis.com, i.ibb.co
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (9)
- Google Drive Trigger
n8n-nodes-base.googleDriveTrigger - Google Drive
n8n-nodes-base.googleDrive - Edit Image
n8n-nodes-base.editImage - Extract from File
n8n-nodes-base.extractFromFile - HTTP Request
n8n-nodes-base.httpRequest - Convert to File
n8n-nodes-base.convertToFile - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if
From the author
Quick overview Youtube Explanation: https://youtu.be/tDiR50VJslY This workflow watches a Google Drive folder for new property photos, checks Google Sheets to avoid reprocessing, upscales the image using the Google Gemini API, applies a logo watermark, then…