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.
When
Google Sheets
New row

Templated
Render PNG
Feed or story banner
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
Add a row to the sheet
Product name, photo URL, old price, sale price and when the offer ends.
- 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
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 layer | Comes from | Example |
|---|---|---|
| product-image | Photo URL column | https://.../sneaker.jpg |
| old-price | Old price column | $120 |
| new-price | Sale price column | $84 |
| discount | Discount column | -30% |
| ends | Ends column | Ends 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
- Add Google Sheets › Watch New Rows on your pricing sheet.
- Add Templated › Create a Render and map the columns to your layers.
- Add an HTTP › Get a file with the render URL, then Google Drive › Upload a File.
- Finish with Google Sheets › Update a Row to write the render URL into a "Banner" column.
Zapier
No-code Zap
- Trigger on Google Sheets › New Spreadsheet Row.
- Add Templated › Create Render and map the columns.
- Add Google Drive › Upload File with the render URL as the file.
- Add Google Sheets › Update Spreadsheet Row with the render URL.
n8n
Cloud or self-hosted
- Start with a Google Sheets Trigger on Row Added.
- Add the Templated node (Create a Render).
- Download the image with HTTP Request (response as file) and upload it with the Google Drive node.
- Write the URL back with Google Sheets › Update Row.
Spreadsheet generation
In the dashboard, no code
- Download the sheet as CSV or Excel.
- Upload it in Spreadsheet generation, map the columns and render every banner in one batch.
REST API
From your own code
- Call
POST /v1/renderonce per product with the layers below.
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"
}
}
}'Step-by-step guides
Related workflows
Make catalog ad images for every product in your feed
Give dynamic product ads a branded frame: one creative per product, with price and offer, written straight into the feed your catalog uses.
Run with: Make, Zapier, n8n, REST API
Post every new Shopify product to Instagram automatically
Publish a product in Shopify and a branded post with its photo, name and price goes out on Instagram, no design work in between.
Run with: Make, Zapier, n8n, REST API n8n template
Turn a product CSV into marketing images for your whole catalog
Export your products, upload the file, map the columns once and download an on-brand image for every product in the catalog.
Run with: Spreadsheet generation, REST API, AI agent (MCP)
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.