Step 2: Connect Google Sheets

These nodes fetch search phrases, update processing status, and store extracted emails.

1. Open Retrieve Search Phrases and set Document to [YOUR_ID] and Sheet to gid=0 (Searches).
2. Credential Required: Connect your googleSheetsOAuth2Api credentials in Retrieve Search Phrases.
3. Open Update Row Status and keep Operation as appendOrUpdate with Matching Columns set to Search.
4. Verify Update Row Status column mapping includes Search set to {{ $json.Search }} and Complete set to Yes.
5. Credential Required: Connect your googleSheetsOAuth2Api credentials in Update Row Status.
6. Open Store Emails in Sheet and keep Operation as appendOrUpdate, Sheet set to 1470668196 (Results), and Document set to [YOUR_ID].
7. Ensure column mappings in Store Emails in Sheet include:
   • Area → {{ $('Retrieve Search Phrases').item.json.Area }}
   • Search → {{ $('Retrieve Search Phrases').item.json.Search }}
   • Search Name → {{ $('Retrieve Search Phrases').item.json['Area Name'] }}
   • title → {{ $('Format Results Table').item.json.title }}
   • website → {{ $('Format Results Table').item.json.website }}
   • address → {{ $('Format Results Table').item.json.address }}
   • phone → {{ $('Format Results Table').item.json.phone }}
   • email (Manual Entry) → {{ $json.output.email }}
8. Credential Required: Connect your googleSheetsOAuth2Api credentials in Store Emails in Sheet.

Step 3: Set Up Search Filtering and Routing

This section filters for incomplete rows, picks a single search phrase, and branches in parallel.

1. In Filter Pending Rows, set the condition Complete to is empty using {{ $json.Complete }}.
2. In Select First Record, keep the code as return [items[0]]; to process one search at a time.
3. Connect Retrieve Search Phrases → Filter Pending Rows → Select First Record.
4. Ensure Select First Record outputs to both Update Row Status and Query Google Maps in parallel.

Step 4: Configure Google Maps Search and Result Parsing

This segment queries Google Maps via SerpApi and formats results into individual records.

1. Open Query Google Maps and set Operation to google_maps.
2. Set q to {{ $json.Search }} and ll to {{ $json.Area }} in Query Google Maps.
3. Credential Required: Connect your serpApi credentials in Query Google Maps.
4. In Format Results Table, keep the JavaScript that cleans website URLs and outputs title, website, address, and phone as individual items.
5. Connect Query Google Maps → Format Results Table → Iterate Through Records.

Step 5: Set Up Web Content Fetching and AI Email Extraction

This stage crawls each business website and extracts an email address using AI.

1. In Fetch Web Content, set URL to =https://api.apify.com/v2/acts/6sigmag~fast-website-content-crawler/run-sync-get-dataset-items.
2. Set Method to POST and JSON Body to {"startUrls":[ "{{ $json.website }}" ]} in Fetch Web Content.
3. Credential Required: Connect your httpQueryAuth credentials in Fetch Web Content.
4. In AI Email Extractor, set Text to {{ $json.text }} and keep Prompt Type as define with Has Output Parser enabled.
5. Ensure OpenAI Chat Engine is connected as the language model for AI Email Extractor and Structured Output Decoder is connected as the output parser.
6. Credential Required: Connect your openAiApi credentials in OpenAI Chat Engine (credentials are added to the parent model, not the parser).
7. Keep Structured Output Decoder schema as { "email": "emailaddress" } to standardize output.
8. Connect Iterate Through Records → Fetch Web Content → AI Email Extractor → Iterate Through Records (second output loop).

Step 6: Configure Parallel Outputs and Sub-Workflow

Results are saved to the sheet while a summary is sent to a sub-workflow.

1. Confirm that Iterate Through Records outputs to both Store Emails in Sheet and Summarize Single Row in parallel.
2. In Summarize Single Row, keep Fields to Summarize set to include title.
3. Open Run Sub-Workflow (Configure Required) and select a Workflow in Workflow ID.
4. Connect Summarize Single Row → Run Sub-Workflow (Configure Required).

Step 7: Test and Activate Your Workflow

Validate the full execution and then enable the workflow for ongoing use.

1. Click Execute Workflow to run Manual Execution Start and process one pending search.
2. Verify Update Row Status marks the row Complete as Yes.
3. Confirm Store Emails in Sheet writes records with expected fields, including email (Manual Entry).
4. Check that AI Email Extractor outputs either an email or null in output.email.
5. If everything looks correct, toggle the workflow to Active for production use.