Save new paid Shopify orders to a Google Sheets spreadsheet
When a new order is paid in Shopify, the data from Shopify order are sent to Google Sheets. In this scenario this spreadsheet was used.
Software used in this automated workflow example
When a new order is paid in Shopify, the data from the Shopify order is sent to a Google Sheets spreadsheet.
There are few reasons that you might want to keep a Google Sheet record of your Shopify orders:
1. You can track your sales and growth over time.
2. You can spot trends in your customer behavior.
3. You can identify any issues with your fulfillment process.
4. You can keep track of your inventory levels.
5. You can track your marketing campaigns and their effectiveness.
Additionally, in case something happens to your Shopify account, you will still have a record of your orders.
This tutorial will help you:
1. Set up a Google Sheet to automatically record new Shopify orders.
2. Use Make to automate the process.
3. Set up a filter to only record certain orders.
We decided to use Make / Integromat for this instead of Zapier because it offers more flexibility and options for free.
Step by step instructions
The first step is to add a new Shopify module to your scenario.
Set up the "Watch new paid orders" trigger.
Add a new Google Sheets module to your scenario.
Select the "Create new row" action.
Select the "Shopify Order" object.
Map the fields from Shopify to the corresponding fields in Google Sheets.
Run the scenario and test it with a few paid orders.
Business use case example
This scenario can be used to keep track of all paid orders in a central location. This can be useful for businesses that use Shopify for their ecommerce platform and Google Sheets for their data storage and analysis.