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
Connectto authorize access to the twitter API using your twitter account
- Populate the
usernamefield
- Set the field
user.fieldsto the valuepublic_metricstelling 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
+ Expandon fieldpublic_metricsto break out the metrics into their own columns
Try it live
Try it below, and then export the results to a connected Google Sheet!