Here is a sheet with two rows. Each row fills the text layers of one Bannerbear template.
title
subtitle
cta_label
Summer Sale
20% off all headphones
Shop now
Weekend Deal
Free shipping over $50
Order today
These are real Bannerbear renders (1080 x 1080 PNG), one for each row. We made them with one API batch request from a Bannerbear template, not through a live Zapier or Make run. They show the output that each method gives for the same row.
How to Connect Google Sheets to Bannerbear
You connect the two with a tool that sends each row to Bannerbear: Zapier, Make, or a Bannerbear workflow that you give a link to a spreadsheet file. Pick the method that fits how you work.
Method 1: Zapier, new row to image
Use a Google Sheets trigger for new rows in Zapier, and the Bannerbear action that creates an image.
Connect Bannerbear to Zapier with your workspace API key. The help center has the steps.
Add a Google Sheets trigger for new rows.
Add the Bannerbear action. Choose your template.
Map each template layer to a column of your sheet.
Test the Zap. A new row now makes a new image.
Zapier also lists a ready-made Zap, "Create Bannerbear Images from new Rows in Google Sheets".
Method 3: a workflow that reads a spreadsheet link
A Bannerbear workflow can have a "Render Spreadsheet" step. The step takes a template and the link to a spreadsheet file, and renders one image for each row. Our public workflow "Print Certificates and Wallet Cards from a Spreadsheet" uses this step with a CSV file.
Install the workflow in your Bannerbear workspace. The install also copies its templates.
Put your data in a spreadsheet and give the file a link.
Run the workflow with that link. You can start it from your code, or from a tool such as Zapier.
The link must work for people who are not signed in to your account. Export or publish your sheet as a file with a public link first. The docs only show this with a CSV file, and we did not test other formats.
Use Zapier or Make when a new row should make an image at once, and you want to send the image on to other apps. Use a workflow when you have a finished list and want all images, or a print file, in one run.
Automating property tour videos gets you from raw listing data to polished, ready-to-post media in moments instead of hours. Here's how to use Airtable, Bannerbear, and Zapier to simplify your workflow.
Stop spending hours designing real estate listing materials manually. Automate it with three nocode tools, so all you have to do is hit one button! Learn how in this guide.
A single checkbox and a simple behind-the-scenes automation can transform your video marketing processes by putting Youtube thumbnails and other template-friendly assets at your fingertips. Here's how to set it all up.
API
Zapier
Airtable
Forms
URLs
Google Sheets
