Track local legal-market signals with Socrata, Google Sheets, and email

by Dele Tosh @ Protomated ✓ · 0 views · created 2026-09-11 · Market Research, AI Summarization

What this workflow does

This workflow has 19 nodes and runs on a schedule (cron 0 7 * * *) (plus 1 other trigger). Along the way it connects Google Sheets.

How it runs

Trigger: On a schedule (cron 0 7 * * *) (plus 1 other trigger).

1. If: checks a condition and branches into true / false
2. Read Weekly Signal Log (Google Sheets): read
3. Build Socrata Query URL (Code): runs custom JavaScript code
4. Prepare Setup Needed Notice (Code): runs custom JavaScript code
5. Compute Weekly Signal Summary (Code): runs custom JavaScript code
6. Fetch Signal Records (HTTP Request): calls an HTTP API (GET)
7. Build Signal Digest Email (Code): runs custom JavaScript code
8. Build Weekly Signal Volume Email (Code): runs custom JavaScript code
9. Normalize Signal Data (Code): runs custom JavaScript code
10. Send Signal Digest Email (Send Email): sends an email over SMTP

…plus 6 more steps. See the full node list below.

Services it uses

Google Sheets

Before you upgrade to n8n 3.0

Nodes used (7)

• Schedule Triggern8n-nodes-base.scheduleTrigger
• Ifn8n-nodes-base.if
• Coden8n-nodes-base.code
• HTTP Requestn8n-nodes-base.httpRequest
• Google Sheetsn8n-nodes-base.googleSheets
• Send Emailn8n-nodes-base.emailSend
• No Operation, do nothingn8n-nodes-base.noOp

From the author

Quick Overview This workflow runs daily and weekly to pull recent public-record filings from a Socrata-style open-data API, deduplicate and tag them by legal practice area, log matches to Google Sheets, and send internal digest and weekly volume summary…

View the original on n8n.io → Check your own copy