AWRA OpsHub + Google Sheets

Live registers in a Google Sheet.

Overview

What the Google Sheets connector does

Export vendors, POs, invoices, quotations and RFQs to a live Google Sheet — one tab per register, refreshed on demand. Perfect for lightweight reporting, pivot tables and sharing with finance.

Each register lands on its own tab, refreshed on demand, so finance can pivot, chart and share in a tool they already know without ever touching production data. It is the fastest path from AWRA data to an ad-hoc analysis or a board pack.

At a glance

Category: Productivity & Automation
Status: Live
Setup: Connect with OAuth
Data flow: Out of AWRA
Scope: Per-organization

Capabilities

What you can do

Tab per register

Each register gets its own sheet tab.

Refresh on demand

Re-export any time to update the sheet.

Analyse freely

Pivot, chart and share in familiar Sheets.

Setup

How it works

Connect Google with OAuth.

Choose which registers to export.

Export to a live sheet and refresh whenever you need.

One secure connection, then every user benefits

Connect once with OAuth using least-privilege scopes. Tokens are encrypted at rest, scoped to your organization, and you can revoke access at any time.

Enterprise-ready