Back to Templates

Automatically Store Shopify Orders in Google Sheets with Telegram Notifications

Created by

RedOne

Last update

Last update 17 days ago

Categories
Share

This workflow is designed for e-commerce store owners, operations managers, and developers who use Shopify as their e-commerce platform and want an automated way to track and analyze their order data.

It is particularly useful for businesses that:

  • Need a centralized view of all Shopify orders
  • Want to analyze order trends without logging into Shopify
  • Need to share order data with team members who don't have Shopify access
  • Want to build custom reports based on order information

What Problem Is This Workflow Solving?

While Shopify provides excellent order management within its platform, many businesses need their order data available in other systems for various purposes:

  • Data accessibility: Not everyone in your organization may have access to Shopify's admin interface
  • Custom reporting: Google Sheets allows for flexible analysis and report creation
  • Data integration: Having orders in Google Sheets makes it easier to combine with other business data
  • Backup: Creates an additional backup of your critical order information

What This Workflow Does

This n8n workflow creates an automated bridge between your Shopify store and Google Sheets:

  • Listens for new order notifications from your Shopify store via webhooks
  • Processes the incoming order data and transforms it into a structured format
  • Stores each new order in a dedicated Google Sheets spreadsheet
  • Sends real-time notifications to Telegram when new orders are received or errors occur

Setup

Create a Google Sheet

  • Create a new Google Sheet to store your orders

  • Add a sheet named "orders" with the following columns:

    • orderId
    • orderNumber
    • created_at
    • processed
    • processed_at
    • json
    • customer
    • shippingAddress
    • lineItems
    • totalPrice
    • currency

Set Up Telegram Bot

  • Create a Telegram bot using BotFather (send /newbot to @BotFather)
  • Save your bot token for use in n8n credentials
  • Start a chat with your bot and get your chat ID (you can use @userinfobot)

Configure the Workflow

  • Set your Google Sheet ID in the "Edit Variables" node
  • Enter your Telegram chat ID in the "Edit Variables" node
  • Set up your Telegram API credentials in n8n

Configure Shopify Webhook

  • In your Shopify admin, go to:
    Settings > Notifications > Webhooks
  • Create a new webhook for "Order creation"
  • Set the URL to your n8n webhook URL (from the "Receive New Shopify Order" node)
  • Set the format to JSON

How to Customize This Workflow to Your Needs

  • Additional data: Modify the "Transform Order Data to Standard Format" function to extract more Shopify data
  • Multiple sheets: Duplicate the Google Sheets node to store different aspects of orders in separate sheets
  • Telegram messages: Customize the text in Telegram nodes to include more details or rich formatting
  • Data processing: Add nodes to perform calculations or transformations on order data
  • Additional notifications: Add more channels like Slack, Discord, or SMS
  • Integrations: Extend the workflow to send order data to other systems like CRMs, ERPs, or accounting software

Final Notes

This workflow serves as a foundation that you can build upon to create a comprehensive order management system tailored to your specific business needs.