![google drive download to specific folder google drive download to specific folder](https://i.stack.imgur.com/E8zfL.jpg)
If you are curious to know how the whole thing works, here’re the technical details. We even have a built-in MP3 player embedded inside Google Sheets that will play the latest episode of each podcast when you click the Play button. The app will create a cron job that runs every few hours in the background and download the latest episodes of your favorite podcasts to your Google Drive. You may have to authorize the app once since it needs permission to save files to Google Drive on your behalf.
GOOGLE DRIVE DOWNLOAD TO SPECIFIC FOLDER INSTALL
Go to the Extensions menu and choose Script Editor to open the underlying Google Apps Script file.Ĭhoose the Install function from the list of functions and click Run to install the app. You may use our Apple Podcasts Lookup utility to find the RSS feed of any podcast that is listed on Apple Podcasts. Open the copied spreadsheet, switch to the Subscriptions sheet and enter the RSS feed links of your favorite podcasts in column A. Here’s how you can build your own podcast manager with Google Sheets and Google Drive.Ĭlick here to make a copy of the Google Sheet in your Google account. Inside this folder, it will create sub-folders for each podcast show with the folder name same as the title of the podcast. The app will create a new folder, titled Podcasts in your Google Drive. You can open the MP3 files from your Google Drive or find them directly inside the same Google Sheet. The app will automatically download the latest episodes of each podcast to your Google Drive.
![google drive download to specific folder google drive download to specific folder](https://cdn.businessinsider.nl/wp-content/uploads/2020/10/5f9c269d414b7.png)
You have to place the links of your favorite podcasts in column A of the Google Sheet as shown in the screenshot below. The setup is very simple, the app is completely open-source and you need no programming language. You can specify a list of your favorite podcast shows in Google Sheets and it will automatically download new episodes to your Google Drive in neatly organized folders. This tutorial describes how you can use Google Sheets to build your own podcast manager.
![google drive download to specific folder google drive download to specific folder](http://www.newdesignfile.com/postpic/2014/12/google-drive-app-icon_10454.png)
You use Google Sheets as your own Podcast Manager that will automatically download your favorite podcasts to Google Drive and instantly sync across all your devices.