← All Workflows

Generate sale and discount banners from a pricing sheet

Price-drop and promo graphics built straight from the numbers in your spreadsheet.

See all workflows
Trigger1On a scheduleRun automatically at a set frequency.
Source2Google SheetsRead rows from a spreadsheet.
Render3New Season Fashion Sale Instagram Ad with Discount BadgeExample template. Swap in your own design.
Destination4Google DriveSave renders to a Drive folder.

Every deal in your sheet becomes a ready banner

A sale is only worth running if the promo art is ready, and that art is usually the thing that holds it up. This workflow turns your pricing sheet into the banners. Keep each deal as a row with the product and its old and new price, and on a schedule Orshot renders a banner for every one and files it in Google Drive, ready to use.

What the sheet drives

Everything that changes per banner comes from the row, so the template stays fixed and the numbers stay right:

  • Product name placed in the same spot on every banner.
  • Old and new price dropped in with matching formatting, even when a name runs long.
  • The discount worked out from both prices, so the percentage off can show without you doing the math.

Click a row to see the banner it renders:

One row becomes one bannerClick a row
AProductBWasCNow
1Linen Field Shirt$68$48
2Trailhead Backpack$120$89
3Ceramic Pour-Over$34$24
Orshot renders
Banner
Linen Field Shirt
Was$68
Now$48
PNG

Rendered from row 1, one per row

Set the schedule

Pick how often the workflow runs, then leave it. Each run reads the current rows and renders a banner for every deal, saving each one to your Google Drive folder. When a new sale starts, you edit the sheet and the next run produces the fresh set, so the art is never the reason a promo waits.

How it works, step by step

  1. Design a banner template

    Build a sale banner in the studio with placeholders for the product, the old price, and the new price.

  2. List your deals in a Google Sheet

    Add one deal per row, with columns for the product and both prices. The template works out the discount from them.

  3. Set the schedule

    Choose how often the workflow runs. Each run reads your sheet and renders a banner for the current deals.

  4. Save to Google Drive

    Every finished banner lands in a Google Drive folder, ready to grab for your site, ads, or email.

Frequently asked

How do I generate sale banners from a spreadsheet?

Keep your deals as rows in a Google Sheet with the product and prices, then connect the sheet and Google Drive to this workflow. On the schedule you set, Orshot renders a banner from your template for each deal and saves it to Drive, so you never build one by hand.

Where do the finished banners go?

Each banner is saved to a Google Drive folder you choose. From there you can drop it onto your site, load it into an ad, or attach it to a campaign email.

Does it post the banners anywhere on its own?

No. This workflow renders and files the banners in Drive rather than publishing them, so you stay in control of where and when each one is used.

Can the banner show the discount amount?

Yes. Keep the old and new price in the sheet and the template can display both, or calculate the percentage off, so shoppers see the saving at a glance.

How do I run a new sale?

Update the rows in your sheet with the new products and prices. The next scheduled run renders banners for whatever the sheet holds, so a new sale is just an edit away.