How Churches Can Use Canva Bulk Create for Sermon Series, Volunteer Spotlights, and Event Graphics
Draft — Post #23 · Target keyword: canva bulk create church · Meta: Build sermon slides, volunteer spotlights, staff cards, and event graphics from one spreadsheet. The Canva Bulk Create church workfl
Draft — Post #23 · Target keyword: canva bulk create church · Meta: Build sermon slides, volunteer spotlights, staff cards, and event graphics from one spreadsheet. The Canva Bulk Create church workflow that handles image URLs.
It's Wednesday night. Sunday needs a sermon series slide, six volunteer spotlight graphics for the new serve team, a welcome card for every small group leader, and social posts for the three events on the calendar. You are one person, or one very tired comms volunteer, and every graphic is the same layout with a different name, photo, and title.
This is exactly what Canva Bulk Create is built for. You make one template, feed it a spreadsheet, and Canva spins out a finished design for every row. Then you try it with your volunteer headshots and group leader photos, and Canva ignores every image. The names merge fine. The photos come back blank.
This post walks through the full Canva Bulk Create church workflow, the one step Canva can't do on its own, and a weekly rhythm that fits how a ministry team actually works.
Why Canva Bulk Create Stalls for Churches
Church communication runs on people and recurring slots. Staff and elder photos. Volunteer and serve-team headshots. Small group leader portraits. Sermon series artwork. Event flyers that repeat every quarter. Most of those images already live somewhere as a link, whether that's Planning Center, a shared Google Drive, your church management system, or a folder of photos from the last serve day.
Canva Bulk Create handles all the text without a problem. Drop in a column of names, group titles, service times, or scripture references and Canva merges them cleanly into your template.
Image URLs are where it breaks. Canva's Bulk Create only accepts images that are physically embedded inside the XLSX file as binary data in a format called DrawingML. A URL is just text as far as Canva is concerned. It either prints the raw link inside your design or leaves the photo slot empty. We covered the full technical reason in Why Canva Bulk Create Ignores Image URLs.
For a church team this is the gap between a 15-minute job and a lost evening. A serve team of 40 volunteers with photo links will not render unless those photos are embedded inside the XLSX before you upload it to Canva.
Worth noting up front: plenty of church graphics are text only. A scripture-of-the-week slide, a giving reminder, an announcement card with no photo. Those need no image conversion at all. Bulk Create handles them as-is. The conversion step only matters when your designs include photos or logos.
The Manual Workaround Most Church Teams Try First
The usual hack: open the spreadsheet in Excel, click each image cell, use Insert > Picture > Place in Cell, find the photo on your computer, repeat for every volunteer. It works if every photo is already downloaded, cropped, named to match, and sitting in one folder. For a 40-person serve team that's 40 manual inserts, and you redo it every time the team changes.
In real life the photos are scattered. Some came from Planning Center, some from a group chat, a few from people who emailed them in last week. By the time you've collected, renamed, and hand-placed them all, the night is gone.
The other common attempt is the =IMAGE() formula in Google Sheets. We covered why that fails for Bulk Create in Why =IMAGE() Doesn't Work for Canva Bulk Create. Short version: =IMAGE() is a live cell reference, not embedded image data. Canva reads the file and sees nothing in those cells.
What You Need Before You Start
Two things.
A Canva template per graphic type. Most church teams cycle through a handful of recurring designs. The common ones look like this. A sermon series slide with the series title, current week, and scripture reference. A volunteer or staff spotlight with headshot, name, role, and a short line of thanks. A small group leader card with portrait, group name, and meeting time. An event graphic with a photo, date, and location. A weekly social post with a photo and a single line of text.
Each template needs Canva Bulk Create placeholders for the text fields like {{name}}, {{role}}, {{group_name}}, {{service_time}}, plus an image element where the photo or logo goes.
One source-of-truth spreadsheet per batch. One row per output design. A column for each text field, and one column holding the direct image URL.
If you already keep volunteer or group data in Planning Center, a Google Sheet, Airtable, or your church management system, you're most of the way there. The only column you may need to add is a direct link to each photo. We've written about clean spreadsheet prep for verticals like event planners and Etsy sellers, and the same rules apply: one row per output, one column per field, image URLs in their own column.
Step 1: Collect the Image URLs
This is the step that eats the most time, because church photos come from everywhere.
Google Drive or a shared ministry Drive: convert the share link to a direct image URL using the format https://drive.google.com/uc?id=FILEID&export=download, or drop the photos into a public folder.
Planning Center or your ChMS: most systems show a profile photo you can open and copy the image address from. Right-click the photo and copy image address; the URL should end in .jpg or .png.
Dropbox: take the share link and change the trailing ?dl=0 to ?raw=1 to get the raw image.
Photos emailed or texted in: save them to one folder, upload to your Drive or church website, and use those links.
Drop every URL into your spreadsheet under one column. Name it photo or image_url and stick with the convention.
Step 2: Build the Spreadsheet
A typical volunteer spotlight batch looks like this.
| name | role | team | service_time | photo |
| Grace Okafor | Greeter | First Impressions | 9:00 AM | https://drive.google.com/uc?id=ABC123&export=download |
| Daniel Reyes | Kids Leader | Sunday Kids | 11:00 AM | https://drive.google.com/uc?id=DEF456&export=download |
| Priya Nair | Worship Vocals | Worship Team | 9:00 AM | https://drive.google.com/uc?id=GHI789&export=download |
Save it as CSV or XLSX. Column names don't have to match Canva exactly because you map them in the Bulk Create panel, but matching names lets Canva auto-connect them in one click.
Step 3: Convert the Spreadsheet With Postprep
This is the step Canva refuses to do.
Go to postprep.app, upload your CSV, and pick the column that holds the image URLs. Postprep fetches each URL, downloads the photo, and embeds it inside the XLSX as DrawingML, the binary format Canva actually reads. Every other column passes through unchanged.
A 40-row sheet takes well under a minute. The free tier covers 100 rows with no account required, which is enough for most serve teams, group leader rosters, and event batches.
Step 4: Bulk Generate in Canva
Open your template in Canva. You'll need a plan that supports Bulk Create. Canva offers nonprofit eligibility through Canva for Nonprofits, which many churches qualify for, but confirm your church's specific eligibility and current plan features on Canva's site rather than taking that as a guarantee.
In the left panel click Apps, then Bulk Create. Click Upload data and choose your converted XLSX. Drag each column onto its matching placeholder, or use Auto-connect if your column names already match. Click Generate designs. Canva produces one finished graphic per row with the photos, names, and roles already merged.
Running three template types off the same roster? Take the same XLSX into each template and run Bulk Create three times. Same data, three sets of branded graphics. Download as a ZIP and you're done.
A Realistic Weekly Church Workflow
Here's how the rhythm fits a ministry team.
Monday: pull the week's needs into one master sheet. New volunteers to spotlight, group leaders to welcome, events to promote. Add photo URLs in one column.
Tuesday: run the sheet through Postprep once. Generate volunteer spotlights, leader cards, and event graphics in Canva from your saved templates. Schedule the social posts.
Sunday: the slides and graphics are ready. Next week, update the same sheet with new names and re-run. The whole cycle is about 20 minutes of spreadsheet work and 15 minutes in Canva, whether you're spotlighting 5 volunteers or 50.
Without the converted XLSX, that same batch is hours of hand-placing photos every single week.
Frequently Asked Questions
Does my church need a paid Canva plan for Bulk Create?
Bulk Create is a paid feature. Many churches qualify for Canva for Nonprofits, which can include it, but eligibility and feature details change, so verify your church's status directly with Canva before planning around it.
Some of our volunteers haven't sent photos yet. What happens?
Leave the photo cell blank for those rows. Postprep skips the image for empty cells and Canva leaves the placeholder visible. Re-run the batch once the photos come in.
Our graphics don't always have photos. Do we still need to convert?
No. Text-only graphics like scripture slides or giving reminders work in Bulk Create as-is. The conversion step only matters when a design includes photos or logos.
Can I use this for both screen slides and printed bulletins?
Yes. Canva exports the same generated designs to PNG for screens or PDF for print. Run Bulk Create once and download both. Embedded photos hold up at print size as long as the source images are high enough resolution.
Our photos live in Planning Center. Can I pull them straight in?
You can copy the image address from each profile photo and drop it into your sheet. If your photos aren't publicly accessible by link, download them to a shared Drive folder first and use those URLs.
Will this work for a large multi-campus church?
Yes. One row per output design. Add a campus column for the text and keep one photo URL per row. Filter or sort the sheet by campus if you want to generate each location's graphics separately.
The Short Version
Canva Bulk Create handles the merge work for every sermon slide, volunteer spotlight, leader card, and event graphic your church ships. The one thing it can't do is turn image URLs into embedded photos inside the XLSX. Postprep is that missing step.
Build one sheet per batch. Convert with Postprep. Bulk generate in Canva. Every volunteer, leader, and event gets its graphic without another late Wednesday night.
Try it free at postprep.app — 100 rows, no account required.