Step 2: Build and Fetch the Google Search Results

Create the search URL and pull Google results content to extract an X profile link.

1. Open Build Google Search Link and set the google_search assignment value to =https://www.google.com/search?q=site%3Ax.com+{{ encodeURIComponent($json["Person Fullname"].trim()) }}.
2. Open BrightData Fetch and set URL to ={{ $json.google_search }}, Format to json, and select the desired Zone and Country values (e.g., web_unlocker1, us).
3. Open Pull Page Title and Body and set Operation to extractHtmlContent with Data Property Name set to body.

Credential Required: Connect your Bright Data credentials in BrightData Fetch.

Step 3: Parse the X Profile Link with AI

Use Gemini to interpret search results and identify the correct profile URL.

1. Open Gemini Chat Engine and set Model Name to models/gemini-2.0-flash.
2. Open Structured Result Parser and keep the JSON Schema Example set to the provided array of username, name, url, and description.
3. Open Parse X Profile Link and set Text to ={{$('Pull Page Title and Body').item.json["body"]}}. Ensure Has Output Parser is enabled.
4. Verify Profile Found Check uses the condition ={{ $json.output[0]['url'] }} to detect a valid profile URL.
5. Open No Profile Response and confirm Response Text is =We didn't found X Profile for "{{ $('Form Submission Trigger').item.json["Person Fullname"] }} ".

Credential Required: Connect your Google Gemini credentials in Gemini Chat Engine. The Structured Result Parser is a sub-node, so credentials must be added to Gemini Chat Engine, not the parser.

⚠️ Common Pitfall: If the HTML body is empty or truncated in Pull Page Title and Body, Parse X Profile Link won’t find a valid URL and will route to No Profile Response.

Step 4: Build and Monitor the Bright Data Snapshot

Request a dataset snapshot, poll for readiness, and retrieve post data for the profile.

1. Open Request Snapshot Build and set Dataset ID to your Bright Data dataset (replace [YOUR_ID]).
2. Set Filters Group in Request Snapshot Build to ={"operator":"and","filters":[{"name":"url","operator":"includes","value":"{{ $json["output"][0]['url'] }}"},{"name":"date_posted","operator":">=","value":"{{ $('Form Submission Trigger').item.json["Analyze Posts From Date"] }}"},{"name":"date_posted","operator":"<=","value":"{{ $('Form Submission Trigger').item.json["Analyze Posts To Date"] }}"}]}.
3. Open Delay Snapshot Poll and set Amount to 30 seconds.
4. Open Check Snapshot Status and set Snapshot ID to ={{ $json.snapshot_id }}.
5. Open Snapshot Ready Check and confirm it checks ={{ $json.status }} equals ready.
6. Open Retrieve Snapshot Content and set Snapshot ID to ={{ $('Request Snapshot Build').item.json.snapshot_id }}.
7. Open Snapshot Items Check to validate ={{ $json.items}} exists before processing.
8. Open Delay Snapshot Review and set Amount to 30 seconds for retry loops.
9. Open Error Presence Check and verify it evaluates ={{ $json.error }} so errors route to Error Response Form.
10. Open Error Response Form and confirm Response Text is =Bright Data error for "{{ $('Form Submission Trigger').item.json["Person Fullname"] }} ".

Credential Required: Connect your Bright Data credentials in Request Snapshot Build, Check Snapshot Status, and Retrieve Snapshot Content.

Step 5: Transform and Analyze Post Content

Normalize post data into a structured array and summarize it with AI.

1. Open Transform Post Data and keep the JavaScript that maps items into the posts array.
2. Open Analyze Post Content and set Text to ={{$json}}.
3. In Analyze Post Content, confirm the message is =Analyze these twitter posts - Detect interests, tone, sentiments, common topics, popularity and return summary.
4. Ensure Gemini Chat Engine B is connected as the language model for Analyze Post Content.

Credential Required: Connect your Google Gemini credentials in Gemini Chat Engine B.

Step 6: Configure the Google Sheets Output

Store the analyzed profile details and AI summary in Google Sheets.

1. Open Append Results to Sheet and set Operation to append.
2. Set Document ID to your sheet ID (replace [YOUR_ID]) and Sheet Name to results (gid=0).
3. Map columns as follows: name to ={{ $('Form Submission Trigger').item.json['Person Fullname'] }}, posts to ={{ $('Transform Post Data').item.json.posts }}, x_url to ={{ $('Parse X Profile Link').item.json.output[0]['url'] }}, end_date to ={{ $('Form Submission Trigger').item.json['Analyze Posts To Date'] }}, ai_summary to ={{ $json.text }}, and start_date to ={{ $('Form Submission Trigger').item.json['Analyze Posts From Date'] }}.

Credential Required: Connect your Google Sheets credentials in Append Results to Sheet.

⚠️ Common Pitfall: If the sheet column names don’t match the schema in Append Results to Sheet, the append will fail or write empty values.

Step 7: Test and Activate Your Workflow

Validate the full flow from form submission to spreadsheet output.

1. Use Form Submission Trigger to submit a test profile and date range.
2. Confirm that Build Google Search Link produces a valid Google query URL and that BrightData Fetch returns HTML for parsing.
3. Check that Parse X Profile Link outputs a valid url and Profile Found Check routes correctly.
4. Verify the snapshot loop reaches Snapshot Ready Check and Retrieve Snapshot Content returns items before Transform Post Data runs.
5. Confirm Analyze Post Content returns a summary and Append Results to Sheet writes a new row.
6. When satisfied, toggle the workflow Active to enable production use.