Athenian Google Sheets App Script Integration
product details.
Athenian Google Sheets App Script Integration adds a Google Apps Script sync layer for managing WooCommerce products, pricing, vendors, orders, and media through structured spreadsheet workflows. It helps teams connect spreadsheet automations, signed requests, and platform data models for controlled bulk commerce maintenance while keeping data, permissions, and automation aligned with the broader Athenian Platform…
Athenian WooCommerce Google Sheets Integration is a secure spreadsheet operations bridge that turns Google Sheets into a controlled workspace for WooCommerce catalog, pricing, vendor, vendor-offer, order, and media management.
Instead of forcing teams to manage high-volume commerce data through individual product screens, fragile CSV imports, or one-off scripts, AWGS connects Google Sheets to WooCommerce through signed WPGraphQL requests, WooGraphQL, Google Apps Script modules, and Athenian HMAC authentication. Teams can import live store data, review rows in a familiar spreadsheet, run dry-run checks, and sync only approved changes back to WordPress.
The plugin supports product and variation imports, price and description updates, dimensions, sale dates, tiered pricing rules, vendor user records, vendor pricing offers, WooCommerce order fields, and media metadata. It is especially useful for catalog-heavy stores, vendor marketplaces, dropshipping operations, supplier pricing reviews, PrintGhost.ai-style workflows, and teams that need the speed of spreadsheets without giving up permissions, validation, or traceability.
Within the Athenian Platform, AWGS fits as the bulk commerce operations layer for product pricing, tiered pricing, vendor routing, supplier offers, order review, media cleanup, and structured WooCommerce data synchronization.
Spreadsheet Commerce Operations
Manage WooCommerce Products, Orders, Vendors, Offers, and Media From Google Sheets
Athenian WooCommerce Google Sheets Integration gives operations teams a
secure spreadsheet-native control plane for importing, reviewing, dry-running,
and syncing WooCommerce data through signed GraphQL workflows and
purpose-built Apps Script modules.
| Sheet Module | Operational Value |
|---|---|
| Prices Sheet | Imports products and variations for reviewing descriptions, short descriptions, dimensions, regular prices, sale prices, sale dates, and tiered pricing fields. |
| Orders Sheet | Imports WooCommerce order records and supports controlled batch updates for selected order fields and editable metadata. |
| Vendors Sheet | Treats selected WordPress users as vendor records and supports updates to vendor email, display name, roles JSON, and status. |
| VendorOffers Sheet | Synchronizes supplier or vendor pricing offer rows stored in product and variation metadata. |
| Media Sheet | Supports structured review and update of media titles, slugs, alt text, captions, descriptions, and status where enabled. |
- Adds a WordPress settings page under Settings → Athenian Sheets Sync.
- Stores plugin configuration in
awgs_settings, including shared secret, impersonated user ID, clock skew, and nonce TTL. - Includes Apps Script modules such as
Main.gs,Products.gs,Orders.gs,Vendors.gs,VendorOffers.gs, andMedia.gs. - Uses Config-sheet feature flags to enable or hide products, media, vendors, vendor offers, orders, dev tools, and dangerous actions per workbook.
Secure GraphQL Sync
Protect Spreadsheet Updates With HMAC Signatures, Nonce Replay Checks, and WooCommerce Permissions
AWGS authenticates spreadsheet-driven GraphQL requests with Athenian
HMAC signing, timestamp validation, nonce replay protection, key rotation
support, and controlled WordPress user impersonation so spreadsheet edits
can safely trigger privileged WooCommerce operations.
Verify timestamp, nonce, body, signature, and optional key ID
Test updates before committing changes to WooCommerce
Return per-row success, error, and remote-value details
| Security / Sync Layer | How It Helps |
|---|---|
| HMAC Authentication | Signs requests using HMAC-SHA256 over the timestamp, nonce, and canonical GraphQL request body. |
| Replay Protection | Stores accepted nonce keys in object cache and transients to help prevent reuse of signed requests. |
| User Impersonation | Runs authenticated GraphQL operations as the configured WordPress user, with write operations still checking WooCommerce capabilities. |
| Schema Discovery | Provides GraphQL helper fields so the spreadsheet can test authentication and discover supported AWGS schema fields. |
- Reads authentication inputs from headers such as
X-Athenian-Timestamp,X-Athenian-Nonce,X-Athenian-Signature, andX-Athenian-KeyID. - Supports authorization formats such as
AthenianHMAC <ts> <nonce> <sig>andAthenianHMAC <keyId> <ts> <nonce> <sig>. - Registers GraphQL discovery fields such as
awgsAuthProbeandawgsSchema. - Supports batch mutations such as
awgsBatchUpdatePricing,awgsBatchUpdateTieredPricing,awgsBatchUpdateOrders,awgsBatchUpdateVendors, andawgsBatchUpdatePricingOffers.
Bulk Data Operations Layer
Streamline Pricing, Tier Rules, Vendor Offers, Order Review, and Media Metadata
AWGS gives catalog, marketplace, and operations teams a spreadsheet-based
workflow for pricing updates, tiered pricing edits, vendor record management,
supplier offer review, order field cleanup, and media metadata enrichment.
| Operations Area | Operational Purpose |
|---|---|
| Product Pricing | Batch updates product or variation descriptions, short descriptions, dimensions, regular prices, sale prices, and sale date windows. |
| Tiered Pricing | Exports and updates tiered pricing metadata through both JSON fields and simplified tier columns. |
| Vendor Offers | Manages vendor offer rows with pricing, minimum quantity, tier JSON, lead days, status, notes, source, and custom metadata. |
| Orders & Media | Supports order review/update workflows and media metadata cleanup from dedicated spreadsheet tabs. |
Safer than CSV, faster than manual admin edits:
AWGS gives teams the speed of spreadsheet work while keeping live
WooCommerce updates behind signed GraphQL requests, dry runs, dirty-row
checks, field controls, and permission-aware mutations.
- Supports tiered pricing metadata such as
_tiered_price_rules_type,_tiered_price_minimum_qty,_fixed_price_rules, and_percentage_price_rules. - Reads vendor offer metadata from keys such as
_awgs_pricing_offers,_awgs_vendor_offers,_vendor_offers,vendor_offers,_pricing_offers, andpricing_offers. - Provides filters such as
awgs_vendor_query_args,awgs_vendor_export_node,awgs_vendor_offer_meta_key,awgs_pricing_offer_export_node,awgs_allow_meta_key_export, andawgs_allow_meta_key_update. - The reviewed package includes a legacy
includes/Rest.phpfile, but the active runtime is WPGraphQL-based and the REST class is not loaded by the inspected bootstrap. - Builds toward admin secret generation, connection testing, Apps Script deployment guides, schema manifests, audit logging, per-module WordPress settings, approval workflows, queued large-catalog sync, and AI-assisted anomaly detection for pricing and vendor data.