Automatically Save Twitter Data to Google Sheets with Microsoft Flow

Voice of the Customer Series – Part 1

In this tutorial I’ll demonstrate how to set up a Microsoft Flow to automatically save tweets that mention your brand, product or service to a Google Sheet.

No alt text provided for this image

In a future post I’ll show how you can then explore this Twitter data and perform sentiment analysis on the tweets. This will allow you to evaluate how positively or negatively users are tweeting about your brand.

No alt text provided for this image

To start, navigate to the Microsoft Flow homepage and select the “Save Tweets to a Google Sheet” template.

No alt text provided for this image

Once you select this template, you’ll need to connect your Twitter and Google accounts. After you’ve authenticated these accounts, click continue.

No alt text provided for this image

Outside of Microsoft Flow, you’ll also need to set up a Google Sheet with headings for the Twitter data fields you’ll be collecting. I decided to collect the below fields:

No alt text provided for this image

Next, you’ll enter the search terms used to save tweets. I’m going to be analyzing tweets mentioning the Vancouver car share provider @EvoCarShare,but you can select whichever search terms you’d like to track.

No alt text provided for this image

Select the Google Sheet file in the “Insert Row” user interface, and then map each of your required Twitter data fields to the Google Sheet columns below. Microsoft Flow makes this incredibly easy, as the interface shows all of the fields available to you. Once you’ve mapped all of your required fields, press save.

No alt text provided for this image

Once you’ve enabled your Flow, you can check in the run history and perform a test to ensure the process is working properly. As you can see from the run history and the Google Sheet I set up, the automation is working correctly, and tweets are successfully saved whenever they mention @EvoCarShare.

No alt text provided for this image

In my next post I’ll show how you can add on from this integration, to analyze how positively or negatively users are mentioning your brand on Twitter.

Until then, you can explore the Twitter data in my Google Sheet below!

One comment

  1. […] part 1 of my Voice of the Customer series, I demonstrated how you can set up an automated process to collect tweets that mention your brand […]

Leave a Reply