Pull Facebook Metrics for URLs into Airtable with Graph API

[Jared]

Hi Airtable Community,

I’m looking to pull Facebook engagement metrics for URLs in a view of my Airtable base. I have the URL field in Airtable, and I would like a second field that pulls the total likes, comments, shares, etc.

Any ideas on how to do this with free or paid solutions? Ideally, I’m looking to not be reliant on a paid subscription. Many thanks!

Column A | Column B
URL A | 100 shares
URL B | 50 shares

Resources:

Facebook for Developers

Graph API Engagement - Documentation - Facebook for Developers

Graph API Engagement

https://www.sharedcount.com/api-docs/getting-started

[Justin_Barrett]

My gut says that either Zapier or Integromat could be used to pull in this data. Both have free accounts, and both have means to let you call external APIs and process the returned data. Integromat also has some built-in Facebook integration (including an action called “Get Post Reactions” that may be useful). Zapier has some Facebook-related actions, though by their names they don’t look relevant to what you want. You may be better off just calling Facebook’s own API and processing the return.

[Jarvis]

I’m also interested to know if this is possible with scripts. If one of the experts could pitch in on the feasibility, I’d be more than glad to be involved in creating one

[Justin_Barrett]

I haven’t tested it, but my gut says that a script should work, either in the Scripting app or via a script action in an automation. It’s like any other API call. Pass the proper request and it should return the desired result.