Number of followers on Instagram

Hi !

Is it possible to know the number of followers on an Instagram page automatically (based on the URL web site or Instragram page URL) in DashDash?

Thanks for your help :slight_smile:

1 Like

Hi @Copilot,

Yes, there is! :nail_care:

One of our power-users, @cwinhall, has actually found an API that retrieves the following count and other Instagram data as a JSON object, based on an Instagram username:

=GET("https://www.instagram.com/"&A2&"/?__a=1")

A2 includes an Insta handle.
image

Let me know if this solves it for you :raised_hands:

2 Likes

Huge thank you !

But I still have a problem.

With Built With integration it return me a list of the social media URL available for a Web site URL

  1. http://facebook.com/accountname
  2. http://instagram.com/accountname

etc…

The order of them is random so I want to do a big If(Find) formula to check if a cell contain “instagram” get the accountname (with a right function).

But I can’t find how to do, i try that way but is not working because the Find return a #VALUE! if is not find

=IF(FIND(“instagram”,A2)<>"",A2,IF(FIND(“instagram”,B2)<>"",B2,
etc…

Hi again @Copilot,

There’s actually a formula that allows you to parse a data object out of a JSON that contains a certain string, for example “instagram”.

Here’s how you do it:

First, you get the data via BuiltWith (in my example: B2). Then, you could create a column that specifies which social profile you’re looking for—Instagram, Facebook, Twitter, etc.

In the next column, you then parse out the object, referring to the profile type specified in C2.

D2=PARSE(B2,"$..Social[?(@ =~ /.*"&C2&".*/i)]")

Once you have that, you can parse out the URL directly in the next column and wrap an IFERROR() function around it that displays a “Not found” help text in case no IG profile has been found:

=IFERROR(PARSE(D2,"[0]"),"not found")

Finally, you extract only the Insta handle from the URL:

F2=RIGHT(E2,LEN(E2)-SEARCH("com/",E2)-3)

Then, you can directly refer to F2 when making the request to the IG API to get the follower count.

Hope this helps :blush:

1 Like

Hi @nadjabenes,

Thanks a lot! It’s working perfectly! :scream:

I have just one more little question.

With this formula :
=PARSE(B2,"$…Social[?(@ =~ /."&C2&"./i)]")

I only will be able to find a label in the Social block of the api.
If I want for exemple in BuiltWith know if the web site have a specific tech.

exemple :

  • C2 = MailJet
  • D2 = MailJet or “Not Found”

MailJet is in Technologies -> “an index number” -> Name

Is it possible?

I tried with that, but I didn’t get any result (But B2 have MailJet in Technologies) :
=PARSE(B2,"$…Technologies[?(@ =~ /."&$C$2&"./i)]")

Yes, that’s possible, too! We’ll have to add the Name object here as well, since that’s the next higher object in the API response.

Your PARSE function should look like this:

=PARSE(B2,"$..Technologies[?(@.Name =~ /.*"&C2&".*/i)]")

That should solve it :wink:

1 Like

It’s almost working!

I tried with this formula :
=PARSE(W2,"$…Technologies[?(@.Name =~ /."&“WordPress”&"./i)]")

I have not data (instead my BuiltWith cell have a WordPress component)

But with this one :
=PARSE(W2,"$…Technologies[?(@.Name =~ /."&“WordPress”&"./i)]")

I have all the “WordPress” Name and “WordPress Plugins” Name

I need to only get the “WordPress”.
Do you know what should I do?

ps : I already tried this without sucess:
=PARSE(W2,"$…Technologies[?(@.Name =~ /.*"&“WordPress”&"./i)]")

Hi @Copilot,

To filter out only those Technology objects that include the exact phrase match of “WordPress” (without the Grid, Plugins, etc.), you can try this formula:

=PARSE(B4,"$..Technologies[?(@.['Name']=='WordPress')]")

This should do it!

And another pro-tip :nerd_face:: If you would like to parse only a certain data object of the WordPress Technology objects, for example “Link”, you can use this formula:

=PARSE(B4,"$..Technologies[?(@.['Name']=='WordPress')].Link")

This will parse the Links of those Technologies that include only the name “WordPress”. Does that make sense?

There’s so many cool things you can do with this :star_struck: Let me know if you have any other questions!

1 Like

Huge! thank you!

I just have one more question :slight_smile:

I have a column named “CMS TECH” in which I want to display the CMS tech of the web site (URL).
Can I with your formula print : “Wordpress” OR “PrestaShop” OR etc…

Something like that :
=PARSE(B4,"$…Technologies[?(@.[‘Name’]==OR(‘WordPress’,‘PrestaShop’)].Link")

The other way I found is to have multiple columns but less convenient

Thanks a lot for your amazing help Nadja !

Hi @Copilot,

To use the OR condition for the CMS Tech, try this formula:

=PARSE(B4,"$…Technologies[?(@.[‘Name’]==‘PrestaShop’ || @.[‘Name’]==‘Wordpress’)].Link")

It should return {data} with the links in case of a match. Then you can just PARSE the value to a separate column (e.g =PARSE(G2,"[0]") )

Let me know if it helps :slight_smile:

1 Like

Hi @henrique,

Thanks for your help :slight_smile:

I tried but it’s not working I think it is because of “||” is an AND operator and in this case it’s need an OR operator, I think.

I tried to find the OR operator in the documentation but without success :confused:

Do you know which character to use for an OR?

Hi @Copilot,

The OR operator should be “||”

Can you tell which error are you getting?

Here is the exact spreadsheet I have with the OR operator, working as expected.

A1: domain
B1: request
C1: parse
A2: dollskill.com
B2: =DOMAIN_TECH_STACK_BUILTWITH(A2)
C2: =PARSE(B2,"$…Technologies[?(@.[‘Name’]==‘Google Remarketing’||@.[‘Name’]==‘Wordpress’)]")

Here is a short video of the spreadsheet.

Hope it helps :slight_smile: Let me know in case it doesn’t and happy to jump on a quick call to see how we get it working.

1 Like

It’s working perfectly!
Thank you very much!

It wasn’t working because of the “.Link” at the end of the formula :slight_smile:

This one works fine:
PARSE(B2,"$…Technologies[?(@.[‘Name’]==‘Google Remarketing’||@.[‘Name’]==‘Wordpress’)]")

1 Like

Perfect @Copilot , happy to hear that! :muscle:

1 Like

Hi Nadja,

this is no longer working, as it seems to be banned by IG/FB.
Is there a workaround?

BR,
Gabriel

Hi @gabriel,

So sorry about that! The good news is that we’re already working on an Instagram integration :slight_smile: Please be patient with us—we’ll definitely let you know once the integration is out! :raised_hands:

2 Likes