Google Apps Script Development
E2A Mastersheet
A published Google Sheets extension for e-commerce purchasing, shipping coordination, returns, best offers, subscriptions, and operational automation.
Case Study Overview
E2A Mastersheet turns Google Sheets into an operations workspace for e-commerce teams that buy from eBay and manage downstream resale, shipping, prep center, returns, and reporting workflows. Automate Pros built the solution as a Google Apps Script extension with a custom sidebar, Google Sheets data model, external API integrations, and Marketplace-ready distribution.
Marketplace Extension
Published as a Google Sheets extension on Google Workspace Marketplace, with first-run setup, subscription gates, and user-facing add-on flows.
Sheets As Workspace
Structured sheets, named ranges, status colors, data validation, and batch updates keep operations visible while preserving the flexibility of Google Sheets.
Connected Operations
eBay order import, best offer tracking, shipping carrier lookups, Stripe subscription checks, and archive diagnostics work together inside the add-on experience.
The Challenge
The client needed more than a script that copied data into a spreadsheet. The workflow spans eBay purchasing, item status, carrier tracking, prep center coordination, returns, best offers, subscriptions, and ongoing maintenance for customer-owned sheets.
The implementation had to keep familiar spreadsheet workflows intact while adding product-grade automation, clear user feedback, recoverable background jobs, and safe handling of Marketplace add-on limits.
Apps Script Architecture
Google Apps Script Core
Server-side JavaScript coordinates Sheets operations, add-on menus, dialogs, sidebar actions, background automation, and external API calls.
Sheets Data Model
The workbook acts as the operational database, using managed sheet definitions, column-name lookups, validations, and batched reads and writes.
Operational Guardrails
Subscription checks, OAuth token handling, centralized logging, diagnostics, queue-aware jobs, and archive controls keep the add-on supportable after deployment.
Integrations And Workflows
eBay Purchasing
OAuth-backed eBay API calls import purchase history, item details, tracking data, and best offer activity into the operational workbook.
Amazon Resale Support
Mastersheet workflows support resale operations with item tracking, prep center status, and shortcuts for Amazon-related research.
Carrier And Returns
USPS, UPS, and FedEx workflows support shipment status, check-in operations, undelivered item review, and return or refund coordination.
Subscriptions
Stripe subscription validation gates paid functionality while preserving a Google Sheets-native user experience.
Marketplace Distribution And Support
Published as a Google Sheets extension on Google Workspace Marketplace, E2A Mastersheet needed product behavior that holds up for customer-owned spreadsheets: first-run setup, migration-safe sheet creation, subscription-aware UI, and durable recovery paths.
Ongoing support work includes background automation diagnostics, archive controls, clear execution logging, and testable Apps Script release workflows.
