Bulk-upscale product photos from a Google Sheet with n8n and Real-ESRGAN

说明与用途

使用 n8n、Google Sheets 和 Real‑ESRGAN 的自动化图像放大流程，将结果存储在 Google Drive 并更新表格。

问题

Product images from suppliers are often only 400 px wide, but marketplaces and zoom features require 1,000 px or more, and manually upscaling hundreds of files is tedious.

结果

In a test run a 179×179 px JPG was upscaled to 716×716 px (92 kB) in about one second, and a broken link was recorded as failed. The process costs $0.015 per image, with free processing for failed images.

工作流

• Manual Trigger → Google Sheets: read "Images" → Filter: has image_url, no upscaled_url → Code: batch URLs (5 per batch) → HTTP Request: AI Image Upscaler → IF status = ok ├ yes → HTTP Request: download → Google Drive: upload → Set row → Google Sheets: update └ no → Set row (failed + reason) → Google Sheets: update

证据

If you have ever imported products from a supplier, you know the problem: half of the images are 400 pixels wide.

来源

In my test run a 179x179 px JPG came back as a 716x716 px file (92 kB) after about a second of processing, and a broken link was written back as failed, free of charge.

来源

$0.015 per upscaled image, $15 per 1,000. Failed images are free. 100 product photos = $1.50.

来源