Is there a way to bring outside data from google spreadsheet into a single site page?
Is this a perfect candidate for wix-app builder?
Example - A band wants to show how many followers they have on social media. But they would like this data update automatically. So as not to worry about manually updating once a month.
Here is an image of the spreadsheet:
Cell C2 is pulling the number from code.
Here is what it would like like on the website side: (upper right box)
So its essentially pulling C2 into the above section next to Facebook, Twitter, Instagram, etc.
Or, maybe there is an internal solution? Using Wix database? with the below code: (C2 = the link)
[u]https://mobile.facebook.com/featherborn[/u]
=VALUE(REGEXREPLACE(REGEXREPLACE(REGEXREPLACE(JOIN(“”,REGEXEXTRACT(LOWER(SUBSTITUTE(INDEX(IMPORTXML(C2,“//@content”),2),“,”,)),“(\d*.\d+)([km])”)),“.”,),“k”,“00”),“m”,“00000”))
Thank you. Any help much appreciated!