Learn

 / 

Jon Yongfook

 / 

How to automate your social media content using Airtable, BannerBear and Zapier

How to automate your social media content using Airtable, BannerBear and Zapier

ZapierJon Yongfook
Intermediates

Description:

Notes

Watching this Video will take Approximately: 

5m

Reading this lesson will take approximately: 

5m

The Original Source of this content may include additional useful information or context, and will likely contain links to any content, templates or resources mentioned by the narrator. You can find visit the source below:

View Original SourceView Original Source

Lessons Overview

1

How to automate your social media content using Airtable, BannerBear and Zapier

Lesson Content:

What is Airtable?

Airtable is an awesome tool that acts like a spreadsheet but also makes it very easy to get data in and out of your spreadsheets through integrations with other apps.

What is Bannerbear?

Bannerbear is an API for generating images. You design a template (or grab one from the library) and then feed in data using the API to generate images based off that template e.g. with different texts, colors and background images.

What can I do with Airtable + Bannerbear?

If you're creating social media assets over and over again based on a particular template, you can use Bannerbear to automate this process. Organize your data on Airtable, click a button to import into Bannerbear, and watch all your images get magically generated!

This way you can do all your content planning for clients entirely in Airtable using just text, then when you're ready to produce the assets for posting, you just click one button.

And all of this using #nocode!

Sample images

By the end of this tutorial you'll have automatically generated images like this:

></div></figure><figure class=
></div></figure><h2>Adding your Airtable API Key</h2><p>First you need to add your Airtable API Key to Bannerbear.</p><p>You can find your Airtable API Key in the <a href=Account section of Airtable.

Copy the key to your clipboard:

></div></figure><p>Next, add the Airtable API Key to Bannerbear in the <a href=Integrations section:

></div></figure><figure class=
></div></figure><p>That's the first part done!</p><h2>Adding a Bannerbear template</h2><p>Bannerbear works on a Table-to-Template basis. Meaning, you connect your Airtable table to a template inside one of your Bannerbear projects.</p><p>For this tutorial, create a project on Bannerbear and add the
></div></figure><p>Adding it to a project will take you to the Project / Template page:</p><figure class=
></div></figure><p>You can <a href=design any sort of template you need using the Bannerbear template editor (you can even invite a designer to create one for you!) but for now, lets try connecting this example template to an Airtable.

Connecting the template to Airtable

On the template page (the one we left off at above) scroll to the bottom to find the Airtable icon - click it to go to the Airtable integration page:

></div></figure><p>From here, in terms of this tutorial you have two choices!</p><h3>(Optional) Copy my Airtable Base</h3><p>For the purposes of this tutorial I've set up an airtable base with the columns you need for the Quote Example template.</p><p>If you are using other templates or designing your own template, you will have to set up an Airtable base with the right columns - Bannerbear will show you how, more on this in the next section.</p><p>Copy this base:<br><a href=https://airtable.com/shr8Xv57trKH08eWY

Set the Base ID and Table Name

Every Airtable Base has a special Base ID and Table Name that you need to use to connect with the Template.

You can find the Base ID in the API Documentation on Airtable:

></div></figure><p>The Base ID is near the top of the page:</p><figure class=
></div></figure><p>The Table Name is the sheet / tab name <em>inside</em> the Airtable Base that you are using:</p><figure class=
></div></figure><p>Plug those details into Bannerbear!</p><figure class=
></div></figure><h3>Setting up your Airtable table</h3><p>Once you have saved the above settings, Bannerbear will show you how it expects your Airtable to look:</p><figure class=
></div></figure><p>(if you copied my Airtable Base above, your table will already look like this)</p><p>Note that all of these columns are optional. If there's a part of the template that you always want to keep the same in all of your variations, just leave it out of the table.</p><p>The last two columns are optional but pretty handy so I recommend including them:</p><ul><li><strong>imported</strong> will show up as checked once Bannerbear has imported something. This is useful to prevent importing things multiple times, and also useful for re-importing (by unchecking) rows that you want to re-generate.</li><li><strong>bannerbear_image_url</strong> will be populated with the final image that Bannerbear generates. Again, not mandatory since all your images will be listed in the Bannerbear dashboard, but this is a convenient way to stay organized in Airtable.</li></ul><p><em>Want to import data into multiple Bannerbear templates? </em><a href=Here's how to do that

Import Airtable data

You're all set now!

If you copied my Airtable Base above, feel free to add more rows of data or overwrite the existing data with your own.

If you started a Base from scratch, add some rows of data before trying to import.

For reference, my Airtable Base / Table has data like this:

></div></figure><p><strong>Note the last row that I added ;)</strong></p><p>Hit the import button in Bannerbear:</p><figure class=
></div></figure><p>After a couple of seconds, Bannerbear will have imported the data from your Airtable and start to generate the images. You can either view your Images list in Bannerbear to watch the new images pop up, or if you included the <strong>bannerbear_image_url</strong> column in your Airtable, you can watch the images get populated there!</p><figure class=
></div></figure><p>‍</p><p>‍</p></div></div><div id=

Tools used in this Tutorial

Bannerbear
Zapier