Black Friday: 20% off with BLACKFRIDAY2026 See plans

Generate sale and discount banners from a pricing sheet

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.

50 free credits. No credit card required.

  1. When

    Google Sheets

    New row

  2. Templated

    Render PNG

    Feed or story banner

  3. Then

    Google Drive

    Save and link back

At a glance

During a sale the prices change faster than anyone can redesign the banners. The numbers already live in a spreadsheet, so let the spreadsheet drive the design.

Each row you add (product, photo, old price, new price, end date) becomes a banner on your template. The file lands in a Drive folder and its link goes back into the row, so the team sees which banners are ready.

Trigger
Google Sheets: New row
Output
PNG, Feed or story banner
Delivered to
Google Drive: Save and link back
Run it with
Make, Zapier, n8n, Spreadsheet generation, REST API
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. 1

    Add a row to the sheet

    Product name, photo URL, old price, sale price and when the offer ends.

  2. 2

    Templated renders the banner

    Prices, the discount and the end date go into your template. The old price can sit on a strikethrough layer.

  3. 3

    Saved and linked

    The PNG goes to Google Drive and the render URL is written back to the same row.

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 layerComes fromExample
product-imagePhoto URL columnhttps://.../sneaker.jpg
old-priceOld price column$120
new-priceSale price column$84
discountDiscount column-30%
endsEnds columnEnds Sunday

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 .

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.

When to use it

  • Black Friday, seasonal sales or weekly deals where prices change often.
  • Merchandising plans prices in a sheet and marketing needs the banners.
  • You want the same offer in several sizes without redoing each one.

Tips

  • Compute the discount in the sheet (=1-C2/B2, formatted as a percentage) so the banner never shows a wrong number.
  • Need feed and story sizes? Add a second Templated step with your story template on the same row.
  • Launching the whole sale at once? Upload the sheet to Spreadsheet generation and render every banner in one batch.

How to run it

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

Make

No-code scenario

  1. Add Google Sheets › Watch New Rows on your pricing sheet.
  2. Add Templated › Create a Render and map the columns to your layers.
  3. Add an HTTP › Get a file with the render URL, then Google Drive › Upload a File.
  4. Finish with Google Sheets › Update a Row to write the render URL into a "Banner" column.
More about Make

Zapier

No-code Zap

  1. Trigger on Google Sheets › New Spreadsheet Row.
  2. Add Templated › Create Render and map the columns.
  3. Add Google Drive › Upload File with the render URL as the file.
  4. Add Google Sheets › Update Spreadsheet Row with the render URL.
More about Zapier

n8n

Cloud or self-hosted

  1. Start with a Google Sheets Trigger on Row Added.
  2. Add the Templated node (Create a Render).
  3. Download the image with HTTP Request (response as file) and upload it with the Google Drive node.
  4. Write the URL back with Google Sheets › Update Row.
More about n8n

Spreadsheet generation

In the dashboard, no code

  1. Download the sheet as CSV or Excel.
  2. Upload it in Spreadsheet generation, map the columns and render every banner in one batch.
More about Spreadsheet generation

REST API

From your own code

  1. Call POST /v1/render once per product with the layers below.
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://example.com/sneaker.jpg"
    },
    "old-price": {
      "text": "$120"
    },
    "new-price": {
      "text": "$84"
    },
    "discount": {
      "text": "-30%"
    },
    "ends": {
      "text": "Ends Sunday"
    }
  }
}'
API documentation

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.