{"product_id":"apify-trade-show-leads-to-google-sheets-gmail-digest-n8n","title":"Apify Trade Show Leads to Google Sheets + Gmail Digest (n8n)","description":"\u003ch3\u003eTurn trade show exhibitor lists into a living lead database—plus an email digest\u003c\/h3\u003e\n\u003cp\u003e\u003cstrong\u003eApify Trade Show Leads to Google Sheets + Gmail Digest (n8n)\u003c\/strong\u003e is an n8n automation workflow that scrapes trade show exhibitor listings with Apify, upserts leads into \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and emails a \u003cstrong\u003eGmail digest\u003c\/strong\u003e of new or updated exhibitors—automatically every week.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on schedule\u003c\/strong\u003e: manual start or \u003cstrong\u003eevery Monday at 08:00 (UTC)\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScrapes exhibitor data with Apify\u003c\/strong\u003e: sends your configured show list and filters to the \u003cstrong\u003eApify Exhibitor List Scraper\u003c\/strong\u003e actor and waits for completion.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFails fast on errors\u003c\/strong\u003e: verifies the Apify actor run succeeded; if not, the workflow stops with an error.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads existing leads\u003c\/strong\u003e: downloads the actor dataset results, reads current rows from your target Google Sheets tab, and compares against prior entries.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDe-duplicates and categorizes leads\u003c\/strong\u003e: builds a de-duplicated list, assigns a path tag for each exhibitor (\u003cstrong\u003eReady to contact\u003c\/strong\u003e \/ \u003cstrong\u003eNeeds research\u003c\/strong\u003e \/ \u003cstrong\u003eNo contact\u003c\/strong\u003e), and flags whether each lead is new.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpserts into Google Sheets\u003c\/strong\u003e: appends new leads and updates existing ones using a generated \u003cstrong\u003eleadKey\u003c\/strong\u003e match.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends a Gmail HTML digest\u003c\/strong\u003e: first run sends a baseline email; subsequent runs highlight only \u003cstrong\u003enew\/updated\u003c\/strong\u003e exhibitors, then emails your configured recipient via Gmail.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS teams tracking potential partners from recurring \u003cstrong\u003etrade show\u003c\/strong\u003e exhibitor lists\u003c\/li\u003e\n  \u003cli\u003eSales ops or automation engineers keeping a \u003cstrong\u003eCRM-like lead sheet\u003c\/strong\u003e in Google Sheets\u003c\/li\u003e\n  \u003cli\u003eTeams who want weekly \u003cstrong\u003eGmail notifications\u003c\/strong\u003e when exhibitors change—without manual research\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes \/ components\u003c\/strong\u003e: if, set, code, gmail, sticky note, google sheets\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApify integration\u003c\/strong\u003e: Apify community node + Apify API token credential\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e: OAuth2 credentials; uses a spreadsheet with a \u003cem\u003e“Leads”\u003c\/em\u003e sheet (or configurable name)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e: OAuth2 credentials; configured recipient email for the HTML digest\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eIdeal for n8n users who want reliable trade show lead automation—scrape, dedupe, update, and notify in one workflow.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46359800185011,"sku":"N8N-22131","price":11.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/yVzmz61SlFqVII-lxsaeL_mKpVxLgH.png?v=1793697987","url":"https:\/\/buyflowscripts.com\/products\/apify-trade-show-leads-to-google-sheets-gmail-digest-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}