Flow of the Week: Save tweets to Excel for data analysis

Since our preview release two weeks ago, we have seen a lot of excitement from our users. People have been using flows to automate saving attachments to their SharePoint library, automating approvals, mining data from the Twitter and much more. The Boys and Girls Clubs of Greater Fort Worth, Texas, in a very interesting case study used Microsoft Flow to mine data from Twitter and track the progress of their non-profit program. You can read more about it on the blog post here: https://sway.com/x5EGIMKFiLFEq4pW

In order to mine data from Twitter, start by creating an Excel file on a cloud storage provider, like OneDrive, Dropbox or SharePoint.

Make sure your Excel file has a table defined as shown, you can choose to modify the schema as you see fit.

Next, use the “Save tweets to an Excel file” template to setup your flow to push tweet data into your Excel file.


Use this template


Once you have saved your flow, you should see data being populated in your Excel file.

You can use this data from Excel to build word clouds with PowerBI or do sentiment analysis with Cognitive services.

That’s it for now, stayed tuned for more interesting flow next week.