Connect a Data Feed to Build Design Variations from a Spreadsheet

Feed connects a Bannersnack design to a spreadsheet, then builds one design variation per row: a different product, price, or headline in the same layout, without touching each size by hand. It's a new capability, now in beta, so expect some rough edges and changes as it develops.

Feed reads from two kinds of source:

To publish a Google Sheet as a feed URL: open the sheet, go to File > Share > Publish to web, choose Entire document, set the format to Comma-separated values (.csv), then click Publish and copy the link it gives you.

Each column in your Google Sheet or CSV becomes a data point you can map to a design element.

A typical setup includes columns like title, description, product image, button text, background color, accent color, and text color, but the columns are yours to define based on what you want to vary.

Bannersnack walks you through the elements on the canvas, e.g. button, description, title, logo, product image, and background. For each one, pick the column that should fill it. Text elements take a column for their content and, separately, a column or color choice for styling (for example, an accent color column driving your button color, or a text color column driving your description color).

Here's the full binding map (what each layer type accepts, property by property):

Italic values (like Justify alignment or linking to a Slide) aren't supported yet. Fields marked with an asterisk or a question mark in the underlying spec are still being finalized, so expect those to change before Feed leaves beta.

Once every element has a match, click Apply Feed. Bannersnack generates a variation for each row in your data and applies it to the design.

You're not locked in after applying: go back to any element in the left panel and change which column feeds it, then reapply.

After you apply a feed, a feed variation panel lets you step through the rows one at a time and preview how each one renders on the design, so you can catch a mismatched column or a layout problem before moving on.

The same feed doesn't stop at a single size. Connect it once inside a Design Set, and the variations carry across every size in that set, so a product feed that populates a medium rectangle populates the leaderboard and the mobile size the same way.

Note: At the moment, generating a Design Set from a Single design will break the feed connection.

From the Design Set, downloading gives you control over exactly what comes out: pick the sizes you need, pick which feed rows (all of them or a selection) to include, and choose your export format.

You can also open the design in a share link and send it to a client for approval. If the design is animated, they can play it directly from the link. If a feed is connected, they can move between variations and review all of them from that same link, without you exporting each one separately.

Feed is new and still in beta. Expect the workflow, available options, and supported column types to keep changing as it moves toward general availability.

👉 Sign up for a free Bannersnack account – it only takes a minute.
👉 Already have an account? Log in here to continue where you left off.