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
Also published on Medium.
