Help

Re: Social media reporting

Solved
Jump to Solution
517 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Jessica_H
4 - Data Explorer
4 - Data Explorer

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

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

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.

See Solution in Thread

1 Reply 1
ScottWorld
18 - Pluto
18 - Pluto

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.