Hi everyone!
We are currently setting up our social media planner in Airtable and we are wondering if there’s a way to automate the reporting. For example, would it be possible to automatically feed the performance of the individual social media posts (on Instagram, Facebook, Twitter, Pinterest) back to the Airtable sheet?
If so, what’s the best way to set it up?
Thanks!
Jess
Best answer by ScottWorld
Welcome to the community, @Jessica_H!
This can definitely be done, but it’s relatively tricky & not something that is built into the platform itself.
You would need to create your own custom methodologies of grabbing that information from those sites using their API’s, and then pushing that information into Airtable using Airtable’s API.
One way that you can do this is by writing custom Javascripts that communicate with the API’s of all these different platforms, although this would take both coding expertise & API expertise. There are several JavaScript experts here in the forums that might be available for hire to help you create the scripts that you need.
You might also be able to find some success by using Zapier & Integromat, which are low-code/no-code integration tools that communicate with API’s — but without you needing to write JavaScript code. It looks like both of these platforms have some limited support for Facebook, Twitter, Instagram, and Pinterest. Although if your needs go beyond what they offer, you’ll find yourself writing code in those platforms as well. :stuck_out_tongue_winking_eye:
There might also be prebuilt tools out there that are already designed to communicate between those platforms & Airtable.
For example, a quick search on DuckDuckGo just turned up this tool for communicating between the APIs of Facebook & Airtable: Integrate Facebook Pages and Airtable with DreamFactory. I’ve never heard of this tool before, so I have no idea how well it works, but it might be worth checking out.
So there might be other tools out there like this one, that are already created to do what you want to do.
+33Welcome to the community, @Jessica_H!
This can definitely be done, but it’s relatively tricky & not something that is built into the platform itself.
You would need to create your own custom methodologies of grabbing that information from those sites using their API’s, and then pushing that information into Airtable using Airtable’s API.
One way that you can do this is by writing custom Javascripts that communicate with the API’s of all these different platforms, although this would take both coding expertise & API expertise. There are several JavaScript experts here in the forums that might be available for hire to help you create the scripts that you need.
You might also be able to find some success by using Zapier & Integromat, which are low-code/no-code integration tools that communicate with API’s — but without you needing to write JavaScript code. It looks like both of these platforms have some limited support for Facebook, Twitter, Instagram, and Pinterest. Although if your needs go beyond what they offer, you’ll find yourself writing code in those platforms as well. :stuck_out_tongue_winking_eye:
There might also be prebuilt tools out there that are already designed to communicate between those platforms & Airtable.
For example, a quick search on DuckDuckGo just turned up this tool for communicating between the APIs of Facebook & Airtable: Integrate Facebook Pages and Airtable with DreamFactory. I’ve never heard of this tool before, so I have no idea how well it works, but it might be worth checking out.
So there might be other tools out there like this one, that are already created to do what you want to do.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
