Spotifyの音楽をGoogleドライブにダウンロードし、自動のにテーブルに記録
上級
これはFile Management分野の自動化ワークフローで、25個のノードを含みます。主にIf, Code, Wait, FormTrigger, GoogleDriveなどのノードを使用。 Spotifyの楽曲をGoogleデリカレントダウンロードし、ダウンロード履歴をテーブルに自動記録
前提条件
- •Google Drive API認証情報
- •ターゲットAPIの認証情報が必要な場合あり
- •Google Sheets API認証情報
カテゴリー
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
"meta": {
"instanceId": "60c025075753afcab9f803964b4caaca9402f435deb4efafbb8e3b93b54d8752"
},
"nodes": [
{
"id": "8b589726-cc0e-47e1-8ada-b098d551787c",
"name": "フォーム送信時",
"type": "n8n-nodes-base.formTrigger",
"position": [
-200,
0
],
"webhookId": "00b30d60-ba60-4b3c-a08b-b9f8f7c0dc75",
"parameters": {
"options": {},
"formTitle": "Spotify Music Downloader",
"formFields": {
"values": [
{
"fieldLabel": "Link",
"placeholder": "https://open.spotify.com/track/abcd44?si=ZXw&nd=1&dlsi=b3a",
"requiredField": true
}
]
},
"formDescription": "Paster link of spotify music"
},
"typeVersion": 2.2
},
{
"id": "fe66d327-610b-4c07-955b-4f6a922f14a0",
"name": "HTTP リクエスト",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueRegularOutput",
"position": [
240,
-20
],
"parameters": {
"url": "https://spotify-downloader11.p.rapidapi.com/spotify-downloader.php",
"method": "POST",
"options": {},
"sendBody": true,
"contentType": "multipart-form-data",
"sendHeaders": true,
"bodyParameters": {
"parameters": [
{
"name": "url",
"value": "={{ $json.Link }}"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "x-rapidapi-host",
"value": "spotify-downloader11.p.rapidapi.com"
},
{
"name": "x-rapidapi-key",
"value": "your key"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "a519e85f-dfa5-436d-833e-31d5ed3cb6f1",
"name": "条件分岐",
"type": "n8n-nodes-base.if",
"position": [
-20,
0
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "d5b4a26a-13eb-487a-9edd-ac831ce8ca1f",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $json.Link }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "f24f1513-b5ab-4c6a-8f57-2d2a1bb03954",
"name": "条件分岐1",
"type": "n8n-nodes-base.if",
"position": [
500,
20
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "d5b4a26a-13eb-487a-9edd-ac831ce8ca1f",
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.status }}",
"rightValue": "success"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "429a1eb2-ddee-4d3d-85c4-b755c999febe",
"name": "音楽ダウンロード",
"type": "n8n-nodes-base.httpRequest",
"position": [
840,
-400
],
"parameters": {
"url": "={{ $json.download_url }}",
"options": {}
},
"typeVersion": 4.2
},
{
"id": "062222fa-77d3-493b-8f4b-de96590c3c95",
"name": "Google ドライブ",
"type": "n8n-nodes-base.googleDrive",
"position": [
1120,
-420
],
"parameters": {
"name": "data",
"driveId": {
"__rl": true,
"mode": "id",
"value": "1MH4rVD9lziY-acugKQFoitbE6Gv5vdLl"
},
"options": {},
"folderId": {
"__rl": true,
"mode": "list",
"value": "1MH4rVD9lziY-acugKQFoitbE6Gv5vdLl",
"cachedResultUrl": "l",
"cachedResultName": "spotify to mp3"
},
"inputDataFieldName": "=data"
},
"credentials": {
"googleDriveOAuth2Api": {
"id": "qEkQ8MFn0uSHgAqY",
"name": "Google Drive account"
}
},
"typeVersion": 3
},
{
"id": "1d754442-11ec-4e30-95ff-01b53491f877",
"name": "Google スプレッドシート",
"type": "n8n-nodes-base.googleSheets",
"position": [
2500,
0
],
"parameters": {
"columns": {
"value": {
"URL": "={{ $('On form submission').item.json.Link }}",
"Size": "={{ $('Code').item.json.fileSizeInMb }} MB",
"Status": "Success",
"Created at": "={{ $now.format('dd-MM-yyyy') }}",
"Download Link": "={{ $('Google Drive').item.json.webContentLink }}",
"Web View Link": "={{ $('Google Drive').item.json.webViewLink }}"
},
"schema": [
{
"id": "URL",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Download Link",
"type": "string",
"display": true,
"required": false,
"displayName": "Download Link",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Web View Link",
"type": "string",
"display": true,
"required": false,
"displayName": "Web View Link",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Size",
"type": "string",
"display": true,
"required": false,
"displayName": "Size",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Created at",
"type": "string",
"display": true,
"required": false,
"displayName": "Created at",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"URL"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "id",
"value": "15jM_yCs_m72wcoDDYr6wsiXzADgj1efLZDgE3nXbmOg"
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "qUtlCnYpk7bXXaYp",
"name": "Google Sheets account 3"
}
},
"typeVersion": 4.6
},
{
"id": "3b745c8b-bbfa-4302-a93f-6ea24d7915da",
"name": "コード",
"type": "n8n-nodes-base.code",
"position": [
1800,
-320
],
"parameters": {
"jsCode": "function kbToMb(kb) {\n return (kb / 1024).toFixed(2); // Convert KB to MB\n}\n\nfunction bytesToKb(bytes) {\n return bytes / 1024; // Convert Bytes to KB\n}\n\n// Get the file size in bytes from the input (from the Google Drive node)\nlet fileSizeInBytes = $('Google Drive').first().json.size;\n\n// Convert bytes to KB first\nlet fileSizeInKb = bytesToKb(fileSizeInBytes);\n\n// Then convert KB to MB\nlet fileSizeInMb = kbToMb(fileSizeInKb);\n\nlet outputData = {\n fileName: $input.first().json.name,\n fileSizeInMb: fileSizeInMb\n};\n\n// Return an array containing the output data\nreturn [{ json: outputData }];\n"
},
"typeVersion": 2
},
{
"id": "e148bc42-ecb2-44af-b8f4-4b713f4b427c",
"name": "Google スプレッドシート1",
"type": "n8n-nodes-base.googleSheets",
"position": [
1440,
200
],
"parameters": {
"columns": {
"value": {
"URL": "={{ $('On form submission').item.json.Link }}",
"Size": "=N/A",
"Status": "=failed",
"Created at": "={{ $now.format('dd-MM-yyyy') }}",
"Download Link": "N/A",
"Web View Link": "=N/A"
},
"schema": [
{
"id": "URL",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Download Link",
"type": "string",
"display": true,
"required": false,
"displayName": "Download Link",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Web View Link",
"type": "string",
"display": true,
"required": false,
"displayName": "Web View Link",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Size",
"type": "string",
"display": true,
"required": false,
"displayName": "Size",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Created at",
"type": "string",
"display": true,
"required": false,
"displayName": "Created at",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"URL"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "id",
"value": "15jM_yCs_m72wcoDDYr6wsiXzADgj1efLZDgE3nXbmOg"
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "qUtlCnYpk7bXXaYp",
"name": "Google Sheets account 3"
}
},
"typeVersion": 4.6
},
{
"id": "6885550a-a1e5-46cf-835e-aad57c3a051a",
"name": "待機",
"type": "n8n-nodes-base.wait",
"position": [
1000,
240
],
"webhookId": "70524744-1b73-4068-941a-f55c8c8feb9c",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "910f0b8d-7e3a-4dd3-932e-453ba5d487d7",
"name": "待機1",
"type": "n8n-nodes-base.wait",
"position": [
2240,
-320
],
"webhookId": "ac0265ba-f888-4d4b-a88f-a5a94f538b79",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "c4302364-9c96-4f6c-b4ca-85083012a0e8",
"name": "Google スプレッドシート2",
"type": "n8n-nodes-base.googleSheets",
"position": [
1460,
-500
],
"parameters": {
"columns": {
"value": {
"URL": "={{ $('On form submission').item.json.Link }}"
},
"schema": [
{
"id": "URL",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Download Link",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Download Link",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Web View Link",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Web View Link",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Size",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Size",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Created at",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Created at",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"URL"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "id",
"value": "15jM_yCs_m72wcoDDYr6wsiXzADgj1efLZDgE3nXbmOg"
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "qUtlCnYpk7bXXaYp",
"name": "Google Sheets account 3"
}
},
"typeVersion": 4.6
},
{
"id": "a622eaef-5494-4294-8a2d-90f6ace4673d",
"name": "付箋",
"type": "n8n-nodes-base.stickyNote",
"position": [
-980,
-300
],
"parameters": {
"width": 560,
"height": 1020,
"content": "# Spotify Music Downloader Flow\n\n**Description**: \nThis workflow allows users to download music from Spotify by pasting a track URL, and then saves the file to Google Drive, logging the details in a Google Sheet.\n\n---\n\n### Node-by-Node Explanation:\n\n1. **On form submission**: \n - Triggers when a user submits a Spotify track URL via a form.\n\n2. **HTTP Request**: \n - Sends a request to the Spotify downloader API to fetch the music download link.\n\n3. **If (Link check)**: \n - Validates that a valid link is provided in the form submission.\n\n4. **If1 (Success check)**: \n - Checks if the download link retrieval was successful.\n\n5. **Download music**: \n - Downloads the music file from the provided URL.\n\n6. **Google Drive**: \n - Uploads the downloaded music file to Google Drive.\n\n7. **Google Sheets**: \n - Logs the success data (download link, file size, etc.) to Google Sheets.\n\n8. **Code**: \n - Calculates the file size in MB from the downloaded file's size in bytes.\n"
},
"typeVersion": 1
},
{
"id": "a6c8f56d-3cd2-4b8e-85d7-98f6d02275ce",
"name": "付箋1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-320,
-200
],
"parameters": {
"height": 340,
"content": "**On form submission**: \n - **Description**: This node is triggered when a user submits a Spotify track URL via a form. \n - **Purpose**: Collects the URL input from the user to start the process."
},
"typeVersion": 1
},
{
"id": "708465a5-c968-459d-844b-27b1c05f39dd",
"name": "付箋2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-60,
-200
],
"parameters": {
"height": 340,
"content": " **If (Link check)**: \n - **Description**: Validates that a valid Spotify track URL is provided in the form submission. \n - **Purpose**: Ensures that the form input is not empty and contains a valid URL before proceeding."
},
"typeVersion": 1
},
{
"id": "43722f14-157e-4ba4-8d18-26681a8eaa6f",
"name": "付箋3",
"type": "n8n-nodes-base.stickyNote",
"position": [
200,
-200
],
"parameters": {
"height": 340,
"content": "**HTTP Request**: \n - **Description**: Sends a request to the Spotify downloader API to retrieve the music file. \n - **Purpose**: Fetches the music file download link using the provided Spotify URL."
},
"typeVersion": 1
},
{
"id": "a2344ebe-f7bf-4a88-8295-1ff777c25d09",
"name": "付箋4",
"type": "n8n-nodes-base.stickyNote",
"position": [
460,
-200
],
"parameters": {
"height": 340,
"content": "**If1 (Success check)**: \n - **Description**: Verifies whether the HTTP request for downloading the music was successful. \n - **Purpose**: Ensures that the API response was positive (successful retrieval of the music file)."
},
"typeVersion": 1
},
{
"id": "f2ab9746-ce9c-416b-a0c8-9be6378ce288",
"name": "付箋5",
"type": "n8n-nodes-base.stickyNote",
"position": [
760,
-560
],
"parameters": {
"height": 320,
"content": " **Download music**: \n - **Description**: Downloads the music file from the provided Spotify URL. \n - **Purpose**: Initiates the actual download of the track to be stored on Google Drive."
},
"typeVersion": 1
},
{
"id": "697e5b8c-887b-4c6d-9c25-4a59f56a663a",
"name": "付箋6",
"type": "n8n-nodes-base.stickyNote",
"position": [
1080,
-600
],
"parameters": {
"height": 360,
"content": "**Google Drive**: \n - **Description**: Uploads the downloaded music file to Google Drive for storage. \n - **Purpose**: Saves the music file in Google Drive, making it available for future access.\n"
},
"typeVersion": 1
},
{
"id": "2a4e9899-d4f4-475a-a36b-9bc45f2ee5ff",
"name": "付箋7",
"type": "n8n-nodes-base.stickyNote",
"position": [
960,
20
],
"parameters": {
"height": 400,
"content": "**Wait**: \n - **Description**: Introduces a delay between processes. \n - **Purpose**: Ensures that there is enough time for the music file to upload to Google Drive before proceeding with logging the data to Google Sheets.\n"
},
"typeVersion": 1
},
{
"id": "56642ab2-bdbb-457c-beaf-115677a39e2a",
"name": "付箋8",
"type": "n8n-nodes-base.stickyNote",
"position": [
1420,
-720
],
"parameters": {
"width": 280,
"height": 380,
"content": "7. **Google Sheets**: \n - **Description**: Logs the success details, such as the download link, file size, and timestamp to a Google Sheet. \n - **Purpose**: Creates a record of the download, making it easy to track and manage all downloaded files."
},
"typeVersion": 1
},
{
"id": "3a0fa583-5bc3-4e7e-8cdd-8735cced94ab",
"name": "付箋9",
"type": "n8n-nodes-base.stickyNote",
"position": [
1740,
-600
],
"parameters": {
"height": 420,
"content": "**Code**: \n - **Description**: Calculates the file size of the downloaded music in MB. \n - **Purpose**: Converts the file size from bytes to MB and formats the output data."
},
"typeVersion": 1
},
{
"id": "d2b90077-85eb-4989-866a-035c96794925",
"name": "付箋10",
"type": "n8n-nodes-base.stickyNote",
"position": [
2440,
-260
],
"parameters": {
"height": 380,
"content": "**Google Sheets1**: \n - **Description**: Logs successful information, such as the URL and download link, to the primary Google Sheet. \n - **Purpose**: Records the successful download details (e.g., the URL, download link, size, etc.) in the first sheet to track the completed process. It includes data like file size, download status, and date.\n"
},
"typeVersion": 1
},
{
"id": "9f3a15c7-1577-4a55-959c-52a00e6640e6",
"name": "付箋11",
"type": "n8n-nodes-base.stickyNote",
"position": [
2160,
-560
],
"parameters": {
"height": 380,
"content": "**Wait1**: \n - **Description**: Another wait node, used to introduce additional delays as needed in the flow. \n - **Purpose**: Similar to the previous \"Wait\" node, this node helps manage timing between processes, ensuring smooth execution without overwhelming other parts of the system.\n"
},
"typeVersion": 1
},
{
"id": "859207a9-1ae6-442b-86a2-c0e931d00482",
"name": "付箋12",
"type": "n8n-nodes-base.stickyNote",
"position": [
1380,
-20
],
"parameters": {
"width": 260,
"height": 380,
"content": "**Google Sheets2**: \n - **Description**: Logs the failed downloads (if any) to the secondary Google Sheet, with status \"failed.\" \n - **Purpose**: Creates a record in a separate Google Sheet for any failed downloads, allowing users to track unsuccessful attempts, including the URL submitted and the reason (failure)."
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"a519e85f-dfa5-436d-833e-31d5ed3cb6f1": {
"main": [
[
{
"node": "fe66d327-610b-4c07-955b-4f6a922f14a0",
"type": "main",
"index": 0
}
],
[]
]
},
"f24f1513-b5ab-4c6a-8f57-2d2a1bb03954": {
"main": [
[
{
"node": "429a1eb2-ddee-4d3d-85c4-b755c999febe",
"type": "main",
"index": 0
}
],
[
{
"node": "6885550a-a1e5-46cf-835e-aad57c3a051a",
"type": "main",
"index": 0
}
]
]
},
"3b745c8b-bbfa-4302-a93f-6ea24d7915da": {
"main": [
[
{
"node": "910f0b8d-7e3a-4dd3-932e-453ba5d487d7",
"type": "main",
"index": 0
}
]
]
},
"6885550a-a1e5-46cf-835e-aad57c3a051a": {
"main": [
[
{
"node": "e148bc42-ecb2-44af-b8f4-4b713f4b427c",
"type": "main",
"index": 0
}
]
]
},
"910f0b8d-7e3a-4dd3-932e-453ba5d487d7": {
"main": [
[
{
"node": "1d754442-11ec-4e30-95ff-01b53491f877",
"type": "main",
"index": 0
}
]
]
},
"062222fa-77d3-493b-8f4b-de96590c3c95": {
"main": [
[
{
"node": "c4302364-9c96-4f6c-b4ca-85083012a0e8",
"type": "main",
"index": 0
}
]
]
},
"fe66d327-610b-4c07-955b-4f6a922f14a0": {
"main": [
[
{
"node": "f24f1513-b5ab-4c6a-8f57-2d2a1bb03954",
"type": "main",
"index": 0
}
]
]
},
"429a1eb2-ddee-4d3d-85c4-b755c999febe": {
"main": [
[
{
"node": "062222fa-77d3-493b-8f4b-de96590c3c95",
"type": "main",
"index": 0
}
]
]
},
"c4302364-9c96-4f6c-b4ca-85083012a0e8": {
"main": [
[
{
"node": "3b745c8b-bbfa-4302-a93f-6ea24d7915da",
"type": "main",
"index": 0
}
]
]
},
"8b589726-cc0e-47e1-8ada-b098d551787c": {
"main": [
[
{
"node": "a519e85f-dfa5-436d-833e-31d5ed3cb6f1",
"type": "main",
"index": 0
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
上級 - ファイル管理
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
YouTube動画をMP3に変換する（RapidAPI、Google Drive保存、Sheetsログ記録を使用）
YouTube動画をMP3に変換するには、RapidAPI、Google Driveの保存、Sheetsでのログ記録を使用します
If
Code
Wait
+
If
Code
Wait
19 ノードEvoort Solutions
ファイル管理
TikTokの動画を署名なしでGoogle Driveにダウンロードし、テーブルに自動記録
TikTokの動画を無 watermark 版でGoogleドライブにダウンロードし、自動のにテーブルにログを記録
If
Wait
Form Trigger
+
If
Wait
Form Trigger
19 ノードEvoort Solutions
コンテンツ作成
Instagram動画をフォームトリガーでGoogle Driveにダウンロードし、テーブルに記録
Instagram動画をフォームトリガーでGoogle Driveへダウンロードし、そしてテーブルへ記録
If
Wait
Form Trigger
+
If
Wait
Form Trigger
19 ノードEvoort Solutions
その他
画像 Transform AI、Google Sheets、および Google Driveを使用して画像を生成し、アップロードする
画像変換GPT、Google Sheets、Driveを使用して画像の生成・アップロード
If
Code
Wait
+
If
Code
Wait
23 ノードEvoort Solutions
コンテンツ作成
TikTok の文字起こし
RapidAPIとGoogle Sheetsを使ってTikTok動画の自動文字起こし
If
Code
Wait
+
If
Code
Wait
21 ノードEvoort Solutions
コンテンツ作成
Facebook動画をGoogleドライブにダウンロードし、自動のに表に記録する
Facebookの動画をGoogleドライブにダウンロードし、テーブルの自動記録にダウンロードログを記録
If
Wait
Form Trigger
+
If
Wait
Form Trigger
19 ノードSk developer
ファイル管理
