Manage a self-hosted grocery list with webhooks and Data Tables

by Remko Stas ✓ · 45 views · created 2026-07-18 · Personal Productivity

What this workflow does

This workflow has 30 nodes and runs manually, when you click “Execute workflow” (plus 3 other triggers). Along the way it connects Postgres and Google Sheets.

How it runs

Trigger: Manually, when you click “Execute workflow” (plus 3 other triggers).

1. Setup: Create Data Table (Data table): create (table)
2. Setup: Create Postgres Table (Postgres): run a query
3. Setup: Create Google Sheet (Google Sheets): work with spreadsheet
4. Postgres: run a query
5. Sheets: Get Items (Google Sheets): uses Google Sheets
6. Data table: get
7. Postgres: run a query
8. Sheets: Add Item (Google Sheets): append
9. Data table: uses Data table
10. Postgres: run a query

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

Services it uses

PostgresGoogle Sheets

Before you upgrade to n8n 3.0

Nodes used (7)

• Webhookn8n-nodes-base.webhook
• Postgresn8n-nodes-base.postgres
• Coden8n-nodes-base.code
• Respond to Webhookn8n-nodes-base.respondToWebhook
• Google Sheetsn8n-nodes-base.googleSheets
• Data tablen8n-nodes-base.dataTable
• Manual Triggern8n-nodes-base.manualTrigger

From the author

Quick overview This workflow hosts a simple, mobile-friendly grocery list web page in n8n and stores items in n8n Data Tables (default), PostgreSQL, or Google Sheets, letting you view the list, add items, and check items off via webhooks. How it works 1.…

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