Google Sheets
When this happens...
TwitterLiked Tweet
do these tasks!
BigMLCreate Topic Distribution
Google SheetsCreate Spreadsheet Row

If you like to favorite tweets, then this integration will allow you to automatically detect the topics those tweets are about and keep track of them in a Google Sheets spreadsheet. This will allow you to build an archive of relevant tweets with an associated list of topics. For example, if you train a BigML model to detect which product of yours is mentioned in a tweet, or which product category, by favoriting all those tweets you can build a list of relevant tweets automatically classified by product or product category. As an additional example, you might want to classify your favorite tweets based on their topic being about music, movies, TV-series, etc.

Note: This Zapier integration doesn't include a ready-to-use Topic Modelling model. You are expected to train one from your own data.

How this Twitter-BigML-Google Sheets integration works

  1. Zapier watches your Twitter account for favorited Tweets
  2. Whenever you favorite a new Tweet, Zapier will use BigML to detect the topic distribution of that Tweet
  3. Zapier will store the list of topics the Tweet is about in Google Sheets

Apps involved

  • Twitter
  • BigML
  • Google Sheets

Why Zapier?


Get started for free—14 day trial of premium features and apps.


No coding required—automate any of 1,500+ apps in minutes.


Enterprise-level security—connect mission-critical apps.

It's easy to connect Google Sheets + Twitter and requires absolutely zero coding experience—the only limit is your own imagination.

When this happens...
then do this!
New Spreadsheet Row

Triggered when a new row is added to the bottom of a spreadsheet.

Create Worksheet

Create a blank worksheet with a title. Optionally, provide headers.

New or Updated Spreadsheet Row

Triggered when a new row is added or modified in a spreadsheet.

Create Spreadsheet Row

Create a new row in a specific spreadsheet.

Search Mention

Triggers when any user creates a new Tweet that contains a specific search term (like a word, phrase, username or hashtag).

Update Spreadsheet Row

Update a row in a specific spreadsheet.

My Tweet

Triggers when you tweet something new.

Create Tweet

Creates a tweet.

Search & Geo Mention

Triggers from mention of search term in a specific geo location.

Add User to List

Adds a user to one of your lists.

Use our free platform to build a single Zapier integration and instantly connect your app with 1,500+ others.

Become a Zapier Integration Partner

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

Learn More

Twitter is the social network that shows what's happening around the world in real time. Share your ideas in Tweets, follow hashtags to keep up with trends, and join in the global conversation.

See Twitter Integrations