Documentation, Reference Materials, and Tutorials for your WooCommerce products
Save New WooCommerce Orders to Google Sheets
Keep a log of your WooCommerce orders on Google Sheets with Zapier .
Prepare your accounts ↑ Back to top
Install Zapier: To connect your WooCommerce store to Zapier, ensure that you have the WooCommerce Zapier extension installed. Learn more about WooCommerce on Zapier at Getting Started with Zapier and WooCommerce .
Create a Google spreadsheet: To link Google Sheets to your WooCommerce store using Zapier, you need to create a new spreadsheet. Learn more about Google Sheets on Zapier at Getting Started with Zapier and Google Sheets and Create Google Sheets .
Connect your accounts ↑ Back to top
To save new WooCommerce orders as rows on a Google Sheet , you need to connect your WooCommerce store to Google.
1. Copy and paste the provided URL into the Webhook URL field on your WordPress dashboard.
2. Click the Ok, continue button.
3. Confirm that you have a working spreadsheet on Google Sheets, and click Ok, continue.
4. Log into your Google account with Email Address and Password, or select an already connected account.
5. Click Allow when Zapier requests access.
5. Select the Spreadsheet and Worksheet where you want to save order details. Then match the fields from WooCommerce with the fields in Google Sheets.
6. Click Save + Finish to complete the Zap.
7. Test the Zap to make sure it works.
Once you’re satisfied, WooCommerce orders can be saved as rows on Google Sheets!
FAQ ↑ Back to top
How do I make changes?
If you want to alter the Zapier and WooCommerce integration, go to your Zapier dashboard and tweak anything you wish.
What else can I do with WooCommerce on Zapier?
Check out everything that’s possible with WooCommerce on Zapier , plus other ways to connect Google Sheets and WooCommerce .
Installing and Activating WooThemes Licenses
How to Get Help
WooCommerce – the most customizable eCommerce platform for building your online business.
Google Sheets and WooCommerce Integration
Keep your team informed and collaborate better. Connect Google Sheets and WooCommerce. Run workflows.
Add a Row in Google Sheets on a New Product in WooCommerce
Add or Update Customer in WooCommerce on a New Row in Google Sheets
Add a Row in Google Sheets on a New Customer in WooCommerce
Add or Update Customer in WooCommerce on a New Row (old) in Google Sheets
Update a Row in Google Sheets on a New Product in WooCommerce
Add a Row in Google Sheets on a New Order in WooCommerce
Add a Row in Google Sheets on a New Order Line Item in WooCommerce
Update a Row in Google Sheets on a New Customer in WooCommerce
Looking for something else?
Create your own Integration
- New Row (old)
Triggers when a new row is added in a worksheet
- New Row
Triggers when a new row is added in a worksheet (recommended)
- New Spreadsheet
Triggers when a Spreadsheet is created
- New Worksheet
Triggers when a Worksheet is created
- New Customer
Triggers when there is a new Customer
- New Order
Triggers when there is a new Order. This will trigger for orders with any Order Status, such as, Completed, Cancelled, Failed, Refunded, etc.
- New Order Line Item
Triggers for each line item of a new Order.If there is a new Order with 5 Line Items, the bot will run 5 times, each time with the details of one of the Line Items
- New Product
Triggers when there is a new Product
- Modified Customer
Triggers when Customer data gets Modified or when new Customer is Created
- Order Status Changed
Triggers when the Order Status changes to the Selected Status, or when a new Order is created with the Selected Status
- Add or Update Customer
Add a new Customer or Update an existing Customer
- Add an Order
Add a new Order
- Add Order Line Item
Add Line Item to an existing Order
- Add or Update a Product
Add a new Product or Update an existing Product
- Add or Update a Product Variation
Add a new Product Variation or Update an existing Product Variation
- Search Customers
Search a Customer based on Email Address or Customer Id
- Update an Order
Update an existing Order
- Search Orders
Search for an existing Order
- Search Products
Search for an existing Product
- Search Product Variantions
Search for an existing Product Variantion
- Add a Row
Adds a new row to a given Worksheet
- Add a Worksheet
Adds a new Worksheet to a given Spreadsheet
- Search Rows
Searches a row based on column value
- Update a Row
Update a row in a given Worksheet based on row id
- Add a Row (v4)
Adds a new Row. Use this only if you have an issue with the other ‘Add Row’ action.
- Delete a Row
Delete a Row from the specified Worksheet based on the Row ID
Create your custom integration by selecting the Trigger event and Action to be performed.
Connect Google Sheets and WooCommerce with your other apps and run workflows across them.
Trigger workflows automatically when things happen in any of the apps.
Zero coding. No change in existing apps.
About Google Sheets
Google Sheets is a fully featured web spreadsheet application that is also available on major mobile platforms. Create, share and collaborate on spreadsheets on web and mobile.
WooCommerce is a powerful and highly customizable Ecommerce platform built on top of WordPress. It offers all you need to create a store and sell online.