Capture Your Twitter Followers

Method

Each time you get a new Twitter follower, save the follower profile information to an Excel table.

What You Need

• Twitter account
• Excel
• Zapier‍

Steps

1. Create an Excel file on OneDrive that has a Table defined for any data you want to collect about your twitter followers. The available fields are:

• Follower Screen Name
• Follower Display Name
• Follower URL
• Follower Description
• Follower Location
• Followers Count
• Following Count
• Follower Twitter Created
• Followed by
• Followed

2. Create a Zap for the Twitter app.

3. Trigger Zap when there is a new follower to your account.

4. Add a Zap step to write the data to a row in your table in Excel.

Advanced Tip

To create a timestamp in your Excel spreadsheet for each new follower, add a column to your table "Date Added" and use the Zapier function "Zap Meta Human Now" to populate that field.

With this saved data, you will be able to do some pretty cool analytics on your Twitter followers.