๐Ÿฆ Early Bird BFCM Sale is here! Save Up to 50% ยท Lifetime Deals from $79 Ends in 00d00h00m00s Grab My Deal โžœ

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 logo FlexOrder logo

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. 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. 2

    Share the target sheet with the service account email and paste the sheet ID into FlexOrder.

  3. 3

    Run the first sync. Each WooCommerce order becomes a row, and historical orders can be pushed with one click.

  4. 4

    Change a status or an address in the sheet and the order updates in WooCommerce.

What data moves

DataDirection
Orders, statuses, items, totalsTwo-way between WooCommerce and the sheet
Billing and shipping addressesEdits in the sheet sync back to the order
Custom fields and transaction IDsSynced 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?

Yes. Edits in the sheet update WooCommerce, and new or changed orders in WooCommerce update the sheet.

Do I need a Google Cloud account?

Yes. FlexOrder connects through the Google Sheets API with a service account that only you control.

How often does it sync?

On an interval you set, with faster intervals on Pro.

Can I keep the sheet private?

Yes. The sheet is shared only with your service account, not by public link.

Connect Google Sheets with FlexOrder

Start with the free plugin from WordPress.org, then upgrade when you need more.