Create your own Spotify Wrapped

I created a poor-mans Spotify Wrapped for our SaaS, using Make and Bannerbear

It doesn't have the production value of Wrapped, but it showed customers how much value they were getting from Content Snare

Plus it was fun to set up and I finally had an excuse to play with Bannerbear. Each customer got a link to a page like this

Here's how

Step 1 - Customer report

Generate a report of your customers and the stats you want to show on the image.

Hopefully you can dump this as a csv from your analytics. Ours wasn't so easy because of a mistake in our analytics setup, so I needed a script.

Except I’ve never written a line of Python in my life. I used Replit and some AI prompts to export from Mixpanel and sum up each event into a CSV and run it all in the browser. It's insane that this is possible.

Step 2 - Image

Design a basic template in Canva and delete the dynamic parts of the image.

Upload that to Bannerbear and create a layer for each piece of dynamic text.

Step 3 - Produce images

Next create an scenario in Make to run over every row in the spreadsheet and generate the image. You may need 2 parts depending on your Bannerbear subscription.

Automation 1 - Go over every row and trigger Bannerbear to create an image. Bannerbear will send a webhook when it's complete.

In case you get throttled, you may need to add a couple of seconds sleep in here, or process in batches of ~20 (30 got me throttled)

Automation 2

Catch the webhook and put the image URL back into your sheet. Optionally, put that URL into a custom field in your CRM so you can email it to people.

Step 4 - Email everyone

Email your customers with the image inline in the email, based on the custom field from step 3.

Optional steps

I added an extra step where we created a page on our website that dynamically loaded an image based on a URL parameter. That way we could create share buttons & set the meta og:image to their image.