Twitch New stream started by you. X (Twitter) Post a tweet. Google Sheets Add row to spreadsheet.

Post a tweet and log new Twitch streams in Google Sheets

Connect

About this Applet

Whenever you start streaming on Twitch, this applet tweets about your live stream and records the stream details in a Google Sheets log. It helps you promote your stream instantly while keeping a detailed record of each broadcast. Customize the tweet message and spreadsheet location to fit your needs. Customize the message to fit your tone.

If
Twitch icon
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
This trigger fires every time you start streaming on Twitch.
CreatedAt Game ChannelName StreamPreview ChannelUrl CurrentViewers StreamTitle
Then
X (Twitter) icon
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This Action will post a new tweet to your Twitter account. NOTE: Please adhere to Twitter’s Rules and Terms of Service. Affiliate URLs are not supported in Tweet text and will result in an Action error.
tweet
And
Google Sheets icon
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will add a single row to the bottom of the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created after 2000 rows.
filename formatted_row path

Services used in this Applet

Create your own workflow

Create custom workflows effortlessly by selecting triggers, queries, and actions. With IFTTT, it's simple: “If this” trigger happens, “then that” action follows. Streamline tasks and save time with automated workflows that work for you.

49 triggers, queries, and actions

Cell updated in spreadsheet

Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
This trigger fires when a particular cell is updated within the spreadsheet you specify.

New follower

Pro icon
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
This Trigger fires every time a new user starts following you.

New follower on your channel

Pro icon
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
This trigger fires every time there is a new follower of your channel.

New liked tweet by you

Pro icon
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
This Trigger fires every time you like a tweet.

New link by you

Pro icon
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
This Trigger fires for every link you tweet. If your tweet has multiple links, it will fire multiple times.

New mention of you

Pro icon
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
This Trigger fires every time you are @mentioned in a tweet.

New photo or video by you

Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
This trigger fires every time you post a tweet that includes a photo, video, or GIF.

New reply to your tweet

Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
This trigger fires every time someone replies to one of your tweets.

New row added to spreadsheet

Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
This trigger fires when a new row is added to a spreadsheet you specify.

New spreadsheet added to folder

Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
This trigger fires when a new spreadsheet is added to a Google Drive folder you specify. Note: only works for spreadsheets created after the Applet turned on.

New stream started by you

Pro icon
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
This trigger fires every time you start streaming on Twitch.

New tweet by a specific user

Pro icon
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
This Trigger fires every time the Twitter user you specify tweets.

Current value of a cell

Pro plus icon
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns the current value of a single cell in your spreadsheet.

Current values of a row

Pro plus icon
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns the current values in a given row. Values from columns A-Z are available as ingredients.

Find rows in spreadsheet

Pro plus icon
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns the rows of a worksheet with a cell that contains or matches a value, with each row's number for "Update row in spreadsheet". Use it to look up rows instead of reading them one at a time.

Get a user's profile

Pro plus icon
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns the public profile and stats of any X account you specify.

Get rows in spreadsheet

Pro plus icon
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query reads 50 rows of a worksheet, starting at the row you choose, and returns the ones with data. Use it to read a table, header row included, in one run instead of one row at a time. To read on, add 50 to the start row.

Get your account stats

Pro plus icon
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns your current follower count, following count, tweet count, and listed count.

History of followers on your channel

Pro plus icon
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of when there were new followers of your channel.

History of following a new channel

Pro plus icon
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of when you follow new channels on Twitch.

History of rows added to spreadsheet

Pro plus icon
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of when a new row is added to a spreadsheet you specify.

History of spreadsheets added to folder

Pro plus icon
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of when a new spreadsheet is added to a Google Drive folder you specify. Note: only works for spreadsheets created after the Applet turned on.

History of Stream going live events for a channel you follow

Pro plus icon
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of events when a stream went live for the specified Channel that you follow.

History of streams started by you

Pro plus icon
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of when you started streaming on Twitch.

Add multiple rows to spreadsheet

Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will add up to 5 rows to the bottom of the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created after 2000 rows.

Add row to spreadsheet

Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will add a single row to the bottom of the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created after 2000 rows.

Add row to top of spreadsheet

Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will insert a single row directly below the header row (row 1) of the first worksheet of a spreadsheet you specify, pushing existing data down.

Create spreadsheet

Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will create a new blank spreadsheet in a Google Drive folder you specify. If a spreadsheet with the same name already exists, no new file is created.

Post a tweet

Pro icon
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This Action will post a new tweet to your Twitter account. NOTE: Please adhere to Twitter’s Rules and Terms of Service. Affiliate URLs are not supported in Tweet text and will result in an Action error.

Post a tweet with image

Pro icon
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This Action will post a new tweet to your Twitter account with a linked pic.twitter.com image. NOTE: Please adhere to Twitter’s Rules and Terms of Service. Affiliate URLs are not supported in Tweet text and will result in an Action error.

Post a tweet with video

Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will post a new tweet to your X account with a video from a URL.

Update cell in spreadsheet

Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will update a single cell in a spreadsheet you specify, on the first worksheet unless you name another. A missing spreadsheet is created only when you give a name and no URL or worksheet.

Update multiple rows in spreadsheet

Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will overwrite values in up to 5 consecutive rows, starting at the row you specify, on a spreadsheet's first worksheet unless you name another. A missing spreadsheet is created only when you give a name and no URL or worksheet.

Update row in spreadsheet

Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will overwrite all values in a specific row of a spreadsheet you specify, on the first worksheet unless you name another. A missing spreadsheet is created only when you give a name and no URL or worksheet.

Add multiple rows to spreadsheet

Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will add up to 5 rows to the bottom of the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created after 2000 rows.

Add row to spreadsheet

Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will add a single row to the bottom of the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created after 2000 rows.

Add row to top of spreadsheet

Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will insert a single row directly below the header row (row 1) of the first worksheet of a spreadsheet you specify, pushing existing data down.

Cell updated in spreadsheet

Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
This trigger fires when a particular cell is updated within the spreadsheet you specify.

Create spreadsheet

Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will create a new blank spreadsheet in a Google Drive folder you specify. If a spreadsheet with the same name already exists, no new file is created.

Current value of a cell

Pro plus icon
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns the current value of a single cell in your spreadsheet.

Current values of a row

Pro plus icon
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns the current values in a given row. Values from columns A-Z are available as ingredients.

Find rows in spreadsheet

Pro plus icon
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns the rows of a worksheet with a cell that contains or matches a value, with each row's number for "Update row in spreadsheet". Use it to look up rows instead of reading them one at a time.

Get a user's profile

Pro plus icon
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns the public profile and stats of any X account you specify.

Get rows in spreadsheet

Pro plus icon
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query reads 50 rows of a worksheet, starting at the row you choose, and returns the ones with data. Use it to read a table, header row included, in one run instead of one row at a time. To read on, add 50 to the start row.

Get your account stats

Pro plus icon
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns your current follower count, following count, tweet count, and listed count.

History of followers on your channel

Pro plus icon
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of when there were new followers of your channel.

Build an automation in seconds!

You can add delays, queries, and more actions in the chat.

More on these services

About X (Twitter)

X (Twitter) Applets can help you manage and save tweets, keep an eye on #hashtags, and much more.

Explore X (Twitter)

More integrations with X (Twitter)

About Twitch

Twitch is the world’s leading social video platform and community for gamers, video game culture, and the creative arts. Turn on Applets to grow your Twitch audience, and keep up with your favorite broadcasters' videos and livestreams.

Explore Twitch

More integrations with Twitch

About Google Sheets

Google Sheets lets you create and edit spreadsheets stored on your Google Drive. Turn on Applets to monitor specific cells in your spreadsheets as well create news docs, rows, and cell updates.

Explore Google Sheets

More integrations with Google Sheets

IFTTT helps all your apps and devices work better together

Get started for free