How to export Shopify orders to Google Sheets when they’re delivered

Time needed: 15 minutes

These step-by-step instructions will connect Shopify fulfillments to Google Sheets. Install MESA on your Shopify store before proceeding.

1. First, add the workflow template

   From the MESA Discovery tab, type in “export order” in the search field and select the template from the drop-down menu. 

2. Next, add your Google Sheets credentials

   Select from the dropdown list or click the Add New Credential button to save your login details.
   

3. View and Copy this Google Sheet sample file

   View this Google Sheet and make a copy to your Google Sheets account.

4. Optionally, change the title of your sample Google Sheets file.

   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.
   

5. Return to your workflow, choose the newly copied Google Sheets file for Fulfillments.

   Under the Google Sheets – Create Row – Fulfillments step, select the existing file that was just copied to your account and choose Fulfillments on the Sheet Name field. Click Done when completed.
   

6. Next, choose the newly copied Google Sheets file for Orders

   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*.
   

7. Lastly, Save and Enable your automation.

   Click the “Save” button to keep the existing or any optional configuration changes to this workflow.
   
   Finally, be sure to enable this automation by turning it “On” 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!