{"id":2428,"date":"2021-07-07T17:54:05","date_gmt":"2021-07-07T17:54:05","guid":{"rendered":"http:\/\/www.getmesa.com/blog\/blog\/?p=2428"},"modified":"2025-12-22T23:55:44","modified_gmt":"2025-12-22T23:55:44","slug":"how-to-export-delivered-orders-details-into-google-sheets","status":"publish","type":"post","link":"https:\/\/www.getmesa.com/blog\/how-to-export-delivered-orders-details-into-google-sheets\/","title":{"rendered":"How to export Shopify orders to Google Sheets when they&#8217;re delivered"},"content":{"rendered":"\n<p>Using MESA, this tutorial will show how to export Shopify orders and fulfillment details from the <a href=\"https:\/\/www.getmesa.com\/apps\/shopify\/integrate\/tracktor\">order tracking app<\/a>,&nbsp;Tracktor, into <a href=\"https:\/\/www.getmesa.com\/apps\/shopify\/integrate\/google-sheets\">Google Sheets<\/a> in a few quick steps. Since Shopify isn&#8217;t aware of fulfillment status, we need to use the Tracktor app to start this workflow, not Shopify. However, another great tutorial is learning how to simply <a href=\"https:\/\/www.getmesa.com\/blog\/how-to-connect-shopify-orders-to-google-sheets\/\">export orders from Shopify to Google Sheets<\/a> if that&#8217;s all you&#8217;re after.<\/p>\n\n\n\n<p class=\"inline-cta\"><a href=\"http:\/\/app.getmesa.com\/install\" target=\"_blank\" rel=\"noreferrer noopener\">Try MESA free<\/a> for 7-days and enjoy support from automation experts!<\/p>\n\n\n\n<p id=\"h-start-with-the-pre-made-workflow-template\">Start with the <a href=\"https:\/\/www.getmesa.com\/templates\">pre-made workflow<\/a> template:<\/p>\n\n\n<div class=\"mesa-template-backend frontend-hidden\">\n    <p><strong>MESA Template ID<\/strong><\/p>\n    <p>export-delivered-order-fulfillment-to-google-sheets<\/p>\n<\/div>\n\n<div class=\"mesa-template\" data-template=\"export-delivered-order-fulfillment-to-google-sheets\"><\/div>\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\t\t<style>.mesa-template-backend {\n    background: rgba(139, 139, 150, 0.1);\n    padding: 22px;\n}\n\n.mesa-template-backend h5,\n.mesa-template-backend p {\n    margin: 0 0 5px;\n}\n\n.mesa-template-backend p {\n    font-size: 16px;\n}\n\n.mesa-template-backend p:last-child {\n    display: inline-block;\n    background: #fff;\n    padding: 5px 10px;\n}\n\n.mesa-template-backend p strong {\n    font-size: 12px;\n}<\/style>\n\t\t\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_83 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">In this article:<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.getmesa.com/blog\/how-to-export-delivered-orders-details-into-google-sheets\/#Step-by-step-instructions-Export-Shopify-orders-to-Google-Sheets\" >Step-by-step instructions: Export Shopify orders to Google Sheets<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.getmesa.com/blog\/how-to-export-delivered-orders-details-into-google-sheets\/#More-Built-in-Analytics\" >More Built-in Analytics<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.getmesa.com/blog\/how-to-export-delivered-orders-details-into-google-sheets\/#Workflow-Wrap-Up\" >Workflow Wrap Up<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h3 class=\"wp-block-heading\" id=\"h-step-by-step-instructions-export-shopify-orders-to-google-sheets\"><span class=\"ez-toc-section\" id=\"Step-by-step-instructions-Export-Shopify-orders-to-Google-Sheets\"><\/span>Step-by-step instructions: Export Shopify orders to Google Sheets<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<div class=\"schema-how-to wp-block-yoast-how-to-block\"><p class=\"schema-how-to-total-time\"><span class=\"schema-how-to-duration-time-text\">Time needed:&nbsp;<\/span>15 minutes<\/p><p class=\"schema-how-to-description\">These step-by-step instructions will connect Shopify fulfillments to Google Sheets. <a href=\"http:\/\/apps.getmesa.com\/install\" target=\"_blank\" rel=\"noreferrer noopener\">Install MESA<\/a> on your Shopify store before proceeding.<\/p> <ol class=\"schema-how-to-steps\"><li class=\"schema-how-to-step\" id=\"how-to-step-1661105241114\"><strong class=\"schema-how-to-step-name\">First, add the workflow template<\/strong> <p class=\"schema-how-to-step-text\">From the MESA Discovery tab, type in &#8220;export order&#8221; in the\u00a0search<em>\u00a0<\/em>field and select the template from the drop-down menu.\u00a0<img loading=\"lazy\" decoding=\"async\" width=\"1194\" height=\"706\" class=\"wp-image-5138\" alt=\"export-fulfilled-shopify-orders\" src=\"https:\/\/www.getmesa.com\/blog\/wp-content\/uploads\/export-shopify-orders-to-google-sheets-template-1.png\" style=\"max-width:100%;\" srcset=\"https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/export-shopify-orders-to-google-sheets-template-1.png 1194w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/export-shopify-orders-to-google-sheets-template-1-300x177.png 300w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/export-shopify-orders-to-google-sheets-template-1-1024x605.png 1024w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/export-shopify-orders-to-google-sheets-template-1-768x454.png 768w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/export-shopify-orders-to-google-sheets-template-1-526x311.png 526w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/export-shopify-orders-to-google-sheets-template-1-338x200.png 338w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/export-shopify-orders-to-google-sheets-template-1-727x430.png 727w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/export-shopify-orders-to-google-sheets-template-1-271x160.png 271w\" sizes=\"auto, (max-width: 1194px) 100vw, 1194px\" \/><\/p> <\/li><li class=\"schema-how-to-step\" id=\"how-to-step-1661106002964\"><strong class=\"schema-how-to-step-name\">Next, add your Google Sheets credentials<\/strong> <p class=\"schema-how-to-step-text\">Select from the dropdown list or click the <strong>Add New Credential<\/strong> button to save your login details.<br\/><img loading=\"lazy\" decoding=\"async\" width=\"683\" height=\"745\" class=\"wp-image-5139\" style=\"max-width:100%;\" src=\"https:\/\/www.getmesa.com\/blog\/wp-content\/uploads\/export-shopify-orders-to-google-sheets-authenticate.png\" alt=\"export shopify order to google sheets authentication\" srcset=\"https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/export-shopify-orders-to-google-sheets-authenticate.png 683w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/export-shopify-orders-to-google-sheets-authenticate-275x300.png 275w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/export-shopify-orders-to-google-sheets-authenticate-285x311.png 285w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/export-shopify-orders-to-google-sheets-authenticate-183x200.png 183w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/export-shopify-orders-to-google-sheets-authenticate-394x430.png 394w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/export-shopify-orders-to-google-sheets-authenticate-147x160.png 147w\" sizes=\"auto, (max-width: 683px) 100vw, 683px\" \/><\/p> <\/li><li class=\"schema-how-to-step\" id=\"how-to-step-1661106118758\"><strong class=\"schema-how-to-step-name\">View and Copy this Google Sheet sample file<\/strong> <p class=\"schema-how-to-step-text\"><a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1n7hr8myUjDg4zms6PgY2BAMLiS0BC4K2FqdsJk_v2zk\/copy\" target=\"_blank\" rel=\"noreferrer noopener\">View this Google Sheet<\/a> and make a copy to your Google Sheets account.<img loading=\"lazy\" decoding=\"async\" width=\"782\" height=\"500\" class=\"wp-image-5141\" alt=\"Copy Google Sheets sample\" src=\"https:\/\/www.getmesa.com\/blog\/wp-content\/uploads\/copy-google-sheet-sample-1.png\" style=\"max-width:100%;\" srcset=\"https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/copy-google-sheet-sample-1.png 782w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/copy-google-sheet-sample-1-300x192.png 300w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/copy-google-sheet-sample-1-768x491.png 768w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/copy-google-sheet-sample-1-486x311.png 486w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/copy-google-sheet-sample-1-313x200.png 313w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/copy-google-sheet-sample-1-673x430.png 673w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/copy-google-sheet-sample-1-250x160.png 250w\" sizes=\"auto, (max-width: 782px) 100vw, 782px\" \/><\/p> <\/li><li class=\"schema-how-to-step\" id=\"how-to-step-1661106324118\"><strong class=\"schema-how-to-step-name\">Optionally, change the title of your sample Google Sheets file.<\/strong> <p class=\"schema-how-to-step-text\">Now might also be a good time to change the <strong>title of your Google Sheet<\/strong> from &#8220;Copy of Order and Fulfillment Details of Delivered Orders,&#8221; to something more specific to your brand. You&#8217;ll need to reference it later.<br\/><img loading=\"lazy\" decoding=\"async\" width=\"798\" height=\"273\" class=\"wp-image-5142\" alt=\"Google Sheets sample\" src=\"https:\/\/www.getmesa.com\/blog\/wp-content\/uploads\/google-sheet-sample-title.png\" style=\"max-width:100%;\" srcset=\"https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/google-sheet-sample-title.png 798w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/google-sheet-sample-title-300x103.png 300w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/google-sheet-sample-title-768x263.png 768w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/google-sheet-sample-title-555x190.png 555w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/google-sheet-sample-title-360x123.png 360w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/google-sheet-sample-title-290x99.png 290w\" sizes=\"auto, (max-width: 798px) 100vw, 798px\" \/><\/p> <\/li><li class=\"schema-how-to-step\" id=\"how-to-step-1661106470079\"><strong class=\"schema-how-to-step-name\">Return to your workflow, choose the newly copied Google Sheets file for Fulfillments.<\/strong> <p class=\"schema-how-to-step-text\">Under the Google Sheets &#8211; Create Row &#8211; Fulfillments step, select the existing file that was just copied to your account and choose\u00a0<strong>Fulfillments<\/strong>\u00a0on the Sheet Name field. Click <strong>Done<\/strong> when completed.<br\/><img loading=\"lazy\" decoding=\"async\" width=\"683\" height=\"787\" class=\"wp-image-5144\" style=\"max-width:100%;\" src=\"https:\/\/www.getmesa.com\/blog\/wp-content\/uploads\/google-sheet-file-selected-fields.png\" alt=\"Google Sheets selected fields\" srcset=\"https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/google-sheet-file-selected-fields.png 683w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/google-sheet-file-selected-fields-260x300.png 260w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/google-sheet-file-selected-fields-270x311.png 270w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/google-sheet-file-selected-fields-174x200.png 174w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/google-sheet-file-selected-fields-373x430.png 373w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/google-sheet-file-selected-fields-139x160.png 139w\" sizes=\"auto, (max-width: 683px) 100vw, 683px\" \/><\/p> <\/li><li class=\"schema-how-to-step\" id=\"how-to-step-1661106778764\"><strong class=\"schema-how-to-step-name\">Next, choose the newly copied Google Sheets file for Orders<\/strong> <p class=\"schema-how-to-step-text\">For the <strong>Google Sheets Create Row &#8211; Orders <\/strong>step, you&#8217;ll need to do similar to what you did for Google Sheets Create Row &#8211; Fullfilments, except this time you&#8217;ll input &#8220;Orders&#8221; for the Sheet Name*.<br\/><img loading=\"lazy\" decoding=\"async\" width=\"665\" height=\"780\" class=\"wp-image-5145\" style=\"max-width:100%;\" src=\"https:\/\/www.getmesa.com\/blog\/wp-content\/uploads\/google-sheet-file-orders-fields.png\" alt=\"google sheets orders fields\" srcset=\"https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/google-sheet-file-orders-fields.png 665w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/google-sheet-file-orders-fields-256x300.png 256w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/google-sheet-file-orders-fields-265x311.png 265w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/google-sheet-file-orders-fields-171x200.png 171w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/google-sheet-file-orders-fields-367x430.png 367w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/google-sheet-file-orders-fields-136x160.png 136w\" sizes=\"auto, (max-width: 665px) 100vw, 665px\" \/><\/p> <\/li><li class=\"schema-how-to-step\" id=\"how-to-step-1661106915258\"><strong class=\"schema-how-to-step-name\">Lastly, Save and Enable your automation.<\/strong> <p class=\"schema-how-to-step-text\">Click the \u201cSave\u201d button to keep the existing or any optional configuration changes to this workflow.<br\/><br\/>Finally, be sure to enable this automation by turning it \u201cOn\u201d so this automation runs every time a new fulfillment status is updated. MESA will proudly celebrate your achievement by popping confetti in your honor. Congratulations!<img loading=\"lazy\" decoding=\"async\" width=\"1194\" height=\"1019\" class=\"wp-image-5146\" alt=\"export shopify order to google sheets automation\" src=\"https:\/\/www.getmesa.com\/blog\/wp-content\/uploads\/export-shopify-orders-to-google-sheets-automation.png\" style=\"max-width:100%;\" srcset=\"https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/export-shopify-orders-to-google-sheets-automation.png 1194w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/export-shopify-orders-to-google-sheets-automation-300x256.png 300w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/export-shopify-orders-to-google-sheets-automation-1024x874.png 1024w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/export-shopify-orders-to-google-sheets-automation-768x655.png 768w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/export-shopify-orders-to-google-sheets-automation-364x311.png 364w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/export-shopify-orders-to-google-sheets-automation-234x200.png 234w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/export-shopify-orders-to-google-sheets-automation-504x430.png 504w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/export-shopify-orders-to-google-sheets-automation-187x160.png 187w\" sizes=\"auto, (max-width: 1194px) 100vw, 1194px\" \/><\/p> <\/li><\/ol><\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-more-built-in-analytics\"><span class=\"ez-toc-section\" id=\"More-Built-in-Analytics\"><\/span>More Built-in Analytics<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>This workflow comes with some major added benefits. You&#8217;ll now be able to dig into order and fulfillment analytics previously unavailable. Filter orders by the number of days and view graphs of shipping by country, state, or province:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized border\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"344\" src=\"https:\/\/www.getmesa.com\/blog\/wp-content\/uploads\/how-to-export-shopify-orders-to-google-sheets-when-they-re-delivered-9-1024x344.png\" alt=\"Shopify Orders Analytics\" class=\"wp-image-2474\" srcset=\"https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/how-to-export-shopify-orders-to-google-sheets-when-they-re-delivered-9-1024x344.png 1024w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/how-to-export-shopify-orders-to-google-sheets-when-they-re-delivered-9-300x101.png 300w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/how-to-export-shopify-orders-to-google-sheets-when-they-re-delivered-9-768x258.png 768w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/how-to-export-shopify-orders-to-google-sheets-when-they-re-delivered-9-1536x516.png 1536w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/how-to-export-shopify-orders-to-google-sheets-when-they-re-delivered-9-555x187.png 555w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/how-to-export-shopify-orders-to-google-sheets-when-they-re-delivered-9-360x121.png 360w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/how-to-export-shopify-orders-to-google-sheets-when-they-re-delivered-9-960x323.png 960w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/how-to-export-shopify-orders-to-google-sheets-when-they-re-delivered-9-290x97.png 290w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/how-to-export-shopify-orders-to-google-sheets-when-they-re-delivered-9.png 1714w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\">Shopify Orders Analytics<\/figcaption><\/figure>\n\n\n\n<p>The workflow can even break down the number of fulfillments by each carrier and the average number of days to delivery by carrier:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized border\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"413\" src=\"https:\/\/www.getmesa.com\/blog\/wp-content\/uploads\/how-to-export-shopify-orders-to-google-sheets-when-they-re-delivered-2-1024x413.png\" alt=\"Shopify Fulfillment Analytics\" class=\"wp-image-2475\" srcset=\"https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/how-to-export-shopify-orders-to-google-sheets-when-they-re-delivered-2-1024x413.png 1024w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/how-to-export-shopify-orders-to-google-sheets-when-they-re-delivered-2-300x121.png 300w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/how-to-export-shopify-orders-to-google-sheets-when-they-re-delivered-2-768x310.png 768w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/how-to-export-shopify-orders-to-google-sheets-when-they-re-delivered-2-1536x620.png 1536w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/how-to-export-shopify-orders-to-google-sheets-when-they-re-delivered-2-555x224.png 555w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/how-to-export-shopify-orders-to-google-sheets-when-they-re-delivered-2-360x145.png 360w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/how-to-export-shopify-orders-to-google-sheets-when-they-re-delivered-2-960x387.png 960w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/how-to-export-shopify-orders-to-google-sheets-when-they-re-delivered-2-290x117.png 290w, https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/how-to-export-shopify-orders-to-google-sheets-when-they-re-delivered-2.png 1777w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\">Shopify Fulfillment Analytics<\/figcaption><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-workflow-wrap-up\"><span class=\"ez-toc-section\" id=\"Workflow-Wrap-Up\"><\/span>Workflow Wrap Up<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Now each delivered product from Tracktor will have a new row added in Google Sheets with order details. Every step in this workflow is 100% customizable. Change an event, add a step before\/after or adjust the default settings. <\/p>\n\n\n\n<div class=\"card-next-steps\">\n\t<div class=\"card__content\">\n\t\t<h4>What to do next&#8230;<\/h4>\n<p>The fastest way to see automation working in your store is to start with a single workflow.<\/p>\n<ol>\n<li><a href=\"https:\/\/www.getmesa.com\/pricing\"><strong>Try MESA free<\/strong><\/a> \u2014 start a 7-day free trial and get your first workflow running.<\/li>\n<li><a href=\"https:\/\/www.getmesa.com\/templates\"><strong>Browse the template library<\/strong><\/a> \u2014 pre-built workflows for the most common Shopify automation tasks.<\/li>\n<li><a href=\"https:\/\/www.getmesa.com\/yedric\"><strong>Talk to Yedric<\/strong><\/a> \u2014 describe what you want to automate, and let our AI assistant build it for you.<\/li>\n<li><a href=\"https:\/\/www.getmesa.com\/support\"><strong>Get free workflow setup<\/strong><\/a> \u2014 MESA&#8217;s team will build your first workflow at no cost.<\/li>\n<\/ol>\n\t<\/div><!-- \/.card__content -->\n\n\t\n<div class=\"socials card__socials\">\n\t<ul>\n\t\t\t\t\t<li>\n\t\t\t\t<a href=\"https:\/\/twitter.com\/getmesa\" target=\"_blank\">\n\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/twitter-icon.svg\" class=\"attachment-small size-small\" alt=\"icon: twitter\" \/>\t\t\t\t<\/a>\n\t\t\t<\/li>\n\t\t\t\t\t<li>\n\t\t\t\t<a href=\"https:\/\/www.youtube.com\/@getmesa\" target=\"_blank\">\n\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/youtube-icon.svg\" class=\"attachment-small size-small\" alt=\"icon: youtube\" \/>\t\t\t\t<\/a>\n\t\t\t<\/li>\n\t\t\t\t\t<li>\n\t\t\t\t<a href=\"https:\/\/www.linkedin.com\/company\/9754608\/\" target=\"_blank\">\n\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/linkedin-icon.svg\" class=\"attachment-small size-small\" alt=\"linkedin icon\" \/>\t\t\t\t<\/a>\n\t\t\t<\/li>\n\t\t\t<\/ul>\n<\/div><!-- \/.socials -->\n<\/div><!-- \/.card-next-steps -->\n","protected":false},"excerpt":{"rendered":"<p>Using MESA, this tutorial will show how to export Shopify orders and fulfillment details from the order tracking app,&nbsp;Tracktor, into&#8230;<\/p>\n","protected":false},"author":2,"featured_media":3999,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[48],"tags":[24,13],"class_list":["post-2428","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-workflow-tutorials","tag-google-sheets","tag-tracktor"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.5 (Yoast SEO v27.6) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>How to export Shopify orders to Google Sheets when they&#039;re delivered - MESA<\/title>\n<meta name=\"description\" content=\"This tutorial shows you how to export Shopify orders and fulfillment details into Google Sheets in just a few quick steps.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.getmesa.com\/blog\/how-to-export-delivered-orders-details-into-google-sheets\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to export Shopify orders to Google Sheets when they&#039;re delivered\" \/>\n<meta property=\"og:description\" content=\"Using MESA, this tutorial will show how to export Shopify orders and fulfillment details from the order tracking app,&nbsp;Tracktor, into Google Sheets in\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.getmesa.com\/blog\/how-to-export-delivered-orders-details-into-google-sheets\/\" \/>\n<meta property=\"og:site_name\" content=\"MESA\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/web.facebook.com\/mesabyshoppad\/\" \/>\n<meta property=\"article:published_time\" content=\"2021-07-07T17:54:05+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-12-22T23:55:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.getmesa.com\/blog\/wp-content\/uploads\/how-to-export-shopify-orders-to-google-sheets-when-they-re-delivered-4.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Jen Sparks\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@getmesa\" \/>\n<meta name=\"twitter:site\" content=\"@getmesa\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jen Sparks\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/how-to-export-delivered-orders-details-into-google-sheets\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/how-to-export-delivered-orders-details-into-google-sheets\\\/\"},\"author\":{\"name\":\"Jen Sparks\",\"@id\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/#\\\/schema\\\/person\\\/86b06a380463c50cec7c545fa8205f61\"},\"headline\":\"How to export Shopify orders to Google Sheets when they&#8217;re delivered\",\"datePublished\":\"2021-07-07T17:54:05+00:00\",\"dateModified\":\"2025-12-22T23:55:44+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/how-to-export-delivered-orders-details-into-google-sheets\\\/\"},\"wordCount\":513,\"publisher\":{\"@id\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/how-to-export-delivered-orders-details-into-google-sheets\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.getmesa.com/blog\\\/wp-content\\\/uploads\\\/how-to-export-shopify-orders-to-google-sheets-when-they-re-delivered-4.png\",\"keywords\":[\"google sheets\",\"tracktor\"],\"articleSection\":[\"Workflow Tutorials\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/how-to-export-delivered-orders-details-into-google-sheets\\\/\",\"url\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/how-to-export-delivered-orders-details-into-google-sheets\\\/\",\"name\":\"How to export Shopify orders to Google Sheets when they're delivered - MESA\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/how-to-export-delivered-orders-details-into-google-sheets\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/how-to-export-delivered-orders-details-into-google-sheets\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.getmesa.com/blog\\\/wp-content\\\/uploads\\\/how-to-export-shopify-orders-to-google-sheets-when-they-re-delivered-4.png\",\"datePublished\":\"2021-07-07T17:54:05+00:00\",\"dateModified\":\"2025-12-22T23:55:44+00:00\",\"description\":\"This tutorial shows you how to export Shopify orders and fulfillment details into Google Sheets in just a few quick steps.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/how-to-export-delivered-orders-details-into-google-sheets\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/how-to-export-delivered-orders-details-into-google-sheets\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/how-to-export-delivered-orders-details-into-google-sheets\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.getmesa.com/blog\\\/wp-content\\\/uploads\\\/how-to-export-shopify-orders-to-google-sheets-when-they-re-delivered-4.png\",\"contentUrl\":\"https:\\\/\\\/www.getmesa.com/blog\\\/wp-content\\\/uploads\\\/how-to-export-shopify-orders-to-google-sheets-when-they-re-delivered-4.png\",\"width\":1280,\"height\":720,\"caption\":\"MESA Workflow: Tracktor to Google Sheets\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/how-to-export-delivered-orders-details-into-google-sheets\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to export Shopify orders to Google Sheets when they&#8217;re delivered\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/\",\"name\":\"MESA\",\"description\":\"Discover how to automate your Shopify growth\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/#organization\",\"name\":\"MESA - AI automation Platform\",\"url\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/wp-content\\\/uploads\\\/mesa-shoppad.jpeg\",\"contentUrl\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/wp-content\\\/uploads\\\/mesa-shoppad.jpeg\",\"width\":225,\"height\":225,\"caption\":\"MESA - AI automation Platform\"},\"image\":{\"@id\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/web.facebook.com\\\/mesabyshoppad\\\/\",\"https:\\\/\\\/x.com\\\/getmesa\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/shoppad\\\/\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCqsf_WhcGEsZMvms1idivyw\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/#\\\/schema\\\/person\\\/86b06a380463c50cec7c545fa8205f61\",\"name\":\"Jen Sparks\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/91c7269d578c2e4afe5f6f1d04ea060e77450abfbec1f39f5db50068c3d15a17?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/91c7269d578c2e4afe5f6f1d04ea060e77450abfbec1f39f5db50068c3d15a17?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/91c7269d578c2e4afe5f6f1d04ea060e77450abfbec1f39f5db50068c3d15a17?s=96&d=mm&r=g\",\"caption\":\"Jen Sparks\"},\"description\":\"Project Wizard @ ShopPad, Green &amp; Gold Fanatic, Designaholic, Homebrewer, Seeker of Vegetarian Food Trucks, Lady Extraordinaire.\",\"sameAs\":[\"https:\\\/\\\/www.getmesa.com\"],\"jobTitle\":\"Product Manager\",\"worksFor\":\"MESA\"},{\"@type\":\"HowTo\",\"@id\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/how-to-export-delivered-orders-details-into-google-sheets\\\/#howto-1\",\"name\":\"How to export Shopify orders to Google Sheets when they&#8217;re delivered\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/how-to-export-delivered-orders-details-into-google-sheets\\\/#article\"},\"description\":\"These step-by-step instructions will connect Shopify fulfillments to Google Sheets. &lt;a href=\\\"http:\\\/\\\/apps.getmesa.com\\\/install\\\" target=\\\"_blank\\\" rel=\\\"noreferrer noopener\\\">Install MESA&lt;\\\/a> on your Shopify store before proceeding.\",\"totalTime\":\"P0DT0H15M\",\"step\":[{\"@type\":\"HowToStep\",\"url\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/how-to-export-delivered-orders-details-into-google-sheets\\\/#how-to-step-1661105241114\",\"name\":\"First, add the workflow template\",\"itemListElement\":[{\"@type\":\"HowToDirection\",\"text\":\"From the MESA Discovery tab, type in \\\"export order\\\" in the\u00a0search\u00a0field and select the template from the drop-down menu.\u00a0\"}],\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/how-to-export-delivered-orders-details-into-google-sheets\\\/#schema-image-4bfc140be6e15a6d5f29fdbe20e382c4\",\"url\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/wp-content\\\/uploads\\\/export-shopify-orders-to-google-sheets-template-1.png\",\"contentUrl\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/wp-content\\\/uploads\\\/export-shopify-orders-to-google-sheets-template-1.png\"}},{\"@type\":\"HowToStep\",\"url\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/how-to-export-delivered-orders-details-into-google-sheets\\\/#how-to-step-1661106002964\",\"name\":\"Next, add your Google Sheets credentials\",\"itemListElement\":[{\"@type\":\"HowToDirection\",\"text\":\"Select from the dropdown list or click the Add New Credential button to save your login details.\"}],\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/how-to-export-delivered-orders-details-into-google-sheets\\\/#schema-image-c00d170a93c423330664308487150f3d\",\"url\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/wp-content\\\/uploads\\\/export-shopify-orders-to-google-sheets-authenticate.png\",\"contentUrl\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/wp-content\\\/uploads\\\/export-shopify-orders-to-google-sheets-authenticate.png\"}},{\"@type\":\"HowToStep\",\"url\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/how-to-export-delivered-orders-details-into-google-sheets\\\/#how-to-step-1661106118758\",\"name\":\"View and Copy this Google Sheet sample file\",\"itemListElement\":[{\"@type\":\"HowToDirection\",\"text\":\"View this Google Sheet and make a copy to your Google Sheets account.\"}],\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/how-to-export-delivered-orders-details-into-google-sheets\\\/#schema-image-de1b6d2f49ff608afa2d9dafd1c3c258\",\"url\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/wp-content\\\/uploads\\\/copy-google-sheet-sample-1.png\",\"contentUrl\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/wp-content\\\/uploads\\\/copy-google-sheet-sample-1.png\"}},{\"@type\":\"HowToStep\",\"url\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/how-to-export-delivered-orders-details-into-google-sheets\\\/#how-to-step-1661106324118\",\"name\":\"Optionally, change the title of your sample Google Sheets file.\",\"itemListElement\":[{\"@type\":\"HowToDirection\",\"text\":\"Now might also be a good time to change the title of your Google Sheet from \\\"Copy of Order and Fulfillment Details of Delivered Orders,\\\" to something more specific to your brand. You'll need to reference it later.\"}],\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/how-to-export-delivered-orders-details-into-google-sheets\\\/#schema-image-c18d8d52bbfadf51d10cc98a197d6e4a\",\"url\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/wp-content\\\/uploads\\\/google-sheet-sample-title.png\",\"contentUrl\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/wp-content\\\/uploads\\\/google-sheet-sample-title.png\"}},{\"@type\":\"HowToStep\",\"url\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/how-to-export-delivered-orders-details-into-google-sheets\\\/#how-to-step-1661106470079\",\"name\":\"Return to your workflow, choose the newly copied Google Sheets file for Fulfillments.\",\"itemListElement\":[{\"@type\":\"HowToDirection\",\"text\":\"Under the Google Sheets - Create Row - Fulfillments step, select the existing file that was just copied to your account and choose\u00a0Fulfillments\u00a0on the Sheet Name field. Click Done when completed.\"}],\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/how-to-export-delivered-orders-details-into-google-sheets\\\/#schema-image-a1f9af400d77cc140f181e1238878fd3\",\"url\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/wp-content\\\/uploads\\\/google-sheet-file-selected-fields.png\",\"contentUrl\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/wp-content\\\/uploads\\\/google-sheet-file-selected-fields.png\"}},{\"@type\":\"HowToStep\",\"url\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/how-to-export-delivered-orders-details-into-google-sheets\\\/#how-to-step-1661106778764\",\"name\":\"Next, choose the newly copied Google Sheets file for Orders\",\"itemListElement\":[{\"@type\":\"HowToDirection\",\"text\":\"For the Google Sheets Create Row - Orders step, you'll need to do similar to what you did for Google Sheets Create Row - Fullfilments, except this time you'll input \\\"Orders\\\" for the Sheet Name*.\"}],\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/how-to-export-delivered-orders-details-into-google-sheets\\\/#schema-image-dc3ee7a921c64cf62169b1618abda3eb\",\"url\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/wp-content\\\/uploads\\\/google-sheet-file-orders-fields.png\",\"contentUrl\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/wp-content\\\/uploads\\\/google-sheet-file-orders-fields.png\"}},{\"@type\":\"HowToStep\",\"url\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/how-to-export-delivered-orders-details-into-google-sheets\\\/#how-to-step-1661106915258\",\"name\":\"Lastly, Save and Enable your automation.\",\"itemListElement\":[{\"@type\":\"HowToDirection\",\"text\":\"Click the \u201cSave\u201d button to keep the existing or any optional configuration changes to this workflow.Finally, be sure to enable this automation by turning it \u201cOn\u201d so this automation runs every time a new fulfillment status is updated. MESA will proudly celebrate your achievement by popping confetti in your honor. Congratulations!\"}],\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/how-to-export-delivered-orders-details-into-google-sheets\\\/#schema-image-39db2d2bb2d271787a5a8939a0d42d2a\",\"url\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/wp-content\\\/uploads\\\/export-shopify-orders-to-google-sheets-automation.png\",\"contentUrl\":\"https:\\\/\\\/www.getmesa.com\\\/blog\\\/wp-content\\\/uploads\\\/export-shopify-orders-to-google-sheets-automation.png\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to export Shopify orders to Google Sheets when they're delivered - MESA","description":"This tutorial shows you how to export Shopify orders and fulfillment details into Google Sheets in just a few quick steps.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.getmesa.com\/blog\/how-to-export-delivered-orders-details-into-google-sheets\/","og_locale":"en_US","og_type":"article","og_title":"How to export Shopify orders to Google Sheets when they're delivered","og_description":"Using MESA, this tutorial will show how to export Shopify orders and fulfillment details from the order tracking app,&nbsp;Tracktor, into Google Sheets in","og_url":"https:\/\/www.getmesa.com\/blog\/how-to-export-delivered-orders-details-into-google-sheets\/","og_site_name":"MESA","article_publisher":"https:\/\/web.facebook.com\/mesabyshoppad\/","article_published_time":"2021-07-07T17:54:05+00:00","article_modified_time":"2025-12-22T23:55:44+00:00","og_image":[{"width":1280,"height":720,"url":"https:\/\/www.getmesa.com\/blog\/wp-content\/uploads\/how-to-export-shopify-orders-to-google-sheets-when-they-re-delivered-4.png","type":"image\/png"}],"author":"Jen Sparks","twitter_card":"summary_large_image","twitter_creator":"@getmesa","twitter_site":"@getmesa","twitter_misc":{"Written by":"Jen Sparks","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.getmesa.com\/blog\/how-to-export-delivered-orders-details-into-google-sheets\/#article","isPartOf":{"@id":"https:\/\/www.getmesa.com\/blog\/how-to-export-delivered-orders-details-into-google-sheets\/"},"author":{"name":"Jen Sparks","@id":"https:\/\/www.getmesa.com\/blog\/#\/schema\/person\/86b06a380463c50cec7c545fa8205f61"},"headline":"How to export Shopify orders to Google Sheets when they&#8217;re delivered","datePublished":"2021-07-07T17:54:05+00:00","dateModified":"2025-12-22T23:55:44+00:00","mainEntityOfPage":{"@id":"https:\/\/www.getmesa.com\/blog\/how-to-export-delivered-orders-details-into-google-sheets\/"},"wordCount":513,"publisher":{"@id":"https:\/\/www.getmesa.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.getmesa.com\/blog\/how-to-export-delivered-orders-details-into-google-sheets\/#primaryimage"},"thumbnailUrl":"https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/how-to-export-shopify-orders-to-google-sheets-when-they-re-delivered-4.png","keywords":["google sheets","tracktor"],"articleSection":["Workflow Tutorials"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.getmesa.com\/blog\/how-to-export-delivered-orders-details-into-google-sheets\/","url":"https:\/\/www.getmesa.com\/blog\/how-to-export-delivered-orders-details-into-google-sheets\/","name":"How to export Shopify orders to Google Sheets when they're delivered - MESA","isPartOf":{"@id":"https:\/\/www.getmesa.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.getmesa.com\/blog\/how-to-export-delivered-orders-details-into-google-sheets\/#primaryimage"},"image":{"@id":"https:\/\/www.getmesa.com\/blog\/how-to-export-delivered-orders-details-into-google-sheets\/#primaryimage"},"thumbnailUrl":"https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/how-to-export-shopify-orders-to-google-sheets-when-they-re-delivered-4.png","datePublished":"2021-07-07T17:54:05+00:00","dateModified":"2025-12-22T23:55:44+00:00","description":"This tutorial shows you how to export Shopify orders and fulfillment details into Google Sheets in just a few quick steps.","breadcrumb":{"@id":"https:\/\/www.getmesa.com\/blog\/how-to-export-delivered-orders-details-into-google-sheets\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.getmesa.com\/blog\/how-to-export-delivered-orders-details-into-google-sheets\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.getmesa.com\/blog\/how-to-export-delivered-orders-details-into-google-sheets\/#primaryimage","url":"https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/how-to-export-shopify-orders-to-google-sheets-when-they-re-delivered-4.png","contentUrl":"https:\/\/www.getmesa.com/blog\/wp-content\/uploads\/how-to-export-shopify-orders-to-google-sheets-when-they-re-delivered-4.png","width":1280,"height":720,"caption":"MESA Workflow: Tracktor to Google Sheets"},{"@type":"BreadcrumbList","@id":"https:\/\/www.getmesa.com\/blog\/how-to-export-delivered-orders-details-into-google-sheets\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.getmesa.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to export Shopify orders to Google Sheets when they&#8217;re delivered"}]},{"@type":"WebSite","@id":"https:\/\/www.getmesa.com\/blog\/#website","url":"https:\/\/www.getmesa.com\/blog\/","name":"MESA","description":"Discover how to automate your Shopify growth","publisher":{"@id":"https:\/\/www.getmesa.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.getmesa.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.getmesa.com\/blog\/#organization","name":"MESA - AI automation Platform","url":"https:\/\/www.getmesa.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.getmesa.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.getmesa.com\/blog\/wp-content\/uploads\/mesa-shoppad.jpeg","contentUrl":"https:\/\/www.getmesa.com\/blog\/wp-content\/uploads\/mesa-shoppad.jpeg","width":225,"height":225,"caption":"MESA - AI automation Platform"},"image":{"@id":"https:\/\/www.getmesa.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/web.facebook.com\/mesabyshoppad\/","https:\/\/x.com\/getmesa","https:\/\/www.linkedin.com\/company\/shoppad\/","https:\/\/www.youtube.com\/channel\/UCqsf_WhcGEsZMvms1idivyw"]},{"@type":"Person","@id":"https:\/\/www.getmesa.com\/blog\/#\/schema\/person\/86b06a380463c50cec7c545fa8205f61","name":"Jen Sparks","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/91c7269d578c2e4afe5f6f1d04ea060e77450abfbec1f39f5db50068c3d15a17?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/91c7269d578c2e4afe5f6f1d04ea060e77450abfbec1f39f5db50068c3d15a17?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/91c7269d578c2e4afe5f6f1d04ea060e77450abfbec1f39f5db50068c3d15a17?s=96&d=mm&r=g","caption":"Jen Sparks"},"description":"Project Wizard @ ShopPad, Green &amp; Gold Fanatic, Designaholic, Homebrewer, Seeker of Vegetarian Food Trucks, Lady Extraordinaire.","sameAs":["https:\/\/www.getmesa.com"],"jobTitle":"Product Manager","worksFor":"MESA"},{"@type":"HowTo","@id":"https:\/\/www.getmesa.com\/blog\/how-to-export-delivered-orders-details-into-google-sheets\/#howto-1","name":"How to export Shopify orders to Google Sheets when they&#8217;re delivered","mainEntityOfPage":{"@id":"https:\/\/www.getmesa.com\/blog\/how-to-export-delivered-orders-details-into-google-sheets\/#article"},"description":"These step-by-step instructions will connect Shopify fulfillments to Google Sheets. &lt;a href=\"http:\/\/apps.getmesa.com\/install\" target=\"_blank\" rel=\"noreferrer noopener\">Install MESA&lt;\/a> on your Shopify store before proceeding.","totalTime":"P0DT0H15M","step":[{"@type":"HowToStep","url":"https:\/\/www.getmesa.com\/blog\/how-to-export-delivered-orders-details-into-google-sheets\/#how-to-step-1661105241114","name":"First, add the workflow template","itemListElement":[{"@type":"HowToDirection","text":"From the MESA Discovery tab, type in \"export order\" in the\u00a0search\u00a0field and select the template from the drop-down menu.\u00a0"}],"image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.getmesa.com\/blog\/how-to-export-delivered-orders-details-into-google-sheets\/#schema-image-4bfc140be6e15a6d5f29fdbe20e382c4","url":"https:\/\/www.getmesa.com\/blog\/wp-content\/uploads\/export-shopify-orders-to-google-sheets-template-1.png","contentUrl":"https:\/\/www.getmesa.com\/blog\/wp-content\/uploads\/export-shopify-orders-to-google-sheets-template-1.png"}},{"@type":"HowToStep","url":"https:\/\/www.getmesa.com\/blog\/how-to-export-delivered-orders-details-into-google-sheets\/#how-to-step-1661106002964","name":"Next, add your Google Sheets credentials","itemListElement":[{"@type":"HowToDirection","text":"Select from the dropdown list or click the Add New Credential button to save your login details."}],"image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.getmesa.com\/blog\/how-to-export-delivered-orders-details-into-google-sheets\/#schema-image-c00d170a93c423330664308487150f3d","url":"https:\/\/www.getmesa.com\/blog\/wp-content\/uploads\/export-shopify-orders-to-google-sheets-authenticate.png","contentUrl":"https:\/\/www.getmesa.com\/blog\/wp-content\/uploads\/export-shopify-orders-to-google-sheets-authenticate.png"}},{"@type":"HowToStep","url":"https:\/\/www.getmesa.com\/blog\/how-to-export-delivered-orders-details-into-google-sheets\/#how-to-step-1661106118758","name":"View and Copy this Google Sheet sample file","itemListElement":[{"@type":"HowToDirection","text":"View this Google Sheet and make a copy to your Google Sheets account."}],"image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.getmesa.com\/blog\/how-to-export-delivered-orders-details-into-google-sheets\/#schema-image-de1b6d2f49ff608afa2d9dafd1c3c258","url":"https:\/\/www.getmesa.com\/blog\/wp-content\/uploads\/copy-google-sheet-sample-1.png","contentUrl":"https:\/\/www.getmesa.com\/blog\/wp-content\/uploads\/copy-google-sheet-sample-1.png"}},{"@type":"HowToStep","url":"https:\/\/www.getmesa.com\/blog\/how-to-export-delivered-orders-details-into-google-sheets\/#how-to-step-1661106324118","name":"Optionally, change the title of your sample Google Sheets file.","itemListElement":[{"@type":"HowToDirection","text":"Now might also be a good time to change the title of your Google Sheet from \"Copy of Order and Fulfillment Details of Delivered Orders,\" to something more specific to your brand. You'll need to reference it later."}],"image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.getmesa.com\/blog\/how-to-export-delivered-orders-details-into-google-sheets\/#schema-image-c18d8d52bbfadf51d10cc98a197d6e4a","url":"https:\/\/www.getmesa.com\/blog\/wp-content\/uploads\/google-sheet-sample-title.png","contentUrl":"https:\/\/www.getmesa.com\/blog\/wp-content\/uploads\/google-sheet-sample-title.png"}},{"@type":"HowToStep","url":"https:\/\/www.getmesa.com\/blog\/how-to-export-delivered-orders-details-into-google-sheets\/#how-to-step-1661106470079","name":"Return to your workflow, choose the newly copied Google Sheets file for Fulfillments.","itemListElement":[{"@type":"HowToDirection","text":"Under the Google Sheets - Create Row - Fulfillments step, select the existing file that was just copied to your account and choose\u00a0Fulfillments\u00a0on the Sheet Name field. Click Done when completed."}],"image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.getmesa.com\/blog\/how-to-export-delivered-orders-details-into-google-sheets\/#schema-image-a1f9af400d77cc140f181e1238878fd3","url":"https:\/\/www.getmesa.com\/blog\/wp-content\/uploads\/google-sheet-file-selected-fields.png","contentUrl":"https:\/\/www.getmesa.com\/blog\/wp-content\/uploads\/google-sheet-file-selected-fields.png"}},{"@type":"HowToStep","url":"https:\/\/www.getmesa.com\/blog\/how-to-export-delivered-orders-details-into-google-sheets\/#how-to-step-1661106778764","name":"Next, choose the newly copied Google Sheets file for Orders","itemListElement":[{"@type":"HowToDirection","text":"For the Google Sheets Create Row - Orders step, you'll need to do similar to what you did for Google Sheets Create Row - Fullfilments, except this time you'll input \"Orders\" for the Sheet Name*."}],"image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.getmesa.com\/blog\/how-to-export-delivered-orders-details-into-google-sheets\/#schema-image-dc3ee7a921c64cf62169b1618abda3eb","url":"https:\/\/www.getmesa.com\/blog\/wp-content\/uploads\/google-sheet-file-orders-fields.png","contentUrl":"https:\/\/www.getmesa.com\/blog\/wp-content\/uploads\/google-sheet-file-orders-fields.png"}},{"@type":"HowToStep","url":"https:\/\/www.getmesa.com\/blog\/how-to-export-delivered-orders-details-into-google-sheets\/#how-to-step-1661106915258","name":"Lastly, Save and Enable your automation.","itemListElement":[{"@type":"HowToDirection","text":"Click the \u201cSave\u201d button to keep the existing or any optional configuration changes to this workflow.Finally, be sure to enable this automation by turning it \u201cOn\u201d so this automation runs every time a new fulfillment status is updated. MESA will proudly celebrate your achievement by popping confetti in your honor. Congratulations!"}],"image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.getmesa.com\/blog\/how-to-export-delivered-orders-details-into-google-sheets\/#schema-image-39db2d2bb2d271787a5a8939a0d42d2a","url":"https:\/\/www.getmesa.com\/blog\/wp-content\/uploads\/export-shopify-orders-to-google-sheets-automation.png","contentUrl":"https:\/\/www.getmesa.com\/blog\/wp-content\/uploads\/export-shopify-orders-to-google-sheets-automation.png"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/www.getmesa.com/blog\/wp-json\/wp\/v2\/posts\/2428","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.getmesa.com/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.getmesa.com/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.getmesa.com/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.getmesa.com/blog\/wp-json\/wp\/v2\/comments?post=2428"}],"version-history":[{"count":11,"href":"https:\/\/www.getmesa.com/blog\/wp-json\/wp\/v2\/posts\/2428\/revisions"}],"predecessor-version":[{"id":17393,"href":"https:\/\/www.getmesa.com/blog\/wp-json\/wp\/v2\/posts\/2428\/revisions\/17393"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.getmesa.com/blog\/wp-json\/wp\/v2\/media\/3999"}],"wp:attachment":[{"href":"https:\/\/www.getmesa.com/blog\/wp-json\/wp\/v2\/media?parent=2428"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.getmesa.com/blog\/wp-json\/wp\/v2\/categories?post=2428"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.getmesa.com/blog\/wp-json\/wp\/v2\/tags?post=2428"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}