Case Study

Photo Size Calculator Automation

AI Workflow2025

Project Overview

The assignment and delivery scope.

Built an automation flow that accepts a Google Drive folder link, validates access, lists all JPG and PNG files, downloads each image to measure dimensions, converts width and height to centimeters at 300 DPI, then appends or updates rows in Google Sheets — with a simple UI to paste a folder link and open the finished sheet.

Role: Automation Workflow Designer

Deliverables: Drive folder intake form, n8n automation workflow, Google Sheets upsert output

Tools: n8n, Google Drive, Google Sheets, JavaScript

Overview

What this project had to achieve.

  • Validated Drive folder links before processing
  • Batch-calculated photo dimensions in cm (300 DPI)
  • Upserted results to Sheets with completion UI

Input

Drive folder link

Output

Google Sheet rows

Calc

Width × height (cm)