Automate social media posts with Airtable

Business Benefits

Reduce your social media team’s daily workload.

Scroll to the right of your existing content table and click the large + button to add new columns.

Use the:

  • Long text field column for the actual copy of your social media.
  • Attachment property column for any images or videos that need to be posted.
  • Date property column for the date and time that the content should get posted.
  • Single select property for the platform the content will be posted on, such as Twitter, Facebook, or Instagram.
  • Formula property column.

Enter the formula DATETIME_DIFF({Date Field}, NOW(), 'minutes') to the Formula property column.

While you won’t be scheduling your social media posts right away, this initial formula tells Airtable the basic timing structure it should use when you schedule your posts. Most companies won’t need to get more specific than the basic date, hour and minute that content should be posted to social media. However, if you need to be even more specific, such as posting at a specific second or millisecond, Airtable offers additional timing formulas.

Click the large + button to add additional columns for any extra metadata and other content you need to include with your social media post.

Examples include:

  • Captions.
  • Tags.
  • Author bylines.

Working from left to right, complete each empty column in the first row of your table, with your first social media post.

  • Enter your plain text copy into the Long text field column.
  • Add any necessary images, graphics or videos to the Attachment column.
  • Select the date and time when you want this post to go live and enter that into the Date column.
  • Specify which social media platform this post is for in the Single select column.

Start a new automation: click the Automation tab above your table and click Create custom automation.

You will need to create new automations for each platform:

  • Click the Automations button, which opens the automations side panel.
  • Select the blue Create an automation button in the side panel.
  • Click + New Automation.

Name this automation after the specific social media platform this automation is focused on, such as Facebook or Twitter.

Set up a new trigger that tells Airtable to start posting your social media content by clicking + Choose a trigger > When a record matches conditions > + Add condition.

Add two conditions that specify when to post, and what platform to post on.

In the + Add condition menu, select When Countdown = 0. This tells Airtable to refer to the formula you entered previously, and to trigger the publishing of your social media post when the countdown hits zero, which is when the current time and the scheduled posted time match. Add a second condition for when the social media platform listed in the Single select column matches the name of the automation itself. For example, if Facebook is listed in the Single select column, Airtable will also check to ensure the automation that’s running is also named Facebook.

Connect the automation to your social media platforms by clicking + Add action and selecting the corresponding social media network action.

An Airtable action is the actual task that occurs when the trigger starts. In this case, you want Airtable to send the content in each of your columns to a connected social media account. Airtable has built-in integrations with Twitter, Facebook and many other major platforms. For example, if you’re automating Twitter social media posts, click + Add action > Twitter: Post tweet and either select your account or add your account if you haven’t linked it to Airtable yet.

Click the + signs in the action elements to automatically fill them in with elements from the database.

Where applicable, include content files in the Attachment section and caption text in the Message section.

Double-check that each automation is named after the specific social media platform to ensure that each automation is posting to the right account.

Repeat the steps from starting an automation for each platform where you will be posting content.

Last edited by @hesh_fekry 2023-11-14T15:07:35Z

@koenvegter1997 I think this is a good candidate for automating a playbook? what do you think.

Hi @hesh_fekry , I was testing the playbook and have trouble adding the formula in the column. I get an error message in Airtable:

I think this is also exactly why this playbook would be ideal for a test. In addition, a lot of technical steps so I think the perfect prototype usecase!

Let me know if you know whats wrong with the formula, then I will probably also be able to sort out the condition error I got while following the playbook, as it ties back to the formula column I need to create. Once I know how to run the playbook in real life, I will turn it into a PoC as discussed.

I think its also good to test a playbook that is used a lot. Do you have user statistics on how much this playbook is viewed/used?

1 Like

Let me have a look for you about the formula.

I see you used the Date directly here.

This should be referencing the Date field in my case its called Post Date and the syntax is {Post Date}

Ill update the playbook to make this clear.

The views shown on the new platform don’t have historic data but its not the most popular for sure. It is quite niche as automation and airtable are acting as filters.

This one is quite popular and also produced by Simo Ahava, so it would be an interesting choice if possible to layer what you need on top.

It could also require updating, as GA have been updating recently. So worth a pair of eyes on it.

Have a look at it and let me know. Curious to see what you come up with.