Objective: This guide aims to streamline the process of transferring your Shopify store’s product list to Google Sheets using Sheetgo.**
Step 1. Go to https://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/products.json
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/o8POdZD9-tSMNkJU4U4-2edRoVe8WOq8sTbrDXkrDYhqsyFB_MkwzgFbrNd8Rb7pM45xDUACVjBKZBkoinI_I0U_O4CPed89vKDGKPj5GGTpNiUdRGV6JCNVcxWuaMEAfrKeS2Ts3G3ghECUDIvDGzY)
Step 6: Within this 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/7pFzXF6EdqKu7wuvjCiaFY7M5EGo_99sKINCPUO_Ot9Ye_KDlJDiLJjU7vm7FVzDAGh4gZb5UD3kenQQ5lmGhkbapbmpQZCFEeLbc3C_Mnx8glE8l1WACY0pOpX2P1KXdJQO7876rySrsIWx3JHJSx0)
Step 7: 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/7yqv8K3vRyvrdY9MRIuPgPQmgM9pWtJ_ZfjGSixhaa6UfAqAm1GU7FwdcjfoAvMxANld5B46jufZPnSNARKvIongWjNSPF647RDG9TQp5yDip0tQ_EG5n-NUJT9TRZVi78eWM_gvtbZoiQwhMa8l6lI)
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/w2WXCspBwVYAeCzabO_VMgyI12izrDm8kOXwUKYWUR0m6iH7Qzi2u1qLq5zF6nDi5JJujZT57ysd8X5CPulsNMFr8-CGoTYj0BoDqomjPV8GrJtcU-xA2VDsWrV3HQdsgpGmh8Fz7U7GZegQNbhZOd4)
Your final workflow should look like this