What is the best action to use with Airtable that will trigger a post based on a status change in Airtable?

How To
1

Hi
I’m using Airtable to house my LinkedIn posts

What I’d like to see happen is Airtable is the trigger, a message is sent to Slack notifying me that the LinkedIn post has been scheduled, and the post goes to Buffer queue for later posting.

As of now, I’m using the watch records action, but I want to see the action to be triggered based. Meaning, I change a status in Airtable which activates the scenario.

Which acation for Airtable is best for me to use?

2

For your Airtable setup, using the “Watch Records” action is great, but to activate scenarios based on status changes, you should use the “Update Record” trigger. This will allow you to change a status in Airtable, which will then trigger the actions you want. Here’s how we can set it up:

  1. Configure the “Update Record” trigger in Airtable to activate when the status field is updated.
  2. Add a step to send a notification to Slack, informing you that the LinkedIn post has been scheduled.
  3. Finally, integrate Buffer to add the post to the queue for later posting.
2 Likes
3

@sachinkarma19 thank you. For this to work do I need a paid Airtable account? I ask because I found a similar suggestion that mention creating and running a script but I don’t have a paid account.

4

Looks like from a quick search with the free plan you get 1000 API calls per month so I would just be considerate of that when timing your scenario. In that case you can just run the scenarios on MAKE through you airtable account.

1 Like
5

To address your question, running scripts in Airtable typically does require a paid account. However, if you’re looking for a workaround, you can utilize Google Sheets in combination with Google Apps Script to achieve similar automation without additional costs. This involves setting up scripts in Google Sheets that can interact with various APIs and handle data processing, providing a flexible and cost-effective alternative.

Here’s a simple approach you can take:

  • Set up your data structure in Google Sheets.
  • Use Google Apps Script to write custom functions or automate tasks.
  • Integrate with external APIs if necessary, using the script to pull or push data.