Step 2: Connect Google Sheets for Output Storage

Prepare the destination sheet where content ideas will be appended.

1. Add the Append Ideas to Sheets node and set Operation to append.
2. Set Document to Youtube Video/Creators and Sheet to Youtube Content Idea.
3. Map the columns using the following expressions: title → {{ $json.title }}, whyGoodIdea → {{ $json.whyGoodIdea }}, engagementPotential → {{ $json.engagementPotential }}.
4. Credential Required: Connect your googleSheetsOAuth2Api credentials.

Step 3: Set Up Batching and Rate Control

Control how records are processed and include a pause between API calls.

1. Add the Iterate Video Records node after YouTube Row Watcher to process records in batches.
2. Connect Iterate Video Records to Pause Between Calls to pace API requests.
3. Leave Pause Between Calls settings at default unless you need a custom delay.
4. Confirm the loop: Append Ideas to Sheets → Iterate Video Records to continue processing subsequent items.

Step 4: Configure Transcript and Comment Retrieval

Fetch transcript and comment data from Dumpling and normalize comment text.

1. In Fetch Transcript via Dumpling, set URL to https://app.dumplingai.com/api/v1/get-youtube-transcript and Method to POST.
2. Set JSON Body to { "videoUrl": "{{ $json['Video Link'] }}" } and enable Send Body.
3. Credential Required: Connect your httpHeaderAuth credentials in Fetch Transcript via Dumpling.
4. In Retrieve Comments via Dumpling, set URL to https://app.dumplingai.com/api/v1/youtube/video/comments and Method to POST.
5. Set JSON Body to { "url": "{{ $('YouTube Row Watcher').item.json['Video Link'] }}" }.
6. Credential Required: Connect your httpHeaderAuth credentials in Retrieve Comments via Dumpling.
7. In Parse Comment Text, keep the provided JavaScript to output a content field for each comment.
8. In Aggregate Comment Text, set Include to specifiedFields, Fields to Include to content, and Destination Field Name to comment.

Step 5: Set Up GPT Video Idea Generator

Use OpenAI to generate structured content ideas from the transcript, comments, and search topic.

1. Add GPT Video Idea Generator and set Model to chatgpt-4o-latest.
2. Keep JSON Output enabled to ensure a parsable response.
3. Confirm the user message inputs include the expressions: {{ JSON.stringify($json.comment) }}, {{ $('Fetch Transcript via Dumpling').item.json.transcript }}, and {{ $('YouTube Row Watcher').item.json['search topic'] }}.
4. Credential Required: Connect your openAiApi credentials.

Step 6: Configure Output Actions

Split the generated idea list, store results, and email a summary.

1. In Explode Idea List, set Field to Split Out to message.content.contentIdeas.
2. Ensure Explode Idea List connects to Append Ideas to Sheets so each idea becomes a new row.
3. In Dispatch Ideas Email, set Send To to [YOUR_EMAIL] and verify the Subject is New YouTube Content Ideas Based on Video Analysis.
4. Keep the Message text as provided or customize it for your brand voice.
5. Credential Required: Connect your gmailOAuth2 credentials in Dispatch Ideas Email.

Step 7: Test and Activate Your Workflow

Validate the full flow from trigger to output before enabling it in production.

1. Manually add a new row to the trigger sheet to fire YouTube Row Watcher.
2. Run the workflow once and confirm Fetch Transcript via Dumpling, Retrieve Comments via Dumpling, and GPT Video Idea Generator return data.
3. Verify Append Ideas to Sheets adds new rows with title, whyGoodIdea, and engagementPotential.
4. Check that Dispatch Ideas Email sends the summary email successfully.
5. When everything looks correct, toggle the workflow to Active.