From Friday Deep-Dive · Friday, October 30, 2026 · 7 min read
How I automated our Veterans Day salute ads
Readers fill out a form. A tool Claude built turns every submission into a finished ad in our design, flags the photos that won't print well and hands me print-ready PDFs. Here's the setup, the exact prompts, and other ads you can automate the same way.
Our Veterans Day salute ads are the same small box every time: a photo, a name, a rank, a branch, the years served. Only the details change. I used to spend about six hours building them.
This year I had Claude build a tool that lays them out for me. Readers fill out an online form. I download their answers and photos, load them into the tool, and it builds every ad in our design. I check each one, fix what needs fixing and download print-ready files. This year, we received nearly 50 submissions online.
Here's how it works, how to set one up at your paper, the prompts to use, and other jobs that work the same way. You don't need to know any code. If you can attach a file to an email, you can do this.
What the tool does
- It turns each form submission into a finished ad in our existing design and fonts, at the exact ad size (about 2.4 by 2.85 inches).
- When a veteran is being honored in memory, it adds "In Loving Memory" in script above the name.
- It cleans up what people type. "SFC" becomes "Sergeant First Class." "SP4" becomes "Specialist 4." "(Retired)" comes off the end of a name.
- I can drag and zoom each photo to fix the crop, and change any line of text.
- It flags problems before they get to print. More on that below.
- It downloads every approved ad as a PDF at the exact ad size, plus a picture file.
The checks are the best part
Every ad gets a status of Ready, Review or Blocked, and the top of the screen keeps a running count. Here's what it catches:
- Photos too small to print sharp. Under about 170 pixels per inch at print size, the ad is blocked because it will look soft in newsprint. Between 170 and 250 it gets a warning.
- Two people in one submission, when someone types a name like "John and Mary."
- A rank given only as a pay grade, like E-5, with no title.
- Years written in a way that won't fit the "Served 1970-1974" line.
- No years and no era, which would leave that line empty.
- Text so long it had to shrink to fit the box.
- A submission with no matching photo.
When Claude first went through our photos, it left a note on each problem one. A picture of a framed picture. A selfie with a decorative border. One that came in sideways. One so small the face was about 40 pixels wide, with a note to ask the family for a better photo. And one submission wasn't a portrait at all. It was an illustration of a bedroom.
If the tool blocks an ad and I decide it's fine anyway, there's an "Accept as is and approve" button. It's my call, not the tool's.
How to set it up
Step 1: Collect submissions with an online form
I used Tally (tally.so) on a free account. Any form tool works as long as people can upload a photo and you can download the answers as a spreadsheet.
Our form asks for:
- Full name as it should appear in print
- Rank
- Branch
- Years served, if known
- Era or conflict, if any
- Whether the veteran is living or being honored in memory
- Who it's in memory of
- Hometown or county
- A photo
If you'd rather have Claude write the questions, paste this into a new chat:
I run a weekly newspaper. Every November we print Veterans Day salute ads: one small ad per veteran with a photo, name, rank, branch, years served and era. Readers will send them to us through an online form. Write the list of questions the form needs, in plain words a reader will understand. Tell me which questions should be required. Include a photo upload and a question asking whether the veteran is living or being honored in memory.
Step 2: Give Claude your design and some real submissions
Start a new chat in Claude and attach:
- One finished ad in your design, as a PDF or a picture
- The spreadsheet of submissions you downloaded from your form (even if you only have a few so far)
- A handful of the photos people sent
- The names of the fonts your design uses. Ours uses Myriad Pro and Rage Italic. If you have the font files, attach those too.
Then paste this, with your ad size filled in:
I've attached our Veterans Day salute ad design, a spreadsheet of reader submissions from our online form, and some of the photos readers sent. Build me an artifact that turns each row of the spreadsheet into a finished ad in exactly this design. The ad is [width] by [height] inches. Put the photo in the photo window, then the name, rank, branch and years served under it, in the fonts from the design. When a veteran is being honored in memory, add "In Loving Memory" above the name. Let me drag and zoom each photo to fix the crop, edit any line of text, and mark each ad as reviewed. Then let me download every reviewed ad as a print-ready PDF at the exact ad size.
Claude builds the tool as an artifact (see "What is it?" below). It opens next to your chat and you can start using it right away.
Step 3: Test it with real submissions and ask for changes
Expect a few rounds of back and forth. Describe problems the way you'd tell a designer: "The name is too big." "Move the photo up a little." "The rank is wrapping onto two lines."
To add checks like ours, paste this:
Add checks that flag problems before an ad goes to print. Flag any photo too small to print sharp in newsprint, any ad with no years and no era, abbreviations like SFC or SP4 that should be spelled out, two people in one submission, text too long to fit, and any submission with no matching photo. Mark each ad Ready, Review or Blocked, and show me a count of each at the top.
And to have Claude look over the photos for you:
Look at every photo I've attached. Tell me which ones are too small to print well, sideways, cropped badly, not a portrait, or a photo of a framed picture, so I can ask those families for a better one. Set a good starting crop for each face.
Step 4: Make the ads
- On your form's results page, download the submissions as a spreadsheet (a CSV file).
- Save all the photos into one folder on your computer. Keep the file names the way they came. That's how the tool matches each photo to the right veteran.
- Open the tool. Load the spreadsheet, then the photos folder, then the fonts if you have them.
- Go through the ads one at a time. Fix the crop, check the spelling, and look hard at anything marked Review or Blocked.
- Tick "Mark as reviewed" on each ad you're happy with.
- Click "Download all approved." You get a zip file with a PDF and a picture of every approved ad. Place them on your pages like any other ad.
The tool remembers your crops and edits in that browser, so you can stop and pick up later. Use the same computer and browser when you come back. The spreadsheet and photos open right in your browser, and the tool doesn't upload them anywhere.
Before you start
Proof every ad yourself. A wrong rank or a misspelled name on a veteran's salute is the kind of mistake families remember. The checks catch formatting and photo problems. They can't tell you a name is spelled wrong.
Next year is where it really pays off. The tool is already built. You load the new spreadsheet and photos and go.
Other jobs that work the same way
The test is simple. If an ad or a page looks the same every time and only the details change, Claude can probably build a tool for it. A few to try:
- Graduation salutes: senior photo, name, school and a short message from the family.
- Birthday, anniversary and engagement announcements.
- Obituaries in your standard format: photo, name, dates and service details.
- Holiday greeting ads from local businesses: logo, message and address in a set layout.
- Athlete of the week: photo, name, sport, a stat line and the sponsor's name.
- Honor rolls: turn the school's spreadsheet into a clean, alphabetized list in your style.
- County fair and 4-H results.
- Church and service directories.
- Candidate questionnaires: the same questions, with every candidate's answers side by side.
- Real estate and help-wanted listing blocks.
Here's a prompt that works for any of them:
I want to automate [name of the ad or page] at my newspaper. Every one has the same layout: [describe what goes where, for example "photo on the left, name in bold, then the date and a short message"]. I've attached a finished example and a spreadsheet with the information for [this week / this year]. Build me an artifact that turns each row into a finished [ad / listing] in exactly this design. Let me fix anything before it's final, flag anything missing or too small to print, and download print-ready PDFs at [size].
Swap in your own details, attach your example and start with whichever job takes your staff the longest.
Try this and tell me what happened.
Did it work? Hit reply. Did it come back sounding like a stranger? Hit reply harder. That’s the interesting failure, and it’s almost always fixable.
Get the next one in your inbox
Tuesday brief + Friday deep-dive. Free. Unsubscribe anytime.
Subscribe — free, twice weekly← Back to I let Claude build our Veterans Day ads. Here's how to copy it.