{"product_id":"plan-luma-events-by-city-apify-google-sheets-workflow","title":"Plan Luma Events by City: Apify + Google Sheets Workflow","description":"\u003ch3\u003ePlan Luma events by city in Google Sheets—without copying attendee profiles or sending invitations\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003en8n automation workflow\u003c\/strong\u003e generates a city-specific Luma Events planning register in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e using an \u003cstrong\u003eApify\u003c\/strong\u003e dataset. It pulls public Luma dates, timezones, and venue information, then performs a complete dataset check before delivering rows to your sheet—so you can review what’s happening before you make plans.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns a bounded Apify run\u003c\/strong\u003e to supply source records, coverage, and billing evidence.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eChecks the complete dataset\u003c\/strong\u003e before any delivery to Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates existing rows using stable source keys\u003c\/strong\u003e on repeat runs. Earlier unobserved rows remain—meaning your sheet acts as a \u003cstrong\u003ecurrent review register\u003c\/strong\u003e, not a full historical archive.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHonors source window rules:\u003c\/strong\u003e \u003cem\u003eCOMPLETE\u003c\/em\u003e describes the declared source window; \u003cem\u003eCAPPED\u003c\/em\u003e remains a labeled sample.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStops on source failures\u003c\/strong\u003e to prevent partial\/inaccurate updates.\u003c\/li\u003e\n  \u003cli\u003e\u003cstrong\u003eCreates no data rows for verified empty results.\u003c\/strong\u003e\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eKeeps timestamps consistent:\u003c\/strong\u003e stores \u003cstrong\u003eUTC timestamps\u003c\/strong\u003e and the \u003cstrong\u003esource timezone\u003c\/strong\u003e together.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHighlights what needs attention\u003c\/strong\u003e (applications, sold-out events, and events that have already started). Empty \u003cstrong\u003eprice\u003c\/strong\u003e or \u003cstrong\u003eavailability\u003c\/strong\u003e fields remain unknown—review the event page before acting.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eImportant:\u003c\/strong\u003e this workflow \u003cstrong\u003edoes not register guests\u003c\/strong\u003e and \u003cstrong\u003edoes not book tickets\u003c\/strong\u003e. It only prepares a planning register.\u003c\/p\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eCommunity organizers maintaining a “what’s next” register for a specific city’s Luma events.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators who need repeatable \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e updates with review flags and stable row keys.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers validating data integrity before syncing event details from Apify.\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:\u003c\/strong\u003e if, set, code, wait, sticky note, HTTP Request\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApify integration:\u003c\/strong\u003e uses your Apify account plus \u003cstrong\u003eHeader Auth\u003c\/strong\u003e credentials on all five HTTP nodes.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets:\u003c\/strong\u003e OAuth2 upsert review register into the provided tab with the exact CSV header from the workflow’s sheet-header.csv.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45978924941491,"sku":"N8N-19342","price":52.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/YRRcjABPQooN-sfFFpxFS_fpMDeszC.png?v=1788859087","url":"https:\/\/buyflowscripts.com\/products\/plan-luma-events-by-city-apify-google-sheets-workflow","provider":"N8N Commerce","version":"1.0","type":"link"}