Context: Building automation for steel supply company - need to trigger workflows instantly when Excel files are uploaded to Drive subfolders.
Current Setup:
- Main Drive folder with 20+ vendor subfolders
- Files get uploaded to subfolders (not main folder)
- Need to trigger n8n webhook immediately on file upload
- Currently using 10-minute polling (too slow for business needs)
What I've Tried:
- Google Cloud Pub/Sub + Drive API: Watch registered but no notifications received
- Google Apps Script Drive triggers: Can't access "From Drive" triggers in UI despite enabling Drive API v3
- Apps Script → n8n webhook: This part works perfectly when manually triggered
The Question: What's the most reliable way to get real-time trigger when files are added to Drive subfolders?
Requirements:
- Must work with subfolders (not just parent folder)
- Sub-second to few-minute response time
- Reliable (99%+ success rate)
- Integrates with existing n8n workflow