Elvir ThaqiAI & Automation Engineer

Loading0%

Project 01

Podcast Guest Management Automation

An automated podcast guest management system that connects Asana, n8n, Google Drive and email to manage guest submissions, documents, approvals and communication throughout the podcast production process.

The problem

Every podcast guest goes through the same steps: a submission, a review, a booking, a recording and a release. Done by hand, that means copying the same details between a form, a task board, a shared drive and an inbox, and remembering which email goes to whom and when.

What I built

I built the process in n8n around Asana. Each guest is a task with fields for the name, the email address and the release date, and each email the guest receives is a subtask. When someone on the team completes a subtask, Asana calls a webhook, n8n reads the subtask and its parent task, and sends the matching email from the podcast inbox.

The email text lives in the notes of the subtask, with placeholders for the guest name, dates and links. The team can change the wording in Asana without touching the workflow.

How it works

Some emails go out straight away and some wait. A recording reminder waits until the day before the recording. The release email waits until the release date at 9 AM New York time, then reads the task again so that any late changes are used.

For the clips email, the workflow finds the guest's folder in Google Drive by the year and by the release date and guest name, shares it as view only with the guest's email address, and puts the link in the email. A separate watcher checks the inbox, and when a guest replies to that email it posts a comment on the guest's task and tags the people who handle it.

Guard rails

If a field is empty, an email address is not valid or the folder cannot be found, nothing is sent. The workflow posts the reason as a comment on the subtask instead, so the team knows exactly what to fix before completing the subtask again.

How it starts
A person submits a guest form or completes an Asana task.
Where results go
Primarily other systems (Asana, Google Drive), with automated email communication to people.
Stack
n8n, Asana

All projects