# Turn a product CSV into marketing images for your whole catalog

> Upload your Shopify or WooCommerce product export and get one branded image per product: photo, name and price on your template, downloaded as a ZIP. No code.

- **URL**: https://templated.io/workflows/product-images-from-csv/

---

Export your products, upload the file, map the columns once and download an on-brand image for every product in the catalog.

[Start free](https://app.templated.io/signup) · [See the setup](https://templated.io/workflows/product-images-from-csv/#how-to-run)

50 free credits. No credit card required.

1. When

   CSV or Excel file

   Product export

2. Templated

   Render PNG or JPG

   One image per row

3. Then

   ZIP download

   Download all as ZIP

## At a glance

A seasonal refresh, a new brand look, a marketplace that wants square images with your logo: sometimes you need an image for every product, today. Doing it by hand means hundreds of exports.

Every store can export its products to a spreadsheet. Upload that file to Templated, tell it which column holds the photo, the name and the price, and it renders one image per row. You check a preview before anything renders and download the whole set as a ZIP.

- Trigger

  CSV or Excel file: Product export

- Output

  PNG or JPG, One image per row

- Delivered to

  ZIP download: Download all as ZIP

- Run it with

  Spreadsheet generation, REST API, AI agent (MCP)

- Cost

  1 credit per image (each page of a multi-page template counts as one)

- Free plan

  50 credits, no credit card required

## How it works

Three steps, from the event to the finished file.

1. ### Export your products

   Download the product CSV from Shopify, WooCommerce or any platform, or keep a Google Sheet and save it as CSV or Excel.

2. ### Upload and map the columns

   In **Spreadsheet generation**, pick your template, upload the file and match each column to a layer. Preview a few rows.

3. ### Render and download

   Templated renders every row and gives you a ZIP with one image per product.

## Map your data to the template

Each dynamic layer in your template gets its value from one field. Name your layers like this, or map whatever names you use.

| Template layer | Comes from | Example |
| - | - | - |
| product-image | Image Src column | https\://cdn.shopify.com/.../tee.jpg |
| product-name | Title column | Organic Cotton Tee |
| price | Variant Price column | $32 |
| badge | A column you add | Bestseller |

Text layers take `text`, image layers take `image_url`. You can also change colors, hide layers or swap fonts per render. [See every layer property](https://templated.io/docs/renders/create/).

## Templates for this workflow

Start from one of these and make it yours in the editor, import a Canva design, or describe one to the AI template generator.

- ![Sale E-commerce with Photo Template preview](https://templated-assets.s3.amazonaws.com/public/thumbnail/08125b7e-723c-4f25-b443-5e78a60a717f.webp)

  ### [Sale E-commerce with Photo Template](https://templated.io/templates/e-commerce-marketing/sale-e-commerce-with-photo-template/)

- ![Sale E-commerce Template preview](https://templated-assets.s3.amazonaws.com/public/thumbnail/fe7def69-0a3a-4d1b-91c1-703ac0294448.webp)

  ### [Sale E-commerce Template](https://templated.io/templates/e-commerce-marketing/sale-e-commerce-template/)

- ![Social Media Modern Instagram preview](https://templated-assets.s3.amazonaws.com/public/thumbnail/cc115cac-0ac6-4238-b087-da5a975b8c40.webp)

  ### [Social Media Modern Instagram](https://templated.io/templates/social-media/social-media-modern-instagram/)

[Browse all templates](https://templated.io/templates/) · [Generate one with AI](https://templated.io/ai-template-generator/)

## When to use it

- You need images for the whole catalog at once: a rebrand, a seasonal campaign, a new marketplace.
- You want a one-off batch without setting up a Zap or a scenario.
- Someone on the team who never touches automation tools needs to make the images.

## Tips

- Shopify exports one row per variant and per extra image. Keep only the rows where **Title** is filled, which is the first row of each product.
- Add your own columns before uploading, like a badge ("New", "-20%") or a background color, and map them to layers too.
- Image columns must hold public URLs. Shopify and WooCommerce exports already do.
- For new products after the batch, switch to the [Shopify workflow](https://templated.io/workflows/shopify-new-products-to-instagram/) so they are made one by one as they arrive.

## How to run it

Pick the tool you already use. The first one is the quickest way to set this up.

### Spreadsheet generation

In the dashboard, no code

1. Export your products as CSV (in Shopify: **Products › Export**).
2. In the Templated dashboard, open **Spreadsheet generation** and choose your template.
3. Upload the CSV or Excel file and map each column to a layer.
4. Preview a few rows, render the batch and download the ZIP.

[More about Spreadsheet generation](https://templated.io/integrations/spreadsheet/)

### REST API

From your own code

1. Read the export in your script, one product per row.
2. Call `POST /v1/render` for each row (a few in parallel is fine) with the layers below.
3. Save each returned `url` next to the product ID.

cURL

```
curl -X POST https://api.templated.io/v1/render \
  -H "Authorization: Bearer $TEMPLATED_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{
  "template": "YOUR_TEMPLATE_ID",
  "format": "png",
  "layers": {
    "product-image": {
      "image_url": "https://cdn.shopify.com/s/files/tee.jpg"
    },
    "product-name": {
      "text": "Organic Cotton Tee"
    },
    "price": {
      "text": "$32"
    },
    "badge": {
      "text": "Bestseller"
    }
  }
}'
```

[API documentation](https://templated.io/docs/)

### AI agent (MCP)

Claude, ChatGPT, Cursor

1. Connect Templated to Claude, ChatGPT or Cursor through the [MCP server](https://templated.io/docs/integrations/mcp/setup/).
2. Attach or paste the product list and ask for the images with the prompt below.
3. The agent renders one image per product and returns the links.

> “Use Templated to make a product image for each row of this list with my "Product card" template: photo in product-image, name in product-name, price in price. Show me the first one before doing the rest.”

[More about AI agent (MCP)](https://templated.io/integrations/mcp/)

## Step-by-step guides

- [Automate Your Image Generation using Spreadsheets (No code needed)](https://templated.io/blog/automate-your-image-generation-using-spreadsheets/)

## Related workflows

- ### [Turn a product spreadsheet into a print-ready PDF catalog](https://templated.io/workflows/product-catalog-pdf-from-spreadsheet/)

  One upload turns hundreds of products into a paginated catalog: product grid filled, a section per category, cover and back cover merged into one PDF.

  Catalog generation

- ### [Make catalog ad images for every product in your feed](https://templated.io/workflows/product-feed-ad-creatives/)

  Give dynamic product ads a branded frame: one creative per product, with price and offer, written straight into the feed your catalog uses.

  Make, Zapier, n8n, REST API

- ### [Generate sale and discount banners from a pricing sheet](https://templated.io/workflows/sale-banners-from-google-sheets/)

  Your pricing sheet becomes the design brief: each new row turns into a sale banner with the old price, the new price and the discount.

  Make, Zapier, n8n, Spreadsheet generation, REST API

[See all workflows](https://templated.io/workflows/)

## Set up your first workflow today

Create a template, connect your tool and render your first image in minutes.

50 free credits. No credit card required.

[Start free](https://app.templated.io/signup)
