How to connect Twitch + MySQL
Zapier lets you send info between Twitch and MySQL automatically—no code required. With 5,000+ supported apps, the possibilities are endless.
- Free forever for core features
- 14 day trial for premium features & apps
Top companies trust Zapier to automate work and free up time
Connect your apps and automate workflows
Easy automation for busy people. Zapier moves info between your web apps automatically, so you can focus on your most important work.
New Follower
Triggers when you receive a new follower on Twitch.
Try ItStreamerRequired
Select from a list of streamers that you follow. To add additional streamers that you don't follow, click the "Use Custom Value" option and enter in the login name of your desired streamer. The login name are the characters after the last slash in a streamer's URL. For example, if you'd like to follow
https://www.twitch.tv/twitchpresents
, then enter intwitchpresents
.
Try ItTable/ViewRequired
Try ItQueryRequired
Query results must have a unique
id
field so we can deduplicate records properly! Otherwise we will make a best guess. You must also include desired ordering and limiting in the query.Note: This query must run in less than 30 seconds and it is recommended that you return no more than 5,000 rows
Try It
Game
Select a game from the top 100 most popular games on Twitch
Language
Streamer
Select from a list of streamers that you follow. To add additional streamers that you don't follow, click the "Use Custom Value" option and enter in the login name of your desired streamer.
Viewer Threshold
Select the minimum amount of viewers on a stream to trigger your Zap. The default is 500.
Try ItApi Docs Info
API docs for Twitch are located here https://dev.twitch.tv/docs/api/reference
HTTP MethodRequired
URLRequired
Requests can only be made to domains associated by this application.
Query String Parameters
These params will be URL-encoded and appended to the URL when making the request.
Headers
Authentication headers are included automatically
Additional Request Headers
Zapier will apply these optional headers and values to the request in addition to any headers created as part of the authentication mechanism.
Body
Zapier will pass this along raw. If you would like to provide complex JSON, try a "Code by Zapier" step to build the structure and pass it along here. For example,
{"foo": "bar"}
is perfectly valid.
Table/ViewRequired
We expect at least one unique (and usually autoincrement) primary key column so we can deduplicate records properly! Otherwise we will make a best guess on a random column to use to deduplicate.
Order By
Highly recommended! Usually you want the results to be most recent first so we can skim off only new results, so choose something like
date_created
or your autoincrementid
. Column names that contain a space must be enclosed within brackets[ ]
.Dedupe Key
We default to what the primary key is on the table as the unique key to deduplicate on. If you prefer another field, select it here.
Try ItNew Table
Triggered when you add a new table.
Try It
How Twitch + MySQL Integrations Work
- Step 1: Authenticate Twitch and MySQL.30 seconds
- Step 2: Pick one of the apps as a trigger, which will kick off your automation.15 seconds
- Step 3: Choose a resulting action from the other app.15 seconds
- Step 4: Select the data you want to send from one app to the other.2 minutes
- That’s it! More time to work on other things.
Related categories
Related categories
Get started for free
You can't add more hours to the day. Zapier is the next best thing.