Step 2: Connect Google Sheets

Fetch keyword rows for Series A and Series B and prepare the destination sheet for upserts.

1. Open Fetch Sheet Rows and select the target spreadsheet for keywords using Document value [YOUR_ID].
2. Set the Sheet to [YOUR_ID] (the sheet labeled “Keywords For Funding Announcement to Lead List (TechCrunch)”).
3. Credential Required: Connect your googleSheetsOAuth2Api credentials in Fetch Sheet Rows.
4. Open Upsert Sheet Row and select the target spreadsheet using Document value [YOUR_ID].
5. Set Operation to appendOrUpdate and map columns: Url to {{ $json.text.Url }}, Company to {{ $json.text.Company }}, and InvestedOn to {{ $json.text.InvestedOn }}.
6. Credential Required: Connect your googleSheetsOAuth2Api credentials in Upsert Sheet Row.

Step 3: Configure Scraping and Batching

Split the keyword rows into batches and launch Series A and Series B scraping tasks for each record.

1. In Batch Iterate Records, keep the default settings to iterate over each row from Fetch Sheet Rows.
2. Configure Start Scrape Series A with Workflow ID set to [YOUR_ID] and input parameters: KeyWord to {{ $json["keyword Series A"] }} and Location to {{ $json.Geo }}.
3. Credential Required: Connect your browserActApi credentials in Start Scrape Series A.
4. Configure Start Scrape Series B with Workflow ID set to [YOUR_ID] and input parameters: KeyWord to {{ $json["keyword Series B"] }} and Location to {{ $json.Geo }}.
5. Credential Required: Connect your browserActApi credentials in Start Scrape Series B.
6. Batch Iterate Records outputs to both Start Scrape Series A and Start Scrape Series B in parallel, launching both scraping tasks for each record.
7. In Await Series A Task and Await Series B Task, keep Operation as getTask, Max Wait Time as 900, and Polling Interval as 30, with Task ID set to {{ $json.id }}.
8. Credential Required: Connect your browserActApi credentials in both Await Series A Task and Await Series B Task.

Step 4: Set Up AI Analysis and Parsing

Use the AI agent to analyze scraped article text, then parse it into structured JSON output for downstream processing.

1. Open Funding Analysis Agent and set Prompt to the provided multi-line instruction, keeping the expression {{ $json.output.string }} intact.
2. Ensure Has Output Parser is enabled in Funding Analysis Agent.
3. In Structured JSON Parser, set JSON Schema Example to [{"Company":"<String>","InvestedOn":"<String>","Url":"<String>"}].
4. Gemini Chat Model is connected as the language model for Funding Analysis Agent — ensure credentials are added to Gemini Chat Model.
5. Credential Required: Connect your googlePalmApi credentials in Gemini Chat Model.
6. Structured JSON Parser is an AI sub-node — add credentials to the parent node (Gemini Chat Model), not the parser.

Step 5: Format, Filter, and Notify

Format AI results into individual items, filter out non-matches, upsert the sheet, and post a Slack notification.

1. In Format Result Items, keep the provided JavaScript to convert $input.first().json.output into individual items.
2. Configure Company Presence Check with three OR conditions: Company, Url, and InvestedOn each equals No Company using expressions {{ $json.text.Company }}, {{ $json.text.Url }}, and {{ $json.text.InvestedOn }}.
3. Ensure the true branch of Company Presence Check is empty and the false branch routes to Upsert Sheet Row.
4. In Post Slack Update, set Text to The data for the lead announcement has been updated and select the target Channel value [YOUR_ID].
5. Credential Required: Connect your slackOAuth2Api credentials in Post Slack Update.

Step 6: Test and Activate Your Workflow

Run a manual test, verify outputs in Google Sheets and Slack, and then activate the workflow for production.

1. Click Execute Workflow on Manual Launch Trigger to run a test.
2. Confirm that Combine Results receives results from both Await Series A Task and Await Series B Task.
3. Verify that Upsert Sheet Row writes or updates the Company, InvestedOn, and Url columns in your destination sheet.
4. Check Slack to confirm Post Slack Update posts the update message in the selected channel.
5. Toggle the workflow to Active once testing is successful.