Constructive Tweet to Excel: Utilizing Azure Logic App & Microsoft Cognitive Service

Introduction

This text lets you discover ways to save solely a constructive tweet a few particular hashtag to an Excel spreadsheet utilizing Microsoft Cognitive Providers in Azure Logic App.

Azure logic apps

Logic App is a cloud-based service. It permits us to react to an occasion in a single service (similar to -SharePoint on-line) and do one thing with the information from that occasion in one other Service (similar to Twitter). It makes it sensible and easy for enterprise processes. The customers construct workflows that mechanically carry out some enterprise duties and processes throughout functions and providers. We are able to join our business-critical apps and providers with Azure Logic Apps, automating our workflows with out writing a single line of code.

Earlier than studying this text, please undergo some essential article hyperlinks, talked about under.

Right here, we are going to see methods to save particular Twitter tweets to Excel On-line mechanically.

Twitter

Twitter is a web based information and social networking service the place customers put up and work together with messages. Posts or “tweets” listed here are restricted to 280 characters. Registered customers can put up tweets, however those that are unregistered can solely learn them. Login right here to make use of Twitter.

Excel

Microsoft Excel is a spreadsheet for Home windows, macOS, Android, and iOS, developed by Microsoft. It options calculation, graphing instruments, pivot tables, and a macro programming language known as Visual Primary for functions.

create a logic stream ?

create a Logic Circulation for saving a particular Tweet to Excel spreadsheet

Right here, we have to hook up with Twitter, Microsoft Cognitive Service (detects Sentiment), and Excel Spreadsheet.

Conditions

• Microsoft Azure Account.
• Twitter Account.
• OneDrive-Excel On-line.

Observe the under steps to construct a Work Circulation utilizing a template.

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

• Within the dashboard, choose “Create a useful resource” and click on on “AI + Machine Studying”. Now, select Textual content Analytics for creating the Cognitive Service.
  
• Enter the identify you need to assign to the Textual content Analytics, select the subscription and useful resource group the place you arrange associated assets, and site the place your logic app saved and the pricing tier. Then, click on on “Create”.
  
• Underneath the Keys, you might have keys for accessing the Textual content Analytics.
  

Step 2. Now, allow us to create the Logic App for detecting the constructive tweet and retailer it on the Excel Spreadsheet.

• Within the dashboard, select to create a useful resource and click on on Integration. Now, select Logic App.
  
• Enter the identify you need to assign to the logic, select the subscription, useful resource group the place you arrange associated assets, and site the place your logic app is saved. Then, click on on “Create”.
  
• Right here is the dashboard. Click on on Logic App Designer.
  

Step 3. Now, click on on the Clean Logic App.

Step 4. Configure the information by signing into Twitter and Excel On-line.

Step 5. Configure the Textual content Analytics for detecting the sentiment of the tweet.

• Seek for Textual content Analytics.
  
• Select the Motion.
  
• After that, verify the situation.
  
• Configure the situation.
  

Step 7

Step 8. Now we save and run the workflow and run it.

Output

Ship a constructive Tweet

Now the Tweet ought to be saved in Excel.

Logic App Analysis

Abstract

I hope you understood methods to save solely a constructive Tweet a few particular hashtag to the Excel spreadsheet mechanically and methods to run it. Keep tuned for extra.