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”]