Upscale and watermark real estate photos with Google Drive, Gemini, and Sheets

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 uploads the final image to a processed folder and logs the result back to Google Sheets. How it works Triggers every minute when a new file is created in a specific Google Drive folder. Looks up the file name in Google Sheets to see whether the image is already marked as processed. If no processed row exists, downloads the image from Google Drive and extracts its binary data. Sends the image to the Google Gemini (Generative Language) API to enhance and upscale it, then converts the returned base64 image into a binary file. Downloads a watermark logo from a public URL, calculates a bottom-right placement based on the image and logo dimensions, and composites the logo onto the upscaled image. Uploads the watermarked image to a target Google Drive folder and appends or updates a matching row in Google Sheets to mark it as processed. Setup Connect Google Drive OAuth2 credentials and set the source folder to watch and the destination