Apify Trade Show Leads to Google Sheets + Gmail Digest (n8n)

Turn trade show exhibitor lists into a living lead database—plus an email digest

Apify Trade Show Leads to Google Sheets + Gmail Digest (n8n) is an n8n automation workflow that scrapes trade show exhibitor listings with Apify, upserts leads into Google Sheets, and emails a Gmail digest of new or updated exhibitors—automatically every week.

What this workflow does

• Runs on schedule: manual start or every Monday at 08:00 (UTC).
• Scrapes exhibitor data with Apify: sends your configured show list and filters to the Apify Exhibitor List Scraper actor and waits for completion.
• Fails fast on errors: verifies the Apify actor run succeeded; if not, the workflow stops with an error.
• Loads existing leads: downloads the actor dataset results, reads current rows from your target Google Sheets tab, and compares against prior entries.
• De-duplicates and categorizes leads: builds a de-duplicated list, assigns a path tag for each exhibitor (Ready to contact / Needs research / No contact), and flags whether each lead is new.
• Upserts into Google Sheets: appends new leads and updates existing ones using a generated leadKey match.
• Sends a Gmail HTML digest: first run sends a baseline email; subsequent runs highlight only new/updated exhibitors, then emails your configured recipient via Gmail.

Use cases

• SaaS teams tracking potential partners from recurring trade show exhibitor lists
• Sales ops or automation engineers keeping a CRM-like lead sheet in Google Sheets
• Teams who want weekly Gmail notifications when exhibitors change—without manual research

Technical details

• n8n nodes / components: if, set, code, gmail, sticky note, google sheets
• Apify integration: Apify community node + Apify API token credential
• Google Sheets: OAuth2 credentials; uses a spreadsheet with a “Leads” sheet (or configurable name)
• Gmail: OAuth2 credentials; configured recipient email for the HTML digest

Ideal for n8n users who want reliable trade show lead automation—scrape, dedupe, update, and notify in one workflow.