# Send Shopify POS Orders to Google Sheets 5 min setup No coding required Runs automatically Capture every in-store sale by sending your Shopify POS order data directly to Google Sheets. Track sales patterns, analyze customer behavior, and create custom reports without manual data entry. Perfect for store owners who need real-time visibility into their retail performance and want to build comprehensive sales dashboards. ## How it works 4 steps to start sending POS order details to Google Sheets automatically ### POS Order Created App connector: [Shopify Retail POS](/content/apps/shopify-pos/integrate "View Shopify Retail POS integration page"/index.html)• Time to complete: 0 minutes (Auto-configured) **Why this matters:** This trigger starts the entire workflow whenever someone makes a purchase at your physical store location, capturing the order data that will be sent to your spreadsheet. This step automatically detects when a new POS order is created in your Shopify store and captures all the order information including customer details, line items, pricing, and payment data. No configuration is needed. MESA monitors your POS system continuously and triggers this workflow immediately when an order is placed. The captured order data gets passed to the next step for processing. ### Retrieve Shop App connector: [Shopify](/content/apps/shopify/integrate "View Shopify integration page"/index.html)• Time to complete: 0 minutes (Auto-configured) **Why this matters:** This step gets your store's basic information to provide context for the order data and ensure proper formatting in your spreadsheet. This action automatically pulls your shop's details including the store name and domain information from Shopify. The shop data helps create proper links back to your Shopify admin and provides store context for the order records. ### Loop App connector: [Loop](/content/apps/loop/integrate "View Loop integration page"/index.html)• Time to complete: 1 minute **Why this matters:** This step processes each individual product in the POS order separately, creating one spreadsheet row per item purchased instead of lumping everything together. The loop step takes the line items from the POS order and processes each product individually, allowing you to track inventory movement and sales at the product level. MESA automatically iterates through every item in the order, extracting details like product title, SKU, price, and quantity for each one. ### Add Row App connector: [Google Sheets](/content/apps/googlesheets/integrate "View Google Sheets integration page"/index.html)• Time to complete: 2 minutes **Why this matters:** This step actually creates the spreadsheet entries with your POS data, formatted exactly how you want to see it for tracking sales and inventory. This action creates a new Google Sheets spreadsheet (with the name you specify) and adds a row for each line item from your POS orders. You'll configure which columns to include from options like order date, customer email, product title, SKU, price, payment method, and location ID. The default selection includes all available fields, but you can uncheck any columns you don't need. You'll also set your spreadsheet name during setup - choose something descriptive like "POS Sales Tracking 2024" or "Store Location Orders." ## Frequently asked questions ### Will this create a separate row for each product in multi-item orders? Yes, the Loop step processes each line item individually, so if someone buys 3 different products in one POS transaction, you'll get 3 separate rows in your spreadsheet - one for each product with its own pricing and details. ### Can I track sales from multiple store locations in the same spreadsheet? Absolutely. The workflow includes a "POS Location ID" field that identifies which physical location each sale came from, so you can filter and analyze performance across all your store locations in one sheet. ### What happens if my Google Sheets spreadsheet gets deleted or corrupted? The workflow will automatically create a new spreadsheet with your specified name the next time a POS order comes in. However, you'll lose historical data, so consider making regular backups of important sales tracking spreadsheets. ## Make this template your own! Customize this workflow even further: - Schedule weekly sales reports - Filter by high-value orders - Sync with inventory management - Create customer follow-up campaigns ## You're in good company Avg. App Store rating 4.9/5 Merchant reviews 157 Avg. time saved per week 3.5 hrs "MESA has been a game changer for us. And, if you ever get stuck, their support team is always super helpful." **PetFriendly** "It's like Zapier but exactly designed for Shopify. I have been able to complete all the workflows that I've needed." **Zailys** "The MESA team has been amazing at helping us set up our automations. We would highly recommend this app!" **Rothy's** ## Ready to start sending POS order details to Google Sheets automatically? 7-day free trial • 5 min setup • Cancel anytime Need help? Our automation experts will help you personalize this workflow for free.