Google Sheets integration with FlexOrder
FlexOrder integrates with Google Sheets in the free version of FlexOrder.
Every WooCommerce order becomes a row. Change the status or addresses in the sheet and the order updates.
Google Sheets × FlexOrder
About Google Sheets
Google Sheets is Google's online spreadsheet. Sheets live in Google Drive, can be shared with a team and can be read or written by other apps through the Google Sheets API.
Visit the Google Sheets website
Google Sheets is a third-party product.
What you get with FlexOrder
Every WooCommerce order becomes a row. Change the status or addresses in the sheet and the order updates.
- Imported and historical orders can be pushed with one click
- Billing and shipping address edits sync back to the order
- Pro adds custom fields and transaction IDs
How to set up Google Sheets with FlexOrder
Typical setup time: About 15 minutes.
- 1
Create a Google Cloud project, enable the Google Sheets API and download a service account key. The FlexOrder wizard walks through each step.
- 2
Share the target sheet with the service account email and paste the sheet ID into FlexOrder.
- 3
Run the first sync. Each WooCommerce order becomes a row, and historical orders can be pushed with one click.
- 4
Change a status or an address in the sheet and the order updates in WooCommerce.
What data moves
| Data | Direction |
|---|---|
| Orders, statuses, items, totals | Two-way between WooCommerce and the sheet |
| Billing and shipping addresses | Edits in the sheet sync back to the order |
| Custom fields and transaction IDs | Synced on Pro |
Requirements
- WooCommerce
- A Google Cloud project with the Sheets API enabled and a service account key
Use cases
Order fulfilment without WordPress logins
A packing team marks orders as shipped in Google Sheets. FlexOrder changes the WooCommerce status and the customer gets the usual email.
A shared order list for support
Support staff look up and correct shipping addresses in the sheet they already use, without access to the WooCommerce admin.
Google Sheets integration FAQ
Is the sync two-way?
Do I need a Google Cloud account?
How often does it sync?
Can I keep the sheet private?
Connect Google Sheets with FlexOrder
Start with the free plugin from WordPress.org, then upgrade when you need more.