Recover abandoned Shopify carts with Llama 3.2, Gmail, and Google Sheets

by Shaharuk Anik · 1 views · created 2026-10-06 · Lead Nurturing, Multimodal AI

What this workflow does

This workflow has 35 nodes and runs when an HTTP POST request hits its webhook URL (plus 1 other trigger). Along the way it connects Google Sheets and Gmail. It also calls host.docker.internal:11434 over HTTP.

How it runs

Trigger: When an HTTP POST request hits its webhook URL (plus 1 other trigger).

1. Filter: keeps only the items that match a condition
2. Filter: keeps only the items that match a condition
3. Get All Rows (Google Sheets): uses Google Sheets
4. Sheets Order Recovered (Google Sheets): append or update
5. Log Checkout (Google Sheets): append or update
6. Weekly Stats (Code): runs custom JavaScript code
7. Pick Upsell (Code): runs custom JavaScript code
8. Filter: keeps only the items that match a condition
9. Gmail: uses Gmail
10. HTTP Request: calls host.docker.internal:11434 (POST)

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

Services it uses

Google SheetsGmail

HTTP calls to: host.docker.internal:11434

Before you upgrade to n8n 3.0

Nodes used (8)

• Webhookn8n-nodes-base.webhook
• Google Sheetsn8n-nodes-base.googleSheets
• Waitn8n-nodes-base.wait
• Filtern8n-nodes-base.filter
• HTTP Requestn8n-nodes-base.httpRequest
• Coden8n-nodes-base.code
• Gmailn8n-nodes-base.gmail
• Schedule Triggern8n-nodes-base.scheduleTrigger

From the author

Quick overview This workflow captures Shopify checkout and order webhooks, logs activity to Google Sheets, and uses an Ollama-hosted Llama 3.2 chat endpoint to generate and send cart-recovery and post-purchase emails via Gmail, then emails a weekly recovery…

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