Save Specific Twitter Tweet To Excel Spreadsheet With Azure Logic App

This article helps you to learn how to create a Logic App between the Twitter and Excel Spreadsheet. Logic App is a cloud-based service. It allows us to react to an event in one service (such as SharePoint online) and do something with the data from that event into another one Service (such as Twitter). It makes it practical and simple for line-of-business. The users build workflows that automatically do some business tasks and processes across applications and services. We can connect our business-critical apps and services with Azure Logic Apps, automating your workflows without writing a single line of code.

Azure Logic Apps

Logic App is a cloud-based service. It allows us to react to an event in one service (such as SharePoint online) and do something with the data from that event into another Service (such as Twitter). It makes it practical and simple for business processes. The users build workflows that automatically do some business tasks and processes across applications and services. We can connect our business-critical apps and services with Azure Logic Apps, automating our workflows without writing a single line of code.

Before reading this article, please go through some important article links, mentioned below.

Here, we can save specific Tweets to Excel Online automatically.

  • Twitter
    Twitter is an online news and social networking service where users post and interact with messages, "tweets", restricted to 280 characters. Registered users can post tweets, but those who are unregistered can only read them. Log in here.
  • Excel
    Microsoft Excel a spreadsheet developed by Microsoft for Windows, macOS, Android, and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.
How to create a Logic Flow for saving Specific Tweets to the Excel spreadsheet

Here, we can connect Twitter and Excel.

Prerequisites

  • Microsoft Azure Account.
  • Twitter Account.
  • OneDrive-Excel Online.

Follow the below steps to build a Work Flow using a template.

Step 1

Login to https://portal.azure.com/

In the dashboard, choose to create a resource and click on Integration. Now, choose Logic App,

Save Specific Twitter Tweet To Excel Spreadsheet With Azure Logic App

Step 2

Enter the name you want to assign to the logic, choose the subscription, resource group where you organize related resources, and location where your logic app is stored. Then, click on "Create".

 Save Specific Twitter Tweet To Excel Spreadsheet With Azure Logic App

Here is the dashboard. Click on Logic App Designer.

 Save Specific Twitter Tweet To Excel Spreadsheet With Azure Logic App

Step 3

Now, click on the Blank Logic App.

Save Specific Twitter Tweet To Excel Spreadsheet With Azure Logic App

Step 4

Configure the data by signing in to the Twitter and Excel Online.

  • Search Twitter on the search bar.

    Save Specific Twitter Tweet To Excel Spreadsheet With Azure Logic App
  • Choose the Triggers

    Save Specific Twitter Tweet To Excel Spreadsheet With Azure Logic App
  • Next, we sign in

    Save Specific Twitter Tweet To Excel Spreadsheet With Azure Logic App
  • We give permission to access our accounts.

    Save Specific Twitter Tweet To Excel Spreadsheet With Azure Logic App
  • Next, set the Specific Keyword ( Eg. Azure) which you want to store that specific tweet to Excel Sheet. And then, give Time interval and Frequency for checking the workflow as one minute.

    Save Specific Twitter Tweet To Excel Spreadsheet With Azure Logic App

Step 5

  • Next, search Excel Online.

    Save Specific Twitter Tweet To Excel Spreadsheet With Azure Logic App
  • Then, choose the Action for the workflow.

    Save Specific Twitter Tweet To Excel Spreadsheet With Azure Logic App
  • Next, we sign in to OneDrive

    Save Specific Twitter Tweet To Excel Spreadsheet With Azure Logic App
  • We give permission to access our accounts.

    Save Specific Twitter Tweet To Excel Spreadsheet With Azure Logic App
  • Next, Choose File Name and Table Name for saving the Outlook mail from the Outlook mail.

    Save Specific Twitter Tweet To Excel Spreadsheet With Azure Logic App
  • Then, choose the Fields you want.

    Save Specific Twitter Tweet To Excel Spreadsheet With Azure Logic App
  • The final workflow will be like this.

    Save Specific Twitter Tweet To Excel Spreadsheet With Azure Logic App

Step 6

Now we save and run the workflow and run it.

Save Specific Twitter Tweet To Excel Spreadsheet With Azure Logic App

Output

Send a Twitter with #Azure Keyword

Save Specific Twitter Tweet To Excel Spreadsheet With Azure Logic App

Now the Tweet should be saved in Excel.

Save Specific Twitter Tweet To Excel Spreadsheet With Azure Logic App

Summary

I hope, you understood how to save the Specific Tweet to Excel automatically and how to run it. Stay tuned for more Logic App articles.