Automate Media Requests: Google Sheets to Radarr & Sonarr

Streamline Your Media Management: Automate Requests from Google Sheets to Radarr & Sonarr

Eliminate manual entry and automate your media requests effortlessly with our "Automate Media Requests: Google Sheets to Radarr & Sonarr" workflow. Designed for n8n users and automation enthusiasts, this intelligent system channels requests from a Google Sheets form straight to your media management tools, Radarr and Sonarr, and keeps your requesters informed via Gmail.

What This Workflow Does

• Activates every 5 minutes when a new request is submitted in your specified Google Sheets worksheet.
• Interprets the “Request Type” to determine whether to forward the request to Radarr for movies or Sonarr for TV shows.
• Utilizes the lookup API endpoint to search for the requested media title in Radarr or Sonarr.
• Employs JavaScript filtering to select the optimal match, prioritizing English original titles and exact matches for anime or dubbed requests.
• Automatically submits the chosen movie or series to Radarr or Sonarr with your predefined quality settings and root folder path, initiating an automatic download search.
• Dispatches an email notification via Gmail to inform the requester of the download status.

Use Cases

• Media libraries: Effortlessly expand your collection by automating the request and downloading process.
• Automation engineers: Showcase a seamless integration between various tools to enhance operational efficiency.
• SaaS operators: Offer your users an efficient way to manage and download requested media content reliably and systematically.

Technical Details

• Nodes and Integrations: Google Sheets Trigger, Switch, HTTP Request, Gmail, Code, Sticky Note
• Setup: Integrate your Google Sheets and configure Radarr and Sonarr with API credentials.
• Configuration: Adjust Radarr/Sonarr settings to align with your workflow payload requirements such as qualityProfileId and rootFolderPath.

Experience unparalleled convenience with this n8n automation workflow that takes the complexity out of media request management. Boost productivity by ensuring your Radarr and Sonarr operations run like clockwork, with real-time updates and automated downloads—making your media management truly effortless.