Step 2: Connect the Scraping and Email Services

Configure the two HTTP services that scrape Google Places data and enrich records with email leads.

1. Open Map Search Scraper and set URL to https://api.apify.com/v2/acts/compass~crawler-google-places/run-sync-get-dataset-items.
2. Set Method to POST, Send Body to true, and Body Content Type to json.
3. In JSON Body, use the provided expression: ={ "city": "{{ $json.city }}", "countryCode": "{{ $json['country code'] }}", "locationQuery": "{{ $json.city }}", "maxCrawledPlacesPerSearch":{{ $json.number ? $json.number : 99999 }}, "searchStringsArray": [ "{{ $json.query }}" ], "skipClosedPlaces": true }.
4. Credential Required: Connect your httpQueryAuth credentials in Map Search Scraper.
5. Open Retrieve Email Leads, set URL to https://api.anymailfinder.com/v5.1/find-email/company, and keep Method as POST.
6. In Body Parameters, set domain to ={{ $json.domain}}.
7. Credential Required: Connect your httpHeaderAuth credentials in Retrieve Email Leads.

Step 3: Map, Batch, and Sanitize Scraped Data

Prepare the scraped place data, clean website domains, and remove already-stored records before enrichment.

1. Open Batch Through Results and keep default options to process items in batches.
2. In Map Data Fields, confirm the field mappings use these expressions: ={{ $json.title }}, ={{ $json.address }}, ={{ $json.categories.join(",") }}, ={{ $json.scrapedAt.toDateTime().format('dd/LL/yyyy') }}, and the other listed assignments.
3. In Sanitize Site Info, keep the provided JavaScript to normalize website, derive domain, and remove social network hosts.
4. In Fetch Stored Place IDs, set Operation to getAll, Project ID to [YOUR_ID], and Table to [YOUR_ID].
5. Credential Required: Connect your nocoDbApiToken credentials in Fetch Stored Place IDs.
6. In Exclude Existing Records, keep the JavaScript that filters out known placeId values by reading $('Fetch Stored Place IDs').

Step 4: Filter by Domain and Enrich With Emails

Route only valid domains to email discovery, then merge enriched details back into the dataset.

1. In Check PlaceId Exists, keep the condition ={{ $json.placeId }} with the exists operator.
2. In Filter Records by Domain, ensure the condition is ={{ $json.domain }} with the exists operator.
3. Open Retrieve Email Leads and confirm Continue On Fail is enabled (onError: continueRegularOutput) to avoid stopping the workflow if no email is found.
4. In Assemble Email Details, confirm the enrichment mappings reference the filtered record, for example ={{ $('Filter Records by Domain').item.json.title }} and ={{ $json.emails.join(",") }}.
5. Keep Combine Branches connected so both the enriched path and the “no email” path feed into the same output pipeline.

Step 5: Configure Database Output

Write the final lead records into NocoDB with a consistent schema.

1. Open Insert Database Row and set Operation to create.
2. Set Project ID to [YOUR_ID] and Table to [YOUR_ID].
3. Map fields using the provided expressions, for example email → ={{ $json.emails }} and categories → ={{ $('Filter Records by Domain').item.json.categories }}.
4. Credential Required: Connect your nocoDbApiToken credentials in Insert Database Row.
5. Confirm Insert Database Row connects back to Batch Through Results to continue processing remaining items.

Step 6: Test and Activate Your Workflow

Run a controlled test to confirm the end-to-end flow from form input to database insertion.

1. Click Execute Workflow and submit the Form Input Trigger with sample values (e.g., query = plumber, city = Austin).
2. Verify that Map Search Scraper returns place items and that Sanitize Site Info produces a valid domain.
3. Confirm Retrieve Email Leads runs for items that pass Filter Records by Domain.
4. Check Insert Database Row to ensure new records appear in NocoDB with fields like title, email, and placeId.
5. Once successful, toggle Activate to enable production usage.