YouTube Video Converter & Google Sheets Logger - n8n Workflow

• Content creators needing a simple tool to manage and log video downloads.


• Automation engineers looking for practical n8n templates integrating external APIs like RapidAPI.


• Users who need a custom, self-hosted solution for media processing and logging.


• Developers interested in customizing an n8n workflow for video extraction.

This powerful n8n workflow provides a streamlined solution for converting YouTube video links into high-quality downloadable files (MP4 and MP3). The core mechanism uses an external RapidAPI service to handle the conversion and extraction of links. By utilizing the 'On form submission' n8n trigger, users can simply paste a YouTube URL to initiate the process. A key feature of this n8n automation is the systematic logging of every successful conversion attempt, including links for MP4 1080p, 720p, 360p, and a separate MP3 link, all stored securely in a dedicated Google Sheet. This makes it an ideal template for managing conversion data and monitoring usage. Setting up this n8n node sequence is straightforward and highly effective.

This n8n workflow begins execution immediately upon receiving input via the built-in form, which functions as the n8n trigger.

1. Initiation (On form submission): The n8n trigger fires when a user submits a YouTube URL through the hosted form interface.


2. API Conversion (HTTP Request n8n node): The submitted URL is passed to the 'HTTP Request' n8n node. This node connects to the RapidAPI endpoint for YouTube video downloading, requesting the conversion links. It sends the YouTube URL in the request body and uses specific headers for RapidAPI key authentication.


3. Success Check (If n8n node): The workflow then proceeds to an 'If' n8n node. This essential flow control step checks the API response data, specifically looking for success: true. If the RapidAPI call failed, the workflow terminates, ensuring that only valid conversion data proceeds.


4. Data Logging (Google Sheets n8n node): If successful, the final n8n node, 'Google Sheets', takes the extracted download links (for various resolutions and MP3) and the original URL. It appends a new row to the configured spreadsheet, creating a permanent, structured log of the conversion results. This completes the automated n8n workflow.

To deploy this n8n workflow template, follow these steps:

1. Import: Copy the provided JSON and import it directly into your n8n instance via the 'Workflows' menu.


2. RapidAPI Configuration (HTTP Request n8n node):

1. Google Sheets Credentials:

1. Google Sheets Document ID:

1. Activation: Save the n8n workflow and activate it using the toggle switch. Access the live form URL provided by the 'On form submission' n8n trigger to start testing.

This n8n workflow utilizes four primary nodes to execute the conversion and logging process:

On form submission (n8n trigger):
Function: Acts as the entry point and n8n trigger for the entire workflow, providing a web form for users to input the YouTube URL.
Key Configuration: Defines one required field labeled 'URL'.
HTTP Request (n8n node):
Function: Communicates with the external RapidAPI service to request conversion links based on the submitted YouTube URL.
Key Configuration: Uses a POST method, multipart-form-data content type, and requires x-rapidapi-key and x-rapidapi-host headers for authentication.
If (n8n node):
Function: Directs the flow based on API response success. It ensures resource logging only occurs if the conversion link extraction was successful.
Key Configuration: Condition checks if {{ $json.success }} evaluates to true.
Google Sheets (n8n node):
Function: Appends the conversion results (original URL, MP4 links, and MP3 link) into a structured row in a Google spreadsheet.
Key Configuration: Operation set to 'append'. Data mapping explicitly defines columns for 'Url', 'Mp4 360p', 'Mp4 720', 'Mp4 1080', and 'Mp3', sourcing values directly from the successful RapidAPI response object ($json.medias[...]).