Step 2: Connect Google Sheets

These nodes create a new worksheet per run, set headers, fetch company data, and store results. There are 5 Google Sheets nodes, so connect credentials across all of them.

1. Open Create Worksheet and set Title to ={{ $json["Readable date"] }} and Document ID to your spreadsheet (replace [YOUR_ID]).
2. Credential Required: Connect your googleSheetsOAuth2Api credentials to Create Worksheet, Append Column Headers, Fetch Company Records, Append Result Rows, and Load Stored Rows.
3. In Set Header Fields, keep the assignments for Search and Result as empty strings to define the column headers.
4. In Append Column Headers, set Sheet Name to ={{ $('Create Worksheet').first().json.sheetId }}.
5. In Fetch Company Records, set Sheet Name to gid=0 and keep Range Definition as specifyRange if you want to limit the data range.
6. In Load Stored Rows, set Sheet Name to ={{ $('Create Worksheet').first().json.sheetId }} and keep Execute Once enabled for aggregation.

Step 3: Set Up AI Query Generation

This segment generates three search queries per company using an LLM and structures the output for downstream processing.

1. Open LLM Router Hub and set Model to google/gemini-3-pro-preview.
2. Credential Required: Connect your openRouterApi credentials to LLM Router Hub.
3. In Compose Search Queries, set Text to =Company name : {{ $json["Company name"] }}, Working Category :{{ $json["Worknig category"] }} and keep Prompt Type as define.
4. Open Structured Output Parser and keep Auto Fix enabled with the JSON schema example provided.
5. In Split Generated Queries, set Field to Split Out to output.

Step 4: Configure BrowserAct Search Runs and Batch Handling

Each generated query is run through BrowserAct, and the results are appended back into the worksheet.

1. Open Iterate Batch Items to batch each query for processing.
2. In Launch BrowserAct Run, set Type to WORKFLOW and Workflow ID to [YOUR_ID].
3. In Launch BrowserAct Run → Workflow Config, map input-Inputs to ={{ $json.output }}.
4. Credential Required: Connect your browserActApi credentials to Launch BrowserAct Run.
5. In Append Result Rows, map Search to ={{ $('Iterate Batch Items').item.json.output }} and Result to ={{ $json.output.string }}, and set Sheet Name to ={{ $('Create Worksheet').first().json.sheetId }}.

Step 5: Configure Analysis and Slack Notification

Aggregate all results, analyze them with an LLM, and send a formatted report to Slack.

1. In Aggregate Sheet Rows, set Aggregate to aggregateAllItemData.
2. Open LLM Router Hub 2 and set Model to google/gemini-3-pro-preview.
3. Credential Required: Connect your openRouterApi credentials to LLM Router Hub 2.
4. In Analyze Company Results, set Text to =Date : {{ $('Daily Schedule Trigger').first().json["Readable date"] }}, Company name : {{ $('Fetch Company Records').first().json["Company name"] }}, Working Category :{{ $('Fetch Company Records').first().json["Worknig category"] }} question and answers : {{ $json.data }}.
5. In Slack Team Notification, set Text to ={{ $json.output }} and choose your target Channel.
6. Credential Required: Connect your slackApi credentials to Slack Team Notification.

Step 6: Test and Activate Your Workflow

Run a full test to confirm worksheet creation, query generation, BrowserAct results, and Slack reporting work end-to-end.

1. Click Execute Workflow to run a manual test from Daily Schedule Trigger.
2. Verify a new worksheet is created with the date title and that headers Search and Result appear.
3. Confirm rows are appended in the worksheet with each query and BrowserAct result.
4. Check that Slack Team Notification posts a formatted report to the selected channel.
5. When everything looks correct, toggle the workflow to Active for daily runs.