Monitor Zillow deals by ZIP with APIllow, Google Sheets, and Slack
Ready for 3.0What this workflow does
This workflow has 14 nodes and runs on a schedule (cron 0 8 * * *). Along the way it connects Google Sheets and Slack. It also calls api.apillow.co over HTTP.
How it runs
Trigger: On a schedule (cron 0 8 * * *).
- Watch config (Edit Fields (Set)): sets 3 fields: zipcodes, deal_threshold, max_items
- APIllow: submit ZIP search (HTTP Request): calls api.apillow.co (POST)
- Wait: waits 10 seconds
- Slack: uses Slack
- APIllow: get results (HTTP Request): calls an HTTP API
- Job complete? (If): checks a condition and branches into true / false
- Flatten & score (Code): runs custom JavaScript code
- Wait: waits 10 seconds
- Read tracked deals (Google Sheets): uses Google Sheets
- Drop already-tracked (Code): runs custom JavaScript code
…plus 3 more steps. See the full node list below.
Services it uses
HTTP calls to: api.apillow.co
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (8)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - Wait
n8n-nodes-base.wait - If
n8n-nodes-base.if - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - Slack
n8n-nodes-base.slack
From the author
Quick overview This workflow runs daily to fetch for-sale listings for selected ZIP codes from the APIllow API, calculates each listing’s $/sqft against the ZIP’s median, appends new listings to Google Sheets without duplicates, and posts deal and error…