{"product_id":"n8n-automation-send-shipstation-tracking-emails-from-google-sheets","title":"n8n Automation: Send ShipStation Tracking Emails from Google Sheets","description":"\u003ch3\u003eAutomatically email ShipStation tracking from Google Sheets (with duplicate protection)\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow reads shipping-ready orders from your Google Sheets “Orders” tab, optionally pulls tracking details from ShipStation, sends a Gmail tracking\/installation email, and writes a “Ship email sent” timestamp back to the sheet—so the same order isn’t emailed twice.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eRuns twice on weekdays\u003c\/b\u003e at \u003cb\u003e08:30\u003c\/b\u003e and \u003cb\u003e16:30\u003c\/b\u003e (or you can start it manually).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eLoads configuration\u003c\/b\u003e and accesses the Google Sheets \u003cb\u003eOrders\u003c\/b\u003e tab (uses demo orders if the sheet isn’t connected).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eFilters eligible rows\u003c\/b\u003e: selects orders where \u003cb\u003eStage = “Shipped”\u003c\/b\u003e, a \u003cb\u003econfirmation timestamp\u003c\/b\u003e is present, and no prior \u003cb\u003eshipping email\u003c\/b\u003e has been recorded.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eObtains tracking data\u003c\/b\u003e: uses the tracking number from the sheet when available; otherwise (when enabled) queries the \u003cb\u003eShipStation API\u003c\/b\u003e to fetch carrier, tracking number, and ship date.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eHandles exceptions\u003c\/b\u003e: stops processing if no tracking number is found, and separately surfaces any rows marked \u003cb\u003eShipped\u003c\/b\u003e that are missing a confirmation timestamp.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSends the email via Gmail\u003c\/b\u003e in test\/live modes, including tracking details and installation information derived from product rules.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eUpdates your sheet\u003c\/b\u003e with carrier, tracking, ship date, and a \u003cb\u003e“Ship email sent”\u003c\/b\u003e timestamp to prevent duplicate sends on future runs.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eEmail customers tracking updates automatically when orders reach \u003cb\u003eShipped\u003c\/b\u003e in your Google Sheets workflow.\u003c\/li\u003e\n  \u003cli\u003eBridge Google Sheets order staging with \u003cb\u003eShipStation\u003c\/b\u003e tracking data for more accurate notifications.\u003c\/li\u003e\n  \u003cli\u003eOperational teams running on n8n to reduce manual “send the tracking email” tasks and ensure idempotency.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eGoogle Sheets\u003c\/b\u003e (read\/update Orders tab using spreadsheet ID + tab name from config)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eGmail\u003c\/b\u003e (send tracking emails; configurable From name and optional Reply-To\/test recipients)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eShipStation API\u003c\/b\u003e (optional tracking lookup)\u003c\/li\u003e\n  \u003cli\u003en8n nodes: \u003cb\u003eif\u003c\/b\u003e, \u003cb\u003ecode\u003c\/b\u003e, \u003cb\u003eno op\u003c\/b\u003e, \u003cb\u003egmail\u003c\/b\u003e, \u003cb\u003esticky note\u003c\/b\u003e, \u003cb\u003ehttp request\u003c\/b\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46081428914355,"sku":"N8N-19868","price":32.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/mZglXO2GbD4-mCeCEOSTh_WndwoCRO.png?v=1790241170","url":"https:\/\/buyflowscripts.com\/products\/n8n-automation-send-shipstation-tracking-emails-from-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}