YouTube Trend Tracking & Google Sheet Logging - n8n Workflow

Content Strategists needing quick market insights.
SEO Specialists tracking competitive video trends.
Data Analysts looking for automated data logging n8n templates.
Users looking to implement a custom n8n trigger via a web form.

Manually monitoring global YouTube trends across various countries and languages can be time-consuming and inefficient. This highly functional n8n workflow provides an automated solution. Utilizing a simple web form as the initiating n8n trigger, users can specify the exact market they wish to investigate. The n8n node sequence then connects directly to the RapidAPI YouTube Trend Finder, fetching real-time data. This n8n workflow is one of the essential n8n templates for content research, ensuring that crucial trending data (including titles, links, and tags) is automatically structured and logged into a Google Sheet for easy analysis, making data collection seamless and repeatable. Every step in this n8n process is optimized for efficiency.

The automation begins with the On form submission n8n trigger. When a user fills out the required fields—Country and Language—and submits the form, the n8n workflow is initiated.

1. API Request: The captured inputs are immediately passed to the Trend Finder Api Request n8n node, which sends a POST request to the RapidAPI endpoint. This request is authenticated using API keys and includes the country and language parameters.


2. Data Extraction: Upon receiving the API response, the Re format output n8n node (a Code node) executes a simple JavaScript snippet to specifically extract the main data array from the API JSON payload, simplifying the structure for the next step in this n8n workflow.


3. Logging Results: Finally, the cleaned data items (each representing a trending video) are processed by the Google Sheets n8n node. This node appends the video details (thumbnail, title, link, and tags) as new rows to the designated Google Sheet document, successfully completing the data logging aspect of this n8n template.

To deploy this powerful n8n workflow, follow these steps:

1. Import: Copy the provided JSON data and paste it into your n8n instance using the 'New' menu > 'Import from JSON'.


2. RapidAPI Key Setup: Locate the Trend Finder Api Request n8n node. You must replace the placeholder value (your key) in the x-rapidapi-key header parameter with your actual key from the YouTube Trend Finder API subscription on RapidAPI.


3. Google Sheets Credential: Configure the Google Sheets n8n node. You will need to set up a new Google API Service Account credential if you haven't already. Ensure this account has editing permissions for the target spreadsheet.


4. Spreadsheet Configuration: In the Google Sheets n8n node, update the Document ID to point to your desired Google Sheet where the trend data should be logged. Ensure the sheet exists with columns matching the data fields (thumbnail, title, link, tags).


5. Form Activation: Once configured, activate the On form submission n8n trigger and share the generated webhook URL (the form URL) with users or access it directly to run the n8n workflow.

On form submission (n8n trigger):
Function: Serves as the public entry point for this n8n workflow, collecting essential input data from the user via a web form.
Key Configuration: Configured to require two fields: country and language.
Trend Finder Api Request (HTTP Request n8n node):
Function: Interfaces with the RapidAPI service to retrieve current YouTube trend data based on the dynamic inputs.
Key Configuration: Uses a POST method. Dynamically passes country and language parameters from the previous n8n node output. Requires setting the x-rapidapi-key header for authentication.
Re format output (Code n8n node):
Function: Cleans the data structure received from the API, specifically extracting the nested data list using JavaScript (return $input.first().json.data), making it suitable for the Google Sheets n8n node.
Google Sheets (n8n node):
Function: Appends the final structured video data to a designated row in the connected Google Sheet spreadsheet.
* Key Configuration: Operation: Append. Maps input fields (thumbnail, title, link, tags) directly to columns in the target sheet (Yt Trend), finalizing the data logging of the n8n workflow.