How to analyze sentiment with Hugging Face when a survey is added to Google Sheets and add the results to Google Sheets

For those responsible for efficiently obtaining data on the advertising effectiveness of ongoing campaigns, Hugging Face is a useful business tool. However, the task of collecting and compiling vast amounts of data is extremely time-consuming and labor-intensive. By utilizing Yoom to integrate Google Sheets with Hugging Face, you can quickly gather survey results related to advertisements, perform sentiment analysis on Hugging Face based on the content, and automatically add the result data to Google Sheets. Automating the conventional process reduces the workload of the person in charge of analysis and can lead to improved customer satisfaction. This article explains how to set up an automated flow that analyzes emotions on Hugging Face after surveys are added to Google Sheets and adds the results to Google Sheets, as well as the benefits of implementing it. By incorporating this into your operations, you can achieve more efficient data collection and effective marketing strategies, so be sure to check it out. Recommended for: - Those who want to streamline data analysis with Google Sheets - Those who want to efficiently conduct sentiment analysis using Hugging Face - Managers who want to quickly gather feedback information - Team managers who want to identify challenges in sales activities and improve future processes - Those who feel burdened by manual feedback analysis Benefits and Examples of Integrating Google Sheets and Hugging Face: 1. Efficiently Collect and Analyze Customer Reactions By collecting surveys in Google Sheets and conducting sentiment analysis on Hugging Face, you can easily understand customer satisfaction and dissatisfaction. For example, feedback on products or services can be automatically analyzed by Hugging Face to identify positive and negative opinions. By aggregating the sentiment analysis results in Google Sheets, you can clearly identify what customers are satisfied with and what needs improvement, allowing the person in charge to respond quickly, which is useful when taking measures to improve services. 2. Easily Identify Challenges and Quickly Implement Improvements By aggregating and visualizing Hugging Face's sentiment analysis results in Google Sheets, it becomes easier to identify challenges. For example, by having employees answer a survey about their job satisfaction and analyzing the content with Hugging Face, you can understand the current satisfaction and motivation regarding work by aggregating the results in Google Sheets. From the analysis results, you may be able to identify departments that need support and implement a follow-up system to create a more comfortable working environment. 3. Reduce the Workload of the Person in Charge and Improve Response Efficiency You can automate the tasks of manually transferring survey responses to Hugging Face and adding the sentiment analysis results derived from Hugging Face to Google Sheets. For instance, when manually organizing a large number of survey results, the data to be transferred is also vast, and the person in charge spent a lot of time and effort on the task. By implementing this automated flow, you can minimize the workload of the person in charge by automating the task of transferring survey responses and collecting analysis results. Now, let's create a flowbot using the template "Analyze emotions on Hugging Face when a survey is added to Google Sheets and add the results to Google Sheets." [About Yoom] How to Analyze Emotions on Hugging Face When a Survey is Added to Google Sheets and Add the Results to Google Sheets: This can be achieved by receiving the addition of a survey in Google Sheets using the Google Sheets API, analyzing emotions on Hugging Face using the API provided by Hugging Face, and adding the results to Google Sheets. Generally, programming knowledge is required to achieve this, but it can be easily accomplished without programming knowledge by using the no-code tool Yoom. The steps to complete the flow are as follows: - Integrate Google Sheets and Hugging Face with My Apps - Copy the template - Set triggers for Google Sheets and configure Hugging Face - Turn the trigger ON If you are not using Yoom, please register for free from [here](https://yoom.fun/members/sign_up?_gl=1*jrwzd7*_gcl_au*MTY3NDQ2MzE2MS4xNzE5MzgyMDY4*_ga*NTcxOTYyNzgyLjE3MTkzODIwNjg.*_ga_663H387CXM*MTcyMjQ4ODg2Ny4xNTEuMS4xNzIyNDkwMzk2LjYwLjAuNjYyMDU0NDY0). If you are already using Yoom, please log in.

・Integrate Google Sheets and Hugging Face with My Apps

(1) First, connect Google Sheets to My Apps.
After logging into your Yoom account, click on "My Apps" on the left panel and search for Google Sheets from "New Connection".

‍

‍

Search for the Google Sheets app icon and click on it.

‍

‍

‍

(2) Click "Sign in with Google" to proceed to the account selection screen, and choose the account you want to integrate from the management accounts on the right.
After selection, proceed to the sign-in screen and complete the authentication.
The first connection to Google Sheets is now complete.

(3) Next, integrate the Hugging Face app.
Select Hugging Face in the same way as registering Google Sheets to My Apps.

‍

‍

(4) Enter the "Account Name" and "Access Token", then click [Add].

After clicking, you will be taken to the My Apps screen of your Yoom account with the two apps added.
Now, the two apps are connected to your Yoom account.

・Copy the Template

After confirming that the new connection of the target app to your Yoom account is complete, click the icon for "Try this template" below.

The template will be copied, so click the "OK" button.

‍

‍

Move to the "My Projects" screen of your Yoom account and check the template content.

‍

‍

There are three setup flows.

In this article, we assume that you have created a Google Spreadsheet in advance as shown below and will eventually update the record information (analysis results) of the specified items.
Furthermore, since the analysis results of Hugging Face are output as a comma-separated list, use the Split function to split labels and scores and sequentially reflect them in individual cells.
(As a test, dummy information is inserted and configured. Information is added to the item in the red frame [Score].)

‍

‍

・Google Spreadsheet Trigger Settings

(1) First, set the app trigger for Google Spreadsheet.

‍

‍

From the My Projects on the left side of your Yoom account screen, click "【Copy】When a survey is added in Google Spreadsheet, analyze the sentiment with Hugging Face and add the results to Google Spreadsheet".

‍

‍

After clicking, the template content will be displayed as shown in the screen below.

‍

‍

(2) First, click "When a row is added" as the trigger.
(3) Enter the account information to be linked and click [Next].

‍

(4) On the next screen, enter information such as "Trigger Interval" and "Spreadsheet ID".
Select any of 5 minutes, 10 minutes, 15 minutes, 30 minutes, or 60 minutes for "Trigger Interval".
※Note that the trigger interval varies depending on the plan.

‍

‍

(5) For the "Spreadsheet ID" and "Sheet ID" items, click the input bar to expand the information obtained from the account as "candidates" as shown in the screen below.
Let's also make use of this information.

‍

‍

(6) After entering the information, click [Test] and if there are no issues, click [Save].
In this step, you can obtain information like the one below as output.
The output information can be referenced and utilized in subsequent steps, as noted by "This value can be used in other operations."

‍

‍

Regarding the behavior during testing when setting Google Spreadsheet as an app trigger, please check this page in advance.

・Hugging Face Settings

(1) Next, click the second action "Classify Text".

‍

‍

(2) Enter the account information to be linked and click [Next].

‍

‍

(3) On the next screen, set the "Model Name".
Available models can be checked on this page.

(4) Set the text to be analyzed in "text".
Click the input bar to reference the output obtained from the previous step.
(The image below references the output [Opinion] obtained from the previous step.)

‍

‍

(5) After entering the information, click [Test] and if there are no issues, click [Save].

(6) Finally, click the third action "Update Record".

‍

‍

(7) On the next screen, confirm that the Google Spreadsheet account information is entered.
Scroll down to find the "Database Integration" section and enter the relevant information.
You can expand the information obtained from the linked account as "candidates", so make use of this as well.

‍

‍

(8) After entering the information, click [Next].

(9) On the next screen, set to retrieve records that match the conditions from the specified table in Google Spreadsheet and update the value of the top record in the response results.
As an example, specify 'No.' for the record you want to update in "① Conditions for the record you want to update", set the condition to 'Equal', and set the information that matches the condition to 'No.' (using output).

‍

‍

(10) Next, set the "② Value of the record after update".
The value set in "① Conditions for the record you want to update" will be updated to the value set here.
Click the input bar and set the relevant information.
As shown in the screen below, you can also use the output.
This time, we assume that record information will be added to the score item, so we set the [Score] obtained in the second action in the "Score" section.

‍

‍

(11) After entering the information, click [Test] and if there are no issues, click [Save].
This completes the setup.

By running this flowbot, information will be added to the [Score] in Google Spreadsheet. Furthermore, using the Split function, labels and scores are split and the split results are sequentially reflected in subsequent cells.

‍

‍

・Turn on Trigger

By clicking the red frame "Turn on Trigger" in the screen below, the flowbot will start automatically.

‍

‍

Here is the template used this time

Other Automation Examples Using Google Sheets

There are other examples of automation using Google Sheets available on Yoom, so here are a few introductions.

Retrieve the Number of Blog Articles with RISK EYES When Keywords are Added in Google Sheets

This is a flow that automates the task of transferring the number of blog articles for search keywords from RISK EYES to Google Sheets.
This eliminates the need for manual input on the RISK EYES side and reduces transcription errors.

Prepare options for each question in the form and add them to Google Sheets

Utilize Yoom forms to provide dropdown options for each question and automatically add the responses to Google Sheets.
This reduces the effort of manually transcribing responses, thereby alleviating the burden on the person in charge.

Obtain advertising summary reports from ecforce daily and record them in Google Sheets

This is a recommended flow for teams using ecforce and Google Sheets for advertising operations.
It eliminates the hassle of manual data retrieval and entry, allowing for accurate understanding of advertising performance.
Automating regular report creation also aids in improving marketing strategies.

Summary

By integrating Google Sheets with Hugging Face as introduced this time, you can automate tasks from sentiment analysis of conducted surveys to information gathering of result data.
You can shorten the analysis time of feedback on events and advertisements, allowing related teams to respond appropriately and promptly based on the analysis results.
It becomes a tool that accurately grasps opinions from customers and employees and helps improve services and operations.

Since it can be easily set up without specialized knowledge, please take advantage of Yoom to experience automation through app integration.