POS integration · Reports

Your sales, products and customers in a Google spreadsheet

Google Sheets POS integration in ArmPOS keeps your sales, products and customers in a spreadsheet it makes in your Google Drive. Each export writes them again in full, at a click or every night.

  • Sign in with Google
  • Sales, Products, Customers
  • Now or every night
  • Built in

How your shop reaches Google Sheets

  1. Start, or Every nightan export runs in the background
  2. One spreadsheet in your Drivemade by the first export
  3. Three tabs written againSales, Products, Customers
  4. Your shop as it is nowplain text and numbers

What ArmPOS does with Google Sheets, step by step

  1. Connect Google Sheets signs you in on Google’s own page through ArmPOS’s Google app (OAuth 2.0), asking only for the drive.file scope
  2. The first export creates one spreadsheet through the Google Sheets API v4, named ArmPOS · and your shop’s name, with three tabs
  3. Each export clears the Sales, Products and Customers tabs, writes their header row, then appends your rows, 500 at a time
  4. Every value is written RAW, so a name starting with = stays text and never runs as a formula
  5. Every night queues the same export once a night, at 02:30 UTC; when Google is busy, an export waits and tries again

What goes into the spreadsheet, and what doesn’t

One way: ArmPOS writes to the sheet, and nothing typed there comes back into your shop.

  • Sales, one row eachReference, date, time, customer, warehouse, status, payment, total, paid, due, discount, shipping and tax.
  • Products, one row eachCode, name, category, brand, what it sells for, cost, stock, stock alert and whether it’s active.
  • Customers, one row eachCode, name, email, phone, city and country.
  • Stock, added upOne figure per product: its stock across all your warehouses, not warehouse by warehouse.
  • Anything typed into the three tabsReplaced by the next export. Tabs you add yourself are left alone.
  • The items in each saleNot written: a sale is one row with its totals.
  • Returns, purchases, expenses and suppliersNone of them has a tab.

A deleted sale, product or customer leaves the sheet at the next export. Disconnect keeps the spreadsheet in your Drive.

Where it works, and for whom

Countries

  • Wherever you use Google Sheets

For

  • Retail & grocery
  • Fashion & beauty
  • Health & pharmacy
  • Phones & electronics
  • Hardware & building materials
  • Wholesale & distribution
  • Hospitality

Set up in 3 steps

  1. Open Integrations, find Google Sheets under Reports, and click Set up.
  2. Click Connect Google Sheets, sign in to Google and allow ArmPOS. Leave Google’s box ticked.
  3. On Export, click Start beside Export. On Settings, turn on Every night to export once a night.
Google Sheets’s settings in ArmPOS

Words you’ll see on the screens

  • Connect Google Sheets
  • Overview
  • Export
  • Start
  • Cancel
  • Settings
  • Your spreadsheet
  • Open in Google Sheets
  • Every night
  • Activity
  • Disconnect

What it doesn’t do

  • It isn’t live: the sheet changes only when an export runs, at a click or once a night.
  • Nothing comes back: a change typed in the sheet never reaches your shop.
  • No sale items, returns, purchases or expenses: only sales, products and customers.

Questions

How do I connect Google Sheets to my POS?

Open Integrations › Reports › Google Sheets and click Connect Google Sheets. Sign in to Google and allow ArmPOS: there are no keys to copy.

What goes into the Google spreadsheet?

Three tabs, Sales, Products and Customers, one row each under a header row. A sale’s row holds its totals, not its items.

Does the sheet update by itself?

With Every night on, an export runs once a night at 02:30 UTC. Otherwise click Start on the Export tab.

Does each export add rows or replace them?

It replaces them. Each export clears the three tabs and writes them again, so the sheet matches your shop.

Can ArmPOS see my other Google Drive files?

No. It asks only for drive.file, so it opens the spreadsheet it made and nothing else.

What if I delete the spreadsheet?

The next export makes a new one in your Drive, with the same three tabs.

Can I export only some products or dates?

No. Each export writes every sale, product and customer your shop has.

Get Started

Run your shop on ArmPOS

Start free with point of sale and inventory management in one app. No card needed; upgrade when your business grows.

  • 14-day free trial
  • No card needed
  • Android & iPhone
A cashier selling with ArmPOS