Step 2: Connect Google Sheets

The workflow reads brand and group data and stores outputs in multiple Google Sheets.

1. Open Retrieve Brand List, Fetch Group Links, Update Last Scrape, Update Sentiment Sheet, and Store Posts Sheet.
2. Credential Required: Connect your googleSheetsOAuth2Api credentials to all Google Sheets nodes (5 nodes handle brand lists, group links, last scrape updates, sentiment results, and post storage).
3. In Retrieve Brand List, set Document to [YOUR_ID] and Sheet to Brand Name.
4. In Fetch Group Links, set Document to [YOUR_ID] and Sheet to Facebook group Links.
5. Confirm Update Sentiment Sheet is set to Operation appendOrUpdate and Store Posts Sheet is set to Operation append.

Step 3: Configure Access Keys and Scrape Orchestration

This stage prepares access details, gathers group URLs, and triggers the Bright Data dataset scrape. It also handles status routing with a parallel branch.

1. In Configure Access Keys, set endpoint to =[YOUR_URL] and API to =[CONFIGURE_YOUR_API_KEY].
2. Verify Combine Brand Names aggregates Brand names and feeds Fetch Group Links → Combine Group URLs.
3. In Assign Group URLs, set url to {{ $('Combine Group URLs').first().json.url }} and pass to Expand URL List with Field to Split Out url.
4. Configure Trigger Group Scrape with URL https://api.brightdata.com/datasets/v3/trigger and JSON Body to {{ $json.url.map(u => ({ url: u, start_date: $now.format('yyyy-MM-dd'), end_date: "" })) }}.
5. Set Trigger Group Scrape query parameters including endpoint to {{ $('Configure Access Keys').first().json.endpoint }} and header Authorization to Bearer {{ $('Configure Access Keys').first().json.API }}.
6. In Check Scrape Progress, set URL to https://api.brightdata.com/datasets/v3/progress/{{ $json.snapshot_id }} and Authorization to Bearer {{ $('Configure Access Keys').first().json.API }}.
7. Route by Status outputs to both Download Snapshot Data and Assign Group URLs in parallel when {{ $json.status }} equals ready; the running path sends to Delay Processing.
8. In Download Snapshot Data, set URL to https://api.brightdata.com/datasets/v3/snapshot/{{ $json.snapshot_id }} and use Bearer {{ $('Configure Access Keys').first().json.API }} for authorization.
9. Set Limit Items to Max Items 20 before analysis.
10. In Update Last Scrape, map url to {{ $json.url }} and last Scraped to {{ $now.format('yyyy-MM-dd t') }} with Operation update.

Step 4: Configure Webhook Ingestion and Post Storage

Incoming scrape results are delivered via webhook and stored in a posts sheet for raw record keeping.

1. Open Incoming Results Webhook and confirm the Path is ca835c61-fa01-4cd5-8919-2d3b0e62ac5a with HTTP Method POST.
2. Connect Incoming Results Webhook to Expand Result Items and set Field to Split Out to body.
3. Verify Store Posts Sheet appends results using Operation append and Auto Map Input Data.

Step 5: Set Up Sentiment and Insight Processing

This phase filters brand mentions, runs sentiment analysis, and extracts structured insights using OpenRouter models.

1. In Filter Mentioned Brands, use the condition expression {{ $('Combine Brand Names').first().json['Brand names'].some( b => $json.content.toLowerCase().includes(b.toLowerCase()) ) }} to pass only posts that mention brands.
2. Open Analyze Sentiment and set Input Text to {{ $json.content }} with categories Positive, Negative, Neutral.
3. Credential Required: Connect your openRouterApi credentials in OpenRouter Chat Engine. This node is the language model for Analyze Sentiment, so credentials should be added to OpenRouter Chat Engine, not the sentiment node.
4. Confirm Merge Analysis Streams has Number of Inputs set to 3 before flowing into Extract Post Insights.
5. In Extract Post Insights, set Text to {{ $json.content }} and JSON Schema Example to { "Insight": "", "Sentiment": "", "Category": "" }.
6. Credential Required: Connect your openRouterApi credentials in OpenRouter Insight Model. This node is the language model for Extract Post Insights, so credentials should be added to OpenRouter Insight Model, not the extractor.
7. In Select Group Results, set JSON Output to {{ $('Filter Mentioned Brands').item.json}} before passing to Map Insights Output.
8. In Map Insights Output, map sentiment fields from analysis: confidence to {{ $('Merge Analysis Streams').item.json.confidence }} and sentimentAnalysis to {{ $('Merge Analysis Streams').item.json.sentimentAnalysis }}, and map insight fields from Extract Post Insights output.

Step 6: Configure Output Destinations

Final insights and sentiment results are stored in the sentiment sheet with post-level matching.

1. Open Update Sentiment Sheet and keep Operation set to appendOrUpdate.
2. Ensure Matching Columns include post_id to avoid duplicate entries.
3. Confirm Map Insights Output is connected to Update Sentiment Sheet and passes all mapped fields.

Step 7: Test and Activate Your Workflow

Run a full test to validate the Bright Data scrape, webhook intake, AI analysis, and Google Sheets outputs.

1. Click Execute Workflow and verify that Scheduled Run Trigger starts Configure Access Keys and downstream scraping nodes.
2. Confirm Route by Status splits execution correctly, with Download Snapshot Data and Assign Group URLs running in parallel when status is ready.
3. Send a test POST to Incoming Results Webhook and ensure records are created in Store Posts Sheet and Update Sentiment Sheet.
4. Successful execution should result in new rows with sentiment, confidence, and insight fields populated from Map Insights Output.
5. Activate the workflow by toggling it to Active so it runs daily at the scheduled time.