Google Sheets to WooCommerce integration
Your spreadsheet of customers, in WooCommerce
CRM Connector reads your Google Sheet, or an Excel or CSV file, and brings every customer into your WooCommerce store as a customer account, matched on email, and keeps them current.
- Google sign in, or an Excel or CSV upload
- WooCommerce stays the system of record
One way, into WooCommerce
At a glance
Customers from your sheet arrive in WooCommerce and stay current.
What syncs
- CustomersOne way
How it runs
One way, into WooCommerce
Google Sheets sends and WooCommerce receives, for every record type. A change made in WooCommerce stays there and is never sent back into Google Sheets.
Options for Google Sheets and WooCommerce
- Everyone, customers only or leads only
- Only contacts with a tag you pick
Record by record
What flows from Google Sheets into WooCommerce
Which Google Sheets field matches which WooCommerce field, and what each change does.
One way, from Google Sheets into WooCommerce
Fields- Name, or first and last nameOn every changeFirst name, last name
- CompanyOn every changeCompany
- EmailWhen createdEmail
- PhoneOn every changePhone
- Street, second line, city, state, postcode, countryOn every changeAddress lines 1 and 2, city, state, postal code, country
- TagsOnly in Google SheetsNot in WooCommerce
It happens in Google Sheets, then in WooCommerce
A new row
- Looked for in WooCommerce on the exact email and updated when found.
- Otherwise a new customer account is created.
Rows with the same email
Rows that share the key column you picked, an email by default, make one contact, so a customer listed on several rows is never created twice.
A cell changes
The same change is made to the WooCommerce customer account on the next sync, where WooCommerce takes it.
A row is deleted
The customer account stays in WooCommerce: a sync never deletes.
- Each new contact becomes a customer account in your store. The sync never changes an account email; customers change their own under My account.
FAQ
Questions about Google Sheets and WooCommerce?
Every answer below is true for the app as it runs today. If something is not covered, ask us and we will answer in plain words.
Ask your AI assistant
Ask ChatGPT or Claude about Google Sheets and WooCommerce
CRM Connector works inside ChatGPT and Claude. Ask in plain words and get the answer for your own setup, including a link that opens it ready to start.
Get started
Ready to connect Google Sheets and WooCommerce?Start your 7 day free trial
Sign in to Google Sheets and WooCommerce, confirm what flows into WooCommerce, and watch the first sync run.