Google Workspace integration in Italy
Google Sheets bulk imports, Gmail add-on and Apps Script library — Italy with IVA 22% via SdI.
Architecture — Google Sheets bulk imports for Italy
Install the Corp-Merch Sheets add-on from Workspace Marketplace (domain-wide install supported). A sidebar reads the active range, validates against the Italy catalog (SKU, MOQ, currency, IVA 22%), and submits with one click. Idempotency keys derived from row UUID. Errors highlight bad cells inline. Typical use: HR exports a new-hire list, the sheet expands it into kit orders, the add-on submits to Corp-Merch and writes back order IDs and tracking URLs in adjacent columns. Default ship-to is the Milano hub.
How to wire it up — Gmail add-on for in-thread approvals
The Gmail add-on detects Corp-Merch order links in incoming emails, fetches live status, and offers Approve / Reject and Reply-with-quote actions in the right-hand panel. Available on Workspace Business Standard and above. OAuth scopes limited to gmail.addons.execute and our own API. Thread context is sent only to Corp-Merch (never to third-party LLMs).
Operations and edge cases — Apps Script library for custom automation
Our Apps Script library wraps every REST endpoint with typed methods: CorpMerch.orders.create, .list, .cancel; CorpMerch.invoices.list (filterable by SdI status). Triggered by time-based or event-based triggers, ideal for finance close jobs, end-of-month reporting, or sync to Looker Studio. Code samples and a starter project on GitHub. Sistema di Interscambio (SdI) acknowledgement ids surfaced on invoice objects for direct reconciliation.
FAQ
Domain-wide install?
Yes — admins can install for the whole domain from Workspace Marketplace. Per-user install also works.
What OAuth scopes are requested?
spreadsheets, gmail.addons.execute, script.external_request — the minimum needed. We never request drive.readonly or other broad scopes.
Apps Script — where do I find docs?
Library script id, full reference and a starter project on our GitHub at github.com/corp-merch/apps-script-starter.
What about Looker Studio?
Our Looker Studio connector reads orders, invoices and shipments. Connect with your existing API key or via OAuth.
Does it auto-apply IVA 22%?
Yes — Sheets and Apps Script send country='Italy' and Corp-Merch applies IVA 22% and routes invoicing via SdI.