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

Описание и применение

Автоматический процесс масштабирования изображений товаров из Google‑Sheet с помощью n8n и 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.

Источник