# Generate sale and discount banners from a pricing sheet

> Add a product, its old and new price to a Google Sheet and get a finished sale banner in Drive, with the link written back to the sheet. Works with Make, Zapier and n8n.

- **URL**: 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.

[Start free](https://app.templated.io/signup) · [See the setup](https://templated.io/workflows/sale-banners-from-google-sheets/#how-to-run)

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. ### 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](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 Circle Banana Background Template preview](https://templated-assets.s3.amazonaws.com/public/thumbnail/e9e24531-0504-4a66-854b-455d1bdc5982.webp)

  ### [Sale Circle Banana Background Template](https://templated.io/templates/e-commerce-marketing/sale-circle-banana-background-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/)

[Browse all templates](https://templated.io/templates/) · [Generate one with AI](https://templated.io/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](https://templated.io/integrations/spreadsheet/) 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](https://templated.io/integrations/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](https://templated.io/integrations/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](https://templated.io/integrations/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](https://templated.io/integrations/spreadsheet/)

### 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](https://templated.io/docs/)

## Step-by-step guides

- [How to Automate Image Generation Using Google Sheets, Make.com & Templated](https://templated.io/blog/how-to-generate-images-from-google-sheets-with-make/)
- [How to Generate Images from Google Sheets with Zapier](https://templated.io/blog/how-to-generate-images-from-google-sheets-with-zapier/)

## Related workflows

- ### [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

- ### [Post every new Shopify product to Instagram automatically](https://templated.io/workflows/shopify-new-products-to-instagram/)

  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

- ### [Turn a product CSV into marketing images for your whole catalog](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.

  Spreadsheet generation, REST API, AI agent (MCP)

[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)
