Objective: This guide aims to simplify the automation of tracking paid orders from your Shopify store to Google Sheets using Sheetgo.
Step 1. Go to app.sheetgo.com
Step 2: Create a new workflow:
![](https://lh7-us.googleusercontent.com/CPY0uaBwWDM9GsfhYqCn__vuI3Qxsoc703ldTR1TwN5huaKod9ZAR0-PBdti7TSNb3VmDtXbc2vd4fc59b_bTqobWkGlWvACc_21ns3TG3N9Ikd_duOJiyk09kGWfL74GKSKhSqwyfEbVuqVAS7maEA)
Step 3: Name your workflow and connection:
- Scroll down to find the options shown in the snapshot below
![](https://lh7-us.googleusercontent.com/LuFlYDVIeB55XEYMtACcQVj0qL2C7B28Tgor4QDhhCPBIe7Pf5myxEAsT5kPkenmEYdq9EqHtaYhf3wcxzbWvtYG8DZgQorvcENAPpPn_UnonhwBV0MsMGweeRwuRfvhcboEBWvTuecc6QeWPIxKCUQ)
Step 4: Fill in the form:
GET Request URL:
https://{{storename}}.myshopify.com/admin/orders.json?status=any&financial_status=paid
Headers (JSON):
{
"Content-Type": "application/json",
"X-Shopify-Access-Token": "{{shopify-api-access-token}}"
}
Click on the “Next step” button
![](https://lh7-us.googleusercontent.com/lyaPS5QTYRnjsMvkYnkJUASQPYD0EvAS7NEK4IuLQ-5xt9JWSaK6Ni5LaGTLlv2nfrTEhjgWqbQlt5INKDmdS3PXk8bdkF_79Z7mqiO5j-9W5jpbrtotsaRWd1l_1h8Eh-Lj2Bm_SH7x3wzH3QmVn8Q)
Step 5: Choose your destination:
![](https://lh7-us.googleusercontent.com/3q1_LpZiZWGix7s_HtCPawoqU9L7FjwdUUwiOU8YOjJKo_PcQSeK4pBB2UtjgxnFHCH36r3q0PsJDm11YzZSMY81ojCJJi0aXMamJh3-w6rc5Bkbp45NGa64qMtQtXbCCJwNLPSoUDbgk1jvK06PpSM)
Step 6: In the workflow, create another connection:
![](https://lh7-us.googleusercontent.com/ciwEiVLErtG4rK8v6QhIOrk2tSzLbo_CxajPPLVaej0n2UlFq859DsJOqicAXcAL8rdvm03q76dwv4MTJKgWcju2L1g3Rhnm2TJ3g9n9qq7PrWDnaEJm7aXKlIW-Pw_ZVV46__waRWNAzjdXMB7HW_w)
- Select the source file where you fetched the product list data from your Shopify store
![](https://lh7-us.googleusercontent.com/GBnt2LU9Q8fqIOPYMgjMBapM0ADcADuQZJUh9XKhO60XW8mv4CPqfLEoI46SQ_P-8uxG_omjpmNjpWwfJAm6hqfrU2JKRH35E0uWdc1CXa-Nt-kG39PWSTd4JiIDM9u15DXeacT8lYLKJg5lVzEb2BA)
Step 7: (Optional) Filter your data:
- You can filter the existing data frame or skip this step
![](https://lh7-us.googleusercontent.com/65jFXL3J9W4ikTbFosopxkUWgqXLj0CbQS_x_FgX_kvUdwJs02jYknQQ7U5RsY40C5osPTu6TfExQEnCIFW8_5TeIvDyPeQfrFM0ef7x_ng5wJ4TL-OP7Kaab72Dyt7b-VoKBT3QuEyzCVHQ0FOv6Qw)
![](https://lh7-us.googleusercontent.com/XDtk3Jf2SnrjPe-4TL1iX598e_DRMjIdS6zzIK8oPoKvwSgTz4_0aZbMT_n0_fRoapqsdsMDlRaNUcAp0PseB9wjjACYnVOpsFYwSPvZMBuaUZKkYyl6A6zja2lJzng6_lsKiqhFXpdZoa4tRDPIVGo)
Step 8: Append filtered data:
- If you filtered the data, append the new filtered data frame to another Google Sheet file
Step 9: Share updates via email:
- Configure email updates as needed
![](https://lh7-us.googleusercontent.com/qKQddLvZRQCd2rqMeR6IMWufMkEUinEDCk5d3_S7mGtCChTrEubfJvS79uL4hMVicO80sLJ8OTB0Wgxn2gxtq1xtHBY8qe4xMqxE6QUdDIFnWkHILpzjEJ19iBfYMs4qsFFjB4KYKkgqXHzYBPlYx9A)
![](https://lh7-us.googleusercontent.com/AB6L3f4dTkqSoOAfnqVEO97-k-Xrjspz2n-gXc5Wzimp1AgM8aTogkUjhIKuHwqG1mKsmdUnoQMPuQ5bxLNBfMDTXc7rTW0WDnfuPawlWxQkcO3K89RydmvsrQC6tahOj1l2GMMRfVGcsLM_3iEKAPc)
![](https://lh7-us.googleusercontent.com/jhHbL4bTcZpVlVh4BaNQ_Q7Ezw_1lktgHmAtKusNQrIcImRWx3W0ML8K41Arc9Uus-YQT5kfYA0I7w09CpYB8-e4GmdAc-MpIjWZ2ZY6Gr1TOUuYxhAWVh9weq7Mm9voNQh9CZXMONRhbm9Vls-bo1c)
**Your final workflow should look like this**