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:
Finally, you extract only the Insta handle from the URL:
Then, you can directly refer to
F2 when making the request to the IG API to get the follower count.
Hope this helps