Step 2: Connect Bright Data and Manage Job Status

Trigger the dataset scrape, poll for completion, and route based on job status.

1. In Trigger Reddit Scrape, set URL to https://api.brightdata.com/datasets/v3/trigger and Method to POST.
2. In Trigger Reddit Scrape, set JSON Body to [ { "keyword": "WWDC25", "date": "Past month", "num_of_posts": 100, "sort_by": "New" } ].
3. In Trigger Reddit Scrape → Query Parameters, set dataset_id to [YOUR_ID], include_errors to true, type to discover_new, and discover_by to keyword.
4. In Trigger Reddit Scrape → Headers, set Authorization to Bearer [CONFIGURE_YOUR_TOKEN].
5. In Retrieve Job Status, set URL to =https://api.brightdata.com/datasets/v3/progress/{{ $json.snapshot_id }} and add the same Authorization header.
6. In Status Router, add a rule for ready with Left Value ={{ $json.status }} equals ready, and a rule for running with Left Value ={{ $json.status }} equals running.
7. Configure Delay Interval with Amount set to 15 and route the running path to it so it loops back to Retrieve Job Status.

Step 3: Fetch Results and Classify Post Topics

Once the dataset is ready, load the snapshot, iterate over records, and classify each post topic.

1. In Fetch Dataset Results, set URL to =https://api.brightdata.com/datasets/v3/snapshot/[YOUR_ID] and add Query Parameters with format set to json.
2. In Fetch Dataset Results, add the Authorization header value Bearer [CONFIGURE_YOUR_TOKEN].
3. Use Iterate Records to split records into batches (defaults are fine if you want one batch at a time).
4. In Classify Text Topics, set Input Text to =Post title :{{ $json.title }} Post description : {{ $json.description || " "}}.
5. Ensure Gemini Chat Model A is connected as the language model for Classify Text Topics. Credential Required: Connect your googlePalmApi credentials.
6. In Map Core Fields, map fields like post_id to ={{ $json.post_id }}, url to ={{ $json.url }}, and comments to ={{ $json.comments }}.
7. Keep Fallback Category as a safety path for unclassified records (it sets response to No category).

Step 4: Analyze Comment Sentiment and Merge Results

Split comments, prepare the sentiment payload, run analysis, and consolidate results for output formatting.

1. In Split Comments, set Field To Split Out to comments.
2. In Prepare Comment Payload, map comment to ={{ $json.comment }} and title to ={{ $('Map Core Fields').item.json.title }}.
3. In Analyze Comment Sentiment, set Input Text to =title: {{ $('Iterate Records').first().json.title }} description: {{ $('Iterate Records').first().json.description }} Comments: {{ $json.comment || " "}}.
4. Ensure Gemini Chat Model B is connected as the language model for Analyze Comment Sentiment. Credential Required: Connect your googlePalmApi credentials.
5. In Combine Streams, keep Number Inputs set to 6 to collect all sentiment paths.

Step 5: Format, Filter, and Store Results in Google Sheets

Format the final record, filter out unclear sentiment, and append/update the sheet.

1. In Format Sentiment Output, map sentimentAnalysis to ={{ $json.sentimentAnalysis.category }}, post_id to ={{ $('Iterate Records').first().json.post_id }}, and comment to ={{ $json.comment }}.
2. In Filter Clear Sentiments, set the condition to ={{ $json.sentimentAnalysis }} notContains Not clear.
3. In Update Sentiment Sheet, set Operation to appendOrUpdate.
4. In Update Sentiment Sheet, set Document ID to [YOUR_ID] and Sheet Name to [YOUR_ID].
5. In Update Sentiment Sheet, keep Matching Columns set to url and Mapping Mode to autoMapInputData.
6. Credential Required: Connect your googleSheetsOAuth2Api credentials in Update Sentiment Sheet.

Step 6: Test & Activate Your Workflow

Run a manual test to verify the scrape, sentiment analysis, and sheet update before enabling in production.

1. Click Execute Workflow and confirm Manual Launch Trigger fires and reaches Trigger Reddit Scrape.
2. Wait for Status Router to route to Fetch Dataset Results (or loop through Delay Interval until ready).
3. Verify that Format Sentiment Output includes values like sentimentAnalysis, comment, and post_id.
4. Confirm that Update Sentiment Sheet writes or updates rows in your Google Sheet.
5. When everything looks correct, toggle the workflow Active for production use.