Enrich domain contact data in paced batches with Apify and Google Sheets
UnknownUnknown. This template uses community nodes we can't verify statically. Uses community nodes that can't be verified statically (unverified community packages are off by default in 3.0). Static check, last run 2026-10-19.
What this workflow does
This workflow has 11 nodes and runs on a schedule (every week at 08:00). Along the way it connects Google Sheets, Slack, Gmail and Apify (community).
How it runs
Trigger: On a schedule (every week at 08:00).
- Read the domain list (Google Sheets): uses Google Sheets
- Take them ten at a time (Loop Over Items (Split in Batches)): loops over the items in batches
- Collect every batch (Aggregate): combines items into one
- Look up this batch (Apify): run actor and get dataset (actors)
- Score the coverage (Code): runs custom JavaScript code
- Keep one row per domain (Code): runs custom JavaScript code
- Write the enriched list (Google Sheets): append
- Breathe between batches (Wait): waits 30 seconds
- Optional: post the hit rate to Slack (Slack): uses Slack
- Optional: email the finished list (Gmail): uses Gmail
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that @apify/n8n-nodes-apify is verified or supports 3.0 (used in Look up this batch).
Nodes used (9)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Apify
@apify/n8n-nodes-apify.apify - Code
n8n-nodes-base.code - Wait
n8n-nodes-base.wait - Aggregate
n8n-nodes-base.aggregate - Slack
n8n-nodes-base.slack - Gmail
n8n-nodes-base.gmail
From the author
Quick Overview This workflow runs every Monday, reads a Google Sheets list of domains, enriches them in paced 10-domain batches using an Apify actor to extract contact details, and appends the results back to Google Sheets with overall email and phone…