adroll automation
Project Brief
A workflow automation to generate on-brand and editable digital ad assets. The workflow successfully generates and exports multiple sets of digital ads at multiple sizes, as well as editable Figma components to correct or adjust any errors in the generation process. Relying on a single workbook for input, the process is designed to be usable by anyone capable of using Microsoft Excel, keep the barrier of entry low while maintaining high quality output.
tools used
ChatGPT - Prompt engineering help, Codex help
Codex - Workflow development and execution
Figma - Source and asset libraries, generation target
Excel - Data set for asset content and design instruction
Skills Demonstrated
Layout
Prompt Engineering
Project Role(s)
Creative Director
Developer
the workflow
1
An Excel Workbook is populated with details on filenames, Figma URLS, export settings, and asset content (words, colors, images).
2
Codex is given a one-time initial prompt provided in the workbook; instructing Codex it’s intended purpose for the session*.
3
The completed workbook is submitted to Codex with a specifically written prompt to execute it’s contents.
*Step 2 can be skipped for all subsequent submissions within a session instance, which results in faster operation times
4
Editable assets grouped by page are built in Figma.
Each asset is also exported as an image on the local machine.
process and result samples
Sample of workbook content
Source asset wireframes
Sample asset library
Sample export group
recorded demo
Download the video below to see a guided, high-level walkthrough of the automation process and see the results in real-time.