Loading

Google Sheets + Twitch

Add new Google Sheets spreadsheet rows for Twitch followers

Streamers can keep track of all their followers in a Google Sheets spreadsheet so that they can keep track of who their fans are and make sure that they are giving them the content that they want.

Streamers can keep track of all their followers in a Google Sheets spreadsheet so that they can keep track of who their fans are and make sure that they are giving them the content that they want.

  1. When this happens...
    TwitchTwitch
    New Follower

    Triggers when you receive a new follower on Twitch.

    TriggerScheduled
  2. automatically do this!
    Google SheetsGoogle Sheets
    Create Spreadsheet Row

    Create a new row in a specific spreadsheet.

    ActionWrite
Try this template
  • Free forever for core features
  • 14 day trial for premium features & apps

Supported triggers and actions

What does this mean?
  • Twitch triggers, actions, and search

    New Follower

    Triggers when you receive a new follower on Twitch.

    Trigger
    Scheduled
    Try It
    • StreamerRequired

      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 in twitchpresents.

    Trigger
    Scheduled
    Try It
    • Api 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.

    Action
    Write
    • No Team Drive

      If you want to use this trigger with a Sheet that resides in your Google Team Drive, you have to workaround the issue using these steps.

    • SpreadsheetRequired

    • WorksheetRequired

      You must have column headers

    Trigger
    Instant
    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.

    Trigger
    Scheduled
    Try It
    • Owner

      Determines which App Extensions will appear in the dropdown below.

    • App ExtensionRequired

    Action
    Write
    • Drive

      The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.

    • SpreadsheetRequired

    • WorksheetRequired

      You must have column headers

    Trigger
    Scheduled
    Try It
    • Drive

      The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.

    Trigger
    Scheduled
    Try It
google-sheets logo
google-sheets logo

About Google Sheets

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Learn more

Related categories

  • Google
  • Spreadsheets

Similar apps

Zoho Creator integrationsZoho Creator integrations

Zoho Creator

App Builder, Zoho
Smartsheet integrationsSmartsheet integrations

Smartsheet

Spreadsheets
Quip integrationsQuip integrations

Quip

Documents
twitch logo
twitch logo

About Twitch

Twitch is a live streaming video platform.
Learn more

Related categories

Similar apps

Discord integrationsDiscord integrations

Discord

Team Chat

Get started for free

You can't add more hours to the day. Zapier is the next best thing.


OR

By signing up, you agree to Zapier's terms of service and privacy policy.