Send shipping emails with tracking from Google Sheets via ShipStation and Gmail

by Atharva Ashtekar ✓ · 1 views · created 2026-09-24 · CRM

What this workflow does

This workflow has 28 nodes and runs manually, when you click “Execute workflow” (plus 1 other trigger). Along the way it connects Google Sheets and Gmail.

How it runs

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

1. config (Code): runs custom JavaScript code
2. board connected? (If): checks a condition and branches into true / false
3. [cred] Sheets - read the board (Google Sheets): uses Google Sheets
4. use the demo board (Code): runs custom JavaScript code
5. read the board (Code): runs custom JavaScript code
6. anything shipped but not emailed? (If): checks a condition and branches into true / false
7. shipped before confirmation? (If): checks a condition and branches into true / false
8. split the shippers (Code): runs custom JavaScript code
9. STOP: nothing to ship today (Code): runs custom JavaScript code
10. STOP: never shipped unconfirmed (Code): runs custom JavaScript code

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

Services it uses

Google SheetsGmail

Before you upgrade to n8n 3.0

Nodes used (8)

• Manual Triggern8n-nodes-base.manualTrigger
• Schedule Triggern8n-nodes-base.scheduleTrigger
• Coden8n-nodes-base.code
• Ifn8n-nodes-base.if
• Google Sheetsn8n-nodes-base.googleSheets
• HTTP Requestn8n-nodes-base.httpRequest
• Gmailn8n-nodes-base.gmail
• No Operation, do nothingn8n-nodes-base.noOp

From the author

Quick overview This workflow runs twice on weekdays (or manually) to read shipping-ready orders from a Google Sheets “Orders” tab, optionally fetch tracking details from ShipStation, and send a tracking email via Gmail, then records the sent timestamp back in…

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