Overview
Using the SyncWith Google Sheets Addon we can pull metrics from the Twitter API including follower count, following count and more, for one username, or a list of usernames from Google Sheets. To do this we'll make use of the twitter users by username endpoint.
Steps
- Install the SyncWith Google Sheets Addon
- Search for Twitter, and choose the
/2/users/by/username/{username}
endpoint, or paste in the endpoint: https://api.twitter.com/2/users/by/username/{username}
- Press
Connect
to authorize access to the twitter API using your twitter account
- Populate the
username
field
- Set the field
user.fields
to the valuepublic_metrics
telling twitter you want that user's public metrics returned
- Click
Preview
- You should now see the data returned from Twitter
- In the preview dialog, you can click
+ Expand
on fieldpublic_metrics
to break out the metrics into their own columns

Try it live
Try it below, and then export the results to a connected Google Sheet!
Twitter user metrics
Please fill in any necessary fields and click Run.
GET
Preview
View the API data, get a live Google Sheet dashboard
followers_count | following_count | tweet_count | listed_count | name | username | id |
---|---|---|---|---|---|---|
 |  |  |  |  |  |  |
 |  |  |  |  |  |  |
 |  |  |  |  |  |  |
Get a live Google Sheet
Export your data to a google sheet, with the SyncWith Addon, or download to CSV
Automatically updated
Schedule your data to update hourly or daily
Add data sources
Import additional data from other apps
Build reports & dashboards
Easily build live reports within Google Sheets