Access Twitch in Excel


Channels

  • Lookup - Get statistics and information about a particular channel.
  • Search - Find channels matching a specific query.
  • Feed Posts - Extract a list of all posts posted on a specific channel.

Videos

  • Lookup - Get statistics and information about a particular video.
  • Videos from Channel - Extract a list of all videos streamed on a specific channel.

Comments

  • Feed - Gets all comments on a specified post in a specified channel feed.

Followers

  • List - Gets a list of users who follow a specified channel. Sort results by:
    • Newest or Oldest

Toplists

  • Top Games - Gets games sorted by number of current viewers on Twitch, most popular first.
  • Top Videos - Gets the top videos based on viewcount.

Streams

  • List Livestreams - Gets a list of live streams. Sort results by:
    • Channel
    • Game
    • Language
  • Search - Searches for streams based on a specified query parameter.

Games

  • Search - Searches for games based on a specified query parameter.

Access

Add from Manager

The Twitch Connector is available in the Connectors Manager in the top ribbon:

Head over to the Social Category and install Twitch:

Get API keys

To use the Connector you need a Twitch Standard account a developers account.

  1. Once you've logged in to your developers account, click on "Register An App" in the bottom right corner.

  2. On the next page, click on "Register Your Application"

  3. Next, fill out the required fields and click on "Register"

  4. Head back to the Dashboard and click on "Manage" for your newly created app.

  5. Copy the "Client Secret" and insert in the Twitch Settings menu inside SeoTools.


Contribute

This connector suite is open-sourced on GitHub.


See

Official Documentation

Resources


Get help with this function in the community →