Afterpay Campaign Generator

A custom Figma plugin that generates entire campaign asset libraries from a Google Spreadsheet and Drive folder — cutting production time and cost by more than half

Campaign production at scale is a volume problem. You have dozens of ad formats, multiple markets, rotating headlines, different merchant images — and someone has to manually populate every frame. It’s the kind of work that’s hard to scope, easy to underestimate, and almost entirely mechanical. For Afterpay, we built a Figma plugin that eliminates that mechanical layer entirely.

How it works

The system is built on a simple naming convention: the template name in the spreadsheet matches the frame name in Figma, and the column names match the layer names. That’s the whole contract. You set up your Figma frames with named layers — headline, image, merchant, terms and conditions — and your spreadsheet columns mirror those names exactly. Point the plugin at a spreadsheet URL and a Google Drive folder, hit go, and it rips through every row, finds the matching frame, replaces each layer with the corresponding content, and moves on. If a template doesn’t have a particular layer, it skips it gracefully. No crashes, no manual cleanup.

The piece that required more careful engineering was the connection between Google and Figma. Rather than asking users to manage API keys or authenticate manually each session, we built a cloud service with a dedicated Google IAM service account that acts as a trusted bridge between the two platforms. You share your spreadsheet and Drive folder with that service account — viewer access is enough — and the handshake is established. The plugin inherits those permissions during the design session, so images and data pull in securely without ever leaving the client’s own Drive environment. Both the client and the agency can work from the same spreadsheet and folder, which keeps everyone aligned on the source of truth.

The numbers

The first time we ran this against a real campaign, someone on the team pulled the comparison: scoping the same job without the tool would have cost $56,620 and taken 400 hours. With the tool, it came in at $20,615 and 150 hours. That’s $36,005 saved and 250 hours returned to the team — a 63.6% cost reduction on a single production run.

That’s not a marginal improvement. That’s a fundamentally different way to staff and scope a campaign.