Search
Beginner Certificate on pass

Google Sheets Register Export

Export vendors, purchase orders, invoices, quotations and RFQs to a live Google Sheet — one tab per register, refreshed on demand or daily.

3 lessons 25 min 5-question assessment 70% to pass

What you’ll learn

  • Explain what the Google Sheets connector exports and how
  • Connect it and choose which registers to export
  • Refresh the sheet with Sync now and the daily schedule
  • Understand it is a snapshot export, not real-time streaming

Course content

3 lessons · 25 min of reading
01
Lesson 1 of 3 Reading 8 min

What it exports

The Google Sheets connector pushes your operational registers into a single spreadsheet that AWRA creates and owns — one tab per register. The available registers are Vendors, Purchase Orders, Customer Invoices, Quotations and RFQs. You pick which of these to export.

This is for people who want to slice AWRA data in a spreadsheet — pivot tables, custom charts, sharing a read-only view with someone who does not have an AWRA login, or feeding another tool that reads Google Sheets.

It uses least-privilege access (the file-level Google scope), so AWRA can only touch the one spreadsheet it creates — not your other sheets.

Key takeaways

  • Exports registers to one spreadsheet, one tab per register.
  • Registers: Vendors, Purchase Orders, Invoices, Quotations, RFQs.
  • Great for pivots, charts, sharing, or feeding spreadsheet-based tools.
  • Least-privilege: AWRA only touches the sheet it creates.
02
Lesson 2 of 3 Workshop 9 min

Connect, choose registers, and sync

Connect from Settings → Connectors with Google (OAuth). AWRA creates an "AWRA OpsHub — Registers" spreadsheet. Tick the registers you want, switch the connector on, and use "Sync now" to build/refresh the tabs. A "Send test" action writes a small tab first so you can confirm it works.

On each sync, every selected tab is cleared and rewritten with current data, so the sheet always reflects the latest state rather than appending. A daily background sync keeps it fresh automatically, and you can Sync now any time you want an immediate refresh.

Like the other queued connectors, the sync runs on the background queue — a queue worker must be running for scheduled and on-demand syncs to complete.

Key takeaways

  • Connect via Google; AWRA creates the registers spreadsheet.
  • Pick registers, then Sync now to build/refresh tabs.
  • Each sync clears and rewrites tabs with current data.
  • A daily schedule keeps it fresh; a queue worker is required.
03
Lesson 3 of 3 Practice 8 min

Snapshot, not stream

Understand what "live" means here: the sheet is a snapshot that refreshes on sync (on demand or daily), not a real-time stream that updates the instant a record changes in AWRA. If you edit a vendor in AWRA, the sheet reflects it after the next sync, not immediately.

That makes it ideal for reporting and analysis where near-current data is fine, and less suited to workflows that need the exact live value at a moment. For up-to-the-second numbers, use AWRA's own reports and dashboards.

Because AWRA rewrites the tabs it manages, avoid hand-editing those tabs — your edits will be overwritten on the next sync. Do your custom work in separate tabs or a linked spreadsheet that references the exported tabs.

Key takeaways

  • It is a snapshot refreshed on sync, not real-time streaming.
  • Best for reporting/analysis with near-current data.
  • Do not hand-edit the exported tabs — they are overwritten each sync.
  • Use separate/linked tabs for your own calculations.

Finished the material?

Take the 5-question assessment and earn your certificate — 70% to pass.

Take the assessment

Help Center

Need a quick answer while you read?

Run inventory, procurement, assets, sales, and field work with approved AWRA guidance for setup, migration, integrations, security, pricing, and support.

Search all approved AWRA public help articles.

Open Help Center