Create list of Twitter Followers Usernames only using IFTTT

In my endless efforts of trying to find free replacements to paid social media tools – like Content Strategy Calendar + Schedule Social Media Posts + UNLIMITED team members, for free – and while working on a tracking project that evolved tracking new followers and exporting their usernames to excel sheet, as usual, i headed to IFTTT and started browsing recipes. I found many recipes that allow you to track followers but none of them tracked the “username/handle” only! they all tracked the LinkToProfile which is the ingredient provided by IFTTT!

Luckily; IFTTT allow some extra formatting for Excel sheets – like with Google Drive- so my solution was to use one of Excel’s data formatting

=SUBSTITUTE()

and by using the below code; i was able to log only the @usernames

=SUBSTITUTE("{{LinkToProfile}}","http://twitter.com/","")

Enjoy the recipe

Log New Twitter Followers Usernames only in Excel sheet with Google Drive

[aesop_image imgwidth=”100%” img=”https://amged.me/wp-content/uploads/2015/12/000003.png” alt=”ifft recipe twitter followers” align=”center” lightbox=”off” captionposition=”center”]

[Tweet “Easily export your followers usernames to excel sheet via @Amged”]

Leave a Reply

Your email address will not be published. Required fields are marked *