Plugging Twitch viewcount/followers into Google Docs

538 views
Skip to first unread message

Jordan Green

unread,
Nov 22, 2013, 6:10:01 AM11/22/13
to twitc...@googlegroups.com
Hi there, I'm trying to find a proper API line for Google Docs to automatically plug-in and update a Twitch user's follower and viewer counts on command. I'm trying to use the Twitter API as a root, but can't find any combination of changes that makes this work for Twitch.

The line I'm using to import from Twitter is:

=importXML("http://twitter.com/"&substitute(B2,"@","",1),"//a[@data-element-term='follower_stats']")


Is there anything near an equivalent to this for Twitch followers and viewers? If you need a channel to work with to write the necessarily lines, use http://twitch.tv/treisk for reference. Thanks in advance to anyone that can help me figure this out!

Flo

unread,
Jan 29, 2014, 6:49:05 AM1/29/14
to twitc...@googlegroups.com
I am also interrested !

Night Walker

unread,
Jan 29, 2014, 8:10:46 PM1/29/14
to twitc...@googlegroups.com
Use something like http://blog.fastfedora.com/projects/import-json with the official Twitch API rather than trying to grab data out of the HTML.


--
You received this message because you are subscribed to the Google Groups "Twitch API" group.
To unsubscribe from this group and stop receiving emails from it, send an email to twitch-api+...@googlegroups.com.
To post to this group, send email to twitc...@googlegroups.com.
Visit this group at http://groups.google.com/group/twitch-api.
For more options, visit https://groups.google.com/groups/opt_out.

Reply all
Reply to author
Forward
0 new messages