I’d love to be able to create a column, that when linked to a URL column for Instagram, Twitter or Facebook, rolled-up the follower-count, and updated live. This would be HUGE for everyone using Airtable to track social media. In our case, we’re leveraging Gallery View to build a casting base, but we need to be able to sort my total influence. Right now, we’re entering the follower-counts manually, and they grow stale the second you hit return.
Automatic Follower-Count for Instagram, Twitter and Facebook Links
This would be fantastic! We use Airtable to manage our own “CRM” of influencers in our industry and we direly need a way to keep track of their latest social stats, as well as communication with them.
This would help us as an ecommerce company to track shipments and such as well.
I’ve been searching the internet, trying to learn python, or find any tool that can help me do this. I have been using this script to get instagram followers to populate when i give my spreadsheet their instagram url.
=IMPORTXML(A1,"//meta[@name=‘description’]/@content")
the a1 column uses this formula
=ArrayFormula(FormResponces!N2:N)
I would love to do this in reverse and give airtable a list of names on a table populated by my vcf import, have it find their instagram, list followers, link in bio, contact, ect. it feels tedious to need to do this one at a time.
@Josh_Sultan Could you send a screenshot of your board? If this works it would be incredibly helpful!
+15There may be a way to do this by taking the username from each URL and sending it to the API of each platform and seeing what info you can get. You could make a simple python API that you can talk to from your base via a script or an app. The python API could talk to the twitter API, insta API etc.
Could be possible! Haven’t tried it yet though.
+3There may be a way to do this by taking the username from each URL and sending it to the API of each platform and seeing what info you can get. You could make a simple python API that you can talk to from your base via a script or an app. The python API could talk to the twitter API, insta API etc.
Could be possible! Haven’t tried it yet though.
Hi Gavin, did you ever give this a go? Very interested in being able to set this up if it’s possible.
Hi Gavin, did you ever give this a go? Very interested in being able to set this up if it’s possible.
Hey Tom,
I’ve got an API I’ve built for the various social networks to get follower counts. It is currently saving some people a lot of time tracking follower accounts for their clients.
I’m thinking of turning it into an Airtable extension with a small monthly fee for unlimited queries. The APIs change pretty regularly and require maintenance, hence the fee.
If this is something you’re interested in accessing if I turned it into an extension, email me at: from@duck.com
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.