Track Shopify orders in Google Sheets and send Discord notifications

Name: Track Shopify orders in Google Sheets and send Discord notifications
Availability: InStock
Rating: 4.5 (66 reviews)
Author: moosa

$20/month : Unlimited workflows

2500 executions/month

Try free

THE #1 IN WEB SCRAPING

Scrape any website without limits

Try free

HOSTINGER 🎉 Early Black Friday Deal
DISCOUNT 20%

Self-hosted n8n

Unlimited workflows - from $4.99/mo

Try free

#1 hub for scraping, AI & automation

6000+ actors - $5 credits/mo

Try free

This workflow tracks new Shopify orders in real-time and logs them to a Google Sheet, while also sending a structured order summary to a Discord channel. Perfect for keeping your team and records updated without checking your Shopify admin manually.

✅ Features:

Trigger: Listens to orders/create event via the Shopify Trigger node
Authentication: Uses Shopify Access Token, generated via a custom/private Shopify app
Google Sheets Logging: Automatically appends order details to a sheet with the following columns:
- Order Number
- Customer Email
- Customer Name
- City
- Country
- Order Total
- Currency
- Subtotal
- Tax
- Financial Status
- Payment Gateway
- Order Date
- Line Item Titles
- Line Item Prices
- Order Link
Discord Alerts: Sends a clean and formatted summary to your Discord server
Line Item Extraction: Breaks down item titles and prices into readable format using code
Multi-currency Compatible: Displays currency type dynamically (not hardcoded)

🧩 Nodes Used:

Shopify Trigger (Access Token)
Code — extract line_item_titles and line_item_prices
Google Sheets — Append row
Code (JavaScript) — Format Discord message
Discord — Send message

📒 Sticky Notes:

🛠️ Use your own Google Sheet link and Discord webhook
🔄 You can duplicate and adapt this for orders/updated or refunds/create events
🔐 No hardcoded API keys — credentials managed via UI

🖼️ Sample Outputs

📄 Google Sheet Entry

Order Number	Customer Email	Customer Name	City	Country	Order Total	Currency	Subtotal	Tax	Financial Status	Payment Gateway	Order Date	Line Item Titles	Line Item Prices	Order Link
1003	[email protected]	test name	test city	Pakistan	2522.77	PKR	2174.8	347.97	paid	bogus	2025-07-31T13:45:35-04:00	Selling Plans Ski Wax, The Complete Snowboard, The Complete Snowboard, The Collection Snowboard: Liquid	24.95, 699.95, 699.95, 749.95	View Order

💬 Discord Message Preview

> Tested with Shopify's "Bogus" gateway — works without real card info in a development store.

moosa

0 workflows

Nodes

set gmail telegram agent google-gemini

Complexity

intermediate

Published 01 Aug 2025

Likes 0

View on n8n.io Download Workflow

✨

Share Your Workflow

Have a great workflow to share? Join the n8n Creator Hub and help the community!

Submit Your Template How to Submit

Related Workflows

Create consulting client onboarding tasks with GPT-4o-mini, Google Sheets and Slack

## Who this workflow is for Consulting firms in strategy, management, or IT who want to automate client onboarding and internal task assignment. ## What this workflow does Automatically creates onboarding tasks and checklists using AI, routes them to the right consultant, logs client info in Google Sheets, and sends client welcome emails. Internal teams get Slack notifications, and kickoff meetings can be scheduled automatically. ## How the workflow works 1. New client intake triggers workflow 2. AI generates onboarding checklist 3. Tasks routed based on project type 4. Client info logged in Google Sheets 5. Slack notifications sent to consultants 6. Optional PDF of onboarding sent to client 7. Email confirmation delivered to client 8. Optional CRM integration ## Setup Instructions - Connect Webhook/Form for intake - Connect Google Sheets - Connect OpenAI - Connect Slack and email - Configure optional CRM integration **Author:** Hyrum Hurst, AI Automation Engineer **Company:** QuarterSmart **Contact:** [email protected]

View

Create Bosta shipping orders from Odoo invoices using OpenAI GPT models

## What Problem Does It Solve? - **Manual Data Entry Bottlenecks:** Moving shipping data from Odoo to Bosta manually is slow and prone to errors, especially during high-volume periods. - **Address Mismatches:** Odoo stores addresses as unstructured text, while Bosta requires strict Zone/District IDs. Mismatches lead to failed deliveries and returns. - **Messy Labels:** Long ERP product names look unprofessional on shipping labels. - **This workflow solves these by:** - Instantly creating the shipping order in Bosta when an Odoo invoice is confirmed. - Using an **AI Agent** to intelligently parse raw addresses and map them to the exact Bosta ID. - Ensuring the high operational standards required by automating data cleaning and COD rounding. ## How to Configure It ### 1. Odoo Setup - Create an Automation Rule in Odoo that sends a POST request to this workflow's Webhook URL when an invoice state changes to "Confirmed". ### 2. Credentials - Connect your **Odoo**, **OpenAI**, and **Telegram** accounts in the respective n8n nodes. - Add your **Bosta API Key** in the Header parameters of the `Create Bosta Order` node. ### 3. Product Mapping - Open the `Summarize Items` code node and update the `NAME_MAP` object to link your Odoo product names to short shipping labels. ### 4. Data Table - Ensure the `Fetch Zones` node is connected to your Bosta Zones/Districts data table in n8n. ## How It Works - **Trigger:** The workflow starts automatically when an invoice is confirmed in Odoo. - **Fetch & Process:** It pulls customer details and invoice items, then aggregates quantities (e.g., turning 3 lines of "Shampoo" into "Shampoo (3)"). - **AI Analysis:** The AI Agent cross-references the raw address with the official Bosta zones list to strictly select the correct IDs. - **Execution:** The order is created in Bosta. If successful, the process is complete. - **Error Handling:** If any step fails, a Telegram message is sent immediately with the invoice number to alert the **operations team**. ## Customization Ideas - **Write Back:** Add a node to update the Odoo invoice with the generated Bosta tracking number. - **Multi-Courier:** Add a switch node to route orders to different couriers (e.g., Aramex, Mylerz) based on the city. - **Campaign Logging:** Log successful shipments to a spreadsheet to track fulfillment metrics. - **Notification Channels:** Change the error alert from Telegram to Slack or Email. If you need any help [Get in Touch](https://www.linkedin.com/in/abdallaelshikh0/)

View

Monitor HubSpot deal risk with OpenAI scoring and Slack alerts

## How it works This workflow runs on a daily schedule to analyze all active HubSpot deals and their latest engagement activity. It applies AI-driven behavioral scoring to predict conversion probability and deal health. High-risk or stalled deals automatically trigger Slack alerts. All insights are logged in Google Sheets for forecasting and performance tracking. ## Step-by-step - **Step 1 – Trigger and collect active deals** - **Schedule Trigger** – Runs the workflow automatically at a fixed time each day. - **Get Active Deals from HubSpot** – Retrieves all non-closed deals with key properties like value, stage, and activity dates. - **Formatting Data** – Cleans and normalizes deal data while calculating metrics such as deal age and inactivity duration. - **Step 2 – Enrich deals with engagement data** - **If** – Filters only active deals to ensure closed deals are excluded. - **Loop Over Items** – Processes each deal individually to handle enrichment safely. - **HTTP Request** – Fetches engagement associations linked to each deal. - **Get an engagement** – Retrieves detailed engagement records from HubSpot. - **Extracts Data** – Structures engagement content, timestamps, and internal notes for AI analysis. - **Step 3 – Analyze risk and notify the team** - **AI Agent** – Analyzes behavioral signals and predicts conversion probability, risk level, and next actions. - **Format Data** – Parses the AI output into structured fields and risk indicators. - **Filter Alerts Needed** – Identifies deals that require immediate attention. - **Send Slack Alert** – Sends a detailed alert with risks, signals, and recommended actions. - **Append or update row in sheet** – Stores analysis results in Google Sheets for tracking and forecasting. ## Why use this? - Detect deal risk early using consistent, AI-based analysis - Reduce manual pipeline reviews for sales managers - Provide clear, actionable next steps to sales reps - Keep a historical log of deal health and forecasts - Improve close rates through timely, data-driven intervention

View

👨‍💻

Need Custom Automation?

N8N Automation Expert

Specialized in N8N automation, I design custom workflows that connect your tools and automate your processes.