When a video matching the specified keywords is published on YouTube, analyze it with the Gemini AI worker and log the results in Google Sheets
When a video matching the specified keywords is published on YouTube, analyze it with the Gemini AI worker and log the results in Google Sheets
Launch this workflow to connect
Gemini &
Google Sheets
!
■Overview
Do you spend too much time regularly checking YouTube videos for competitive research or information gathering, then manually compiling their content? This workflow automatically detects when videos related to specified keywords are posted on YouTube, uses Gemini AI to analyze them, and records the results in Google Sheets. Eliminate the effort of manually analyzing videos and streamline your information-gathering process.
■Recommended for
- Marketing professionals who regularly monitor YouTube videos to stay up to date on competitors and market trends
- Anyone looking to use Gemini to analyze YouTube videos more efficiently
- Anyone looking to automate information gathering from video content and improve the productivity of their research tasks
■Benefits of this template
- Automatically analyze videos as soon as they are posted with your specified keywords, reducing the time spent on manual searches and content reviews
- Set AI instructions in advance to standardize analysis criteria, reduce inconsistencies between team members, and prevent processes from becoming dependent on individual expertise
■How the Flowbot works
- First, connect Google Sheets and the YouTube Data API to Yoom
- Next, select the YouTube Data API as the trigger and set the action to “When a video matching a specific keyword is published”
- Finally, launch an AI worker in an operation and create a manual (instruction) to analyze the retrieved YouTube videos, classify their categories, and record the results in Google Sheets
■Customization options
- In the YouTube Data API trigger settings, enter the search keywords you want to monitor. You can specify competitor product names, specific topics, and more
- For the AI worker, select any AI model, such as Gemini 3-Flash, and freely configure instructions (prompts) tailored to your goals, including video summarization, sentiment analysis, and keyword extraction
■Notes
- Connect both the YouTube Data API and Google Sheets to Yoom. You must also connect the tools (apps) used within the AI worker to My Apps.
- You can select a trigger interval of 5, 10, 15, 30, or 60 minutes.
- Note that the shortest available trigger interval varies by plan.
- For basic AI worker setup, see “[AI Workers] How to configure the basic settings.”
- The number of AI workers that can run concurrently, the number of AI workers you can create, and the AI models available to you vary by plan.
- The apps and operations available within AI workers are subject to the same usage limits as Flowbots.
- AI workers consume tasks during test runs just as they do during production runs. For details, see “[AI Workers] How task executions are calculated.”
- AI workers are more likely to perform tasks correctly when you configure their manuals in detail. For details, see “[AI Workers] How to create a manual.”
Check Out Similar Templates!
Notify on Discord when the latest video is published on YouTube.
This is a flow that sends a notification to Discord when the latest video is published on a specified YouTube channel. By centrally managing video information on Discord, it becomes easier to share information among team members, enabling quick responses and improving work efficiency.
When a video matching a specific keyword is published on YouTube, automatically post it on X (Twitter).
This is a business workflow where new videos with specific keywords are automatically posted on X (Twitter) when they are published on YouTube. It reduces manual work and streamlines information dissemination.
See more
About the Apps
Gemini
Related apps
Templates using
Gemini
The workflow involves summarizing form responses with Gemini and automatically adding them to a Google Spreadsheet. This reduces the hassle of data organization and manual input, thereby enhancing operational efficiency.
Analyze the content posted on Google Chat using the Gemini assistant and update the response back to Google Chat.
The content posted on Google Chat is analyzed using the Gemini assistant, and the response is updated back to Google Chat. This allows the person in charge to efficiently handle even advanced questions, leading to improved productivity for the entire team.
Analyze the content posted on Microsoft Teams using the Gemini assistant and update the response back to Microsoft Teams.
The content posted on Microsoft Teams is analyzed using the Gemini assistant, and the response is updated again in Microsoft Teams. This flow can improve the efficiency and speed of customer support, leading to enhanced customer satisfaction.
Google Sheets
Related apps
Templates using
Google Sheets
A workflow to generate invoices using Google Sheets with the information entered in the form, and send them after approval.
Once the billing information is filled out in the form, an invoice will be generated using the Google Spreadsheet invoice template. After that, it will undergo approval by the person in charge, and an email will be sent.
This is a flow for adding order information to WooCommerce when a row is added in Google Sheets. This flow significantly reduces manual effort and saves the time previously spent on registration, allowing you to focus on more important tasks and improving productivity.
You can add a new tab to a Google Spreadsheet at the beginning of each month. By being able to add a new sheet to a specific Google Spreadsheet at the start of each month, you can avoid forgetting to add sheets and prevent unnecessary rework.
About the apps you use
Gemini
Yoom allows integration with Gemini's API without any coding. You can use Gemini via API to automatically generate content at various times. It is possible to create AI chatbots by integrating with chat tools or automatically store text generated by Gemini by integrating with database services.
see detailsTemplates
The workflow involves summarizing form responses with Gemini and automatically adding them to a Google Spreadsheet. This reduces the hassle of data organization and manual input, thereby enhancing operational efficiency.
After completing the form, summarize with Gemini and add it to Google Sheets.
Analyze the content posted on Google Chat using the Gemini assistant and update the response back to Google Chat.
The content posted on Google Chat is analyzed using the Gemini assistant, and the response is updated back to Google Chat. This allows the person in charge to efficiently handle even advanced questions, leading to improved productivity for the entire team.
Analyze the content posted on Google Chat using the Gemini assistant and update the response back to Google Chat.
Analyze the content posted on Microsoft Teams using the Gemini assistant and update the response back to Microsoft Teams.
The content posted on Microsoft Teams is analyzed using the Gemini assistant, and the response is updated again in Microsoft Teams. This flow can improve the efficiency and speed of customer support, leading to enhanced customer satisfaction.
Analyze the content posted on Microsoft Teams using the Gemini assistant and update the response back to Microsoft Teams.
Google Sheets
At Yoom, you can utilize the Google Sheets API without any coding. By integrating Sheets with Yoom, you can automate data entry into spreadsheets and automatically create documents based on spreadsheet templates. Additionally, you can sync spreadsheet information with Yoom's database for various applications.
see detailsTemplates
A workflow to generate invoices using Google Sheets with the information entered in the form, and send them after approval.
Once the billing information is filled out in the form, an invoice will be generated using the Google Spreadsheet invoice template. After that, it will undergo approval by the person in charge, and an email will be sent.
A workflow to generate invoices using Google Sheets with the information entered in the form, and send them after approval.
This is a flow for adding order information to WooCommerce when a row is added in Google Sheets. This flow significantly reduces manual effort and saves the time previously spent on registration, allowing you to focus on more important tasks and improving productivity.
Add order information to WooCommerce when a row is added in Google Sheets.
You can add a new tab to a Google Spreadsheet at the beginning of each month. By being able to add a new sheet to a specific Google Spreadsheet at the start of each month, you can avoid forgetting to add sheets and prevent unnecessary rework.
Add a new tab to the Google Spreadsheet at the beginning of each month.
No-Code API Actions
Executable API actions
Flowbot triggers
When a Row Is Added
When a Row Is Updated
Flowbot operations
Generate Content
Upload File
Generate Content (Using File)
Generate Content (URL Context)
Generate Content (Google Search)
Generate Image from Text (Nano Banana)
Set a Value in a Cell
Get Values
Clear Values
Create a New Spreadsheet
Copy a Sheet (Tab)
Add a New Sheet (Tab)
Delete Sheet (Tab)
Replace Values
Update Sheet Name
Delete Rows
Get Spreadsheet Info
Get Sheet Names
Flowbot triggers
There is no action.
Flowbot operations
Generate ContentUpload FileGenerate Content (Using File)Generate Content (URL Context)Generate Content (Google Search)Generate Image from Text (Nano Banana)
Flowbot triggers
When a Row Is AddedWhen a Row Is Updated
Flowbot operations
Set a Value in a CellGet ValuesClear ValuesCreate a New SpreadsheetCopy a Sheet (Tab)Add a New Sheet (Tab)Delete Sheet (Tab)Replace ValuesUpdate Sheet NameDelete RowsGet Spreadsheet InfoGet Sheet NamesApply a Formula to a RangeEnter Values in a RangeEmbed an Image in a CellSort by Specific ColumnHide a SheetAdd a Note to the Specified CellsInsert ColumnsDelete ColumnsWrite Values to Multiple ColumnsAdd RowsMore inspiration for you
Discover step-by-step guides for automating your work using the apps featured in this workflow!
