Chrome Extension Connecting WooCommerce with Google Drive
For a small school-photography business, I built a Chrome extension that sends WooCommerce orders to per-school spreadsheets, with preview, deduplication and native Sheets matching.
- My contribution
- I built a Chrome extension connecting WooCommerce orders to Google Drive and Sheets.
- Who it serves
- The team at a small school-photography business.
- Scope
- Per-school exports with preview, deduplication and spreadsheet matching.
Case overview
An operational solution for a school photography SMB that turns WooCommerce orders into Drive working sheets through an on-demand Chrome extension.
- Source
- WordPress/WooCommerce
- Interface
- Chrome MV3
- Destination
- Drive + Sheets
- Mode
- On demand
Ecommerce → Drive plugin
Chrome extension that turns ecommerce orders into per-institution operations spreadsheets. The operator selects the school, validates the destination, previews new orders and writes only the columns in the data contract; Sheets handles matching and checks with native formulas.
- Woo fields
- 17
- Destination modes
- 3
- CONFIG cells
- 4
- Sheets anchors
- 13
Extension
The popup brings together school selection, automatic or manual destination, new-order count and loading into the selected spreadsheet.
| Step | Screen | Action | Output |
|---|---|---|---|
| 01 | School | Autocompletes known names, aliases and local exceptions. | Canonical school |
| 02 | Destination | Resolves EXPORT 2026 by folder, Drive browsing or pasted link. | Validated spreadsheet |
| 03 | Mapping | Allows Woo field changes without writing outside A:Q. | Protected contract |
| 04 | Run | Counts new orders, skips duplicates and writes ranges by batch. | Rows written |
Load preview
The preview shows new orders before writing and separates states that require exclusion or review.
| Order | School | Class | Student | Status | Write |
|---|---|---|---|---|---|
| #10421 | North School | 3A morning | M. Alvarez | processing | A:Q |
| #10422 | North School | K5 afternoon | L. Campos | completed | A:Q |
| #10423 | North School | 6B morning | R. Diaz | pending | excluded |
| #10424 | North School | 2C afternoon | T. Molina | processing | duplicate skipped |
Operational architecture
The solution keeps the ecommerce backend untouched and moves the daily workload to an on-demand tool, with Drive as the workspace.
- WooCommerce
- Orders REST API, pages of 100, start-date and status filters.
- Drive
- School folder and EXPORT 2026 discovery, with pasted-link fallback.
- Sheets
- Batch update through mapped ranges and a duplicate check before writing.
- Templates
- EXPORT and LISTADO connected through CONFIG and authorized IMPORTRANGE.
Case decisions
Problem
A small store needs to move web orders into working sheets without hand-copying data. The extension brings together school selection, destination, preview and writing, while Sheets keeps the match with internal lists.
Architecture
The popup reads orders through the API, resolves the EXPORT 2026 file in Drive, validates the mapping and writes only PEDIDOS!A:Q. Column R remains manual and S:AH keeps formulas and helpers.
Control
The extension skips previously loaded orders, separates pending or cancelled states and lets LISTADO receive administrative data only when the exact key matches.
Facets
Tools
- WooCommerce API
- paginated reading of orders, statuses and checkout metadata
- Chrome MV3
- operating popup with school, destination, mapping, preview and execution
- Google Drive API
- folder and EXPORT 2026 spreadsheet discovery by institution
- Google Sheets API
- batch update into PEDIDOS!A:Q and deduplication by order ID
- Google Sheets formulas
- exact match between EXPORT and LISTADO with helpers and CONFIG cells