Step 2: Connect the Apify Request

Set your Apify credentials as variables and build the API request URL dynamically.

1. Open Assign Workflow Vars and set APIFY_TOKEN to [CONFIGURE_YOUR_API_KEY].
2. Set APIFY_TASK_ID to [YOUR_ID].
3. In Execute Apify Scrape, set URL to {{ 'https://api.apify.com/v2/actor-tasks/' + $json.APIFY_TASK_ID + '/run-sync-get-dataset-items?token=' +$json.APIFY_TOKEN}}.
4. In Execute Apify Scrape enable Options → Split Into Items so each dataset row becomes an individual item.
5. Connect Assign Workflow Vars → Execute Apify Scrape.

Step 3: Set Up Lead Data Normalization

The code step cleans phone numbers and normalizes email addresses before storing the lead data.

1. Add the Normalize Lead Data node after Execute Apify Scrape.
2. Paste the JavaScript in Normalize Lead Data exactly as shown: // Clean scraped data before LLM processing return $input.all().map(item => ({ ...item.json, phone: item.json.phone?.replace(/[^\d+]/g, '') || '', email: item.json.email?.toLowerCase().trim() || '' }));
3. Connect Execute Apify Scrape → Normalize Lead Data.

Step 4: Configure the Output Destination

Append the normalized lead data into Google Sheets using defined column mappings.

1. Add the Append to Sheets node and connect it to Normalize Lead Data.
2. Credential Required: Connect your Google Sheets credentials in Append to Sheets.
3. Set Operation to append.
4. Set Document ID to [YOUR_ID].
5. Set Sheet Name to Sheet1.
6. Map columns in Columns → Define Below:
   • phone → {{ $json.phone }}
   • Address → {{ $json.address }}
   • company name → {{ $json.title }}

Step 5: Test and Activate Your Workflow

Run a manual test to verify the scrape and append behavior, then activate the workflow for use.

1. Click Execute Workflow to run Manual Launch Trigger.
2. Confirm Execute Apify Scrape returns items and Normalize Lead Data outputs cleaned phone and email fields.
3. Verify new rows appear in the target Google Sheet from Append to Sheets.
4. When successful, toggle the workflow to Active for production use.