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
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
Hi @Copilot,
Yes, there is!
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.
Let me know if this solves it for you
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
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
Hi @nadjabenes,
Thanks a lot! Itâs working perfectly!
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 :
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
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 : 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 Let me know if you have any other questions!
Huge! thank you!
I just have one more question
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
Hi @henrique,
Thanks for your help
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
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 Let me know in case it doesnât and happy to jump on a quick call to see how we get it working.
Itâs working perfectly!
Thank you very much!
It wasnât working because of the â.Linkâ at the end of the formula
This one works fine:
PARSE(B2,"$âŚTechnologies[?(@.[âNameâ]==âGoogle Remarketingâ||@.[âNameâ]==âWordpressâ)]")
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 Please be patient with usâweâll definitely let you know once the integration is out!
As i know there is no problem to automatically find out the number of followers based on the url, i guess any child would do that, the problem is with the returning url from different social network websites just like you mentioned above, and the formula is not always working, i mean somtimes it gives me every data, with the right value, but sometimes it just wonât work, and i donât understand why. Someone told me that it might happen when the account you trying to monitor might have purchased followers for that certain social network, could you tell me, cand that be the truth? Or is it just me, maybe i havenât done everything right.
Hi Scott! Out of curiosity, are you using our Instagram integration? If so, which function is throwing you the error, and would you mind telling us the accounts that are giving you trouble? Weâll check out whatâs going on
Hi, no i havenât tried you instagram integration, will it make it easier? I will send you the accounts in couple of hours as soon as i reach my office and i will tell you all the other details.
Perfect! Please do
And yes, weâve made a few things a lot easier with the integration so hopefully we get to the bottom of the issue youâre having ^^