Planned · on the roadmap

Live spreadsheets for Lightspeed

Sheets is coming to Lightspeed: your sales, items and locations as live tables that formulas, pivot tables and charts read directly, without exports.

Tell me when it's ready What works today
  • Spreadsheet formulas
  • Pivot tables and charts
  • Scheduled e-mail reports
Planned reports

What you will build on Lightspeed

Each is one formula on live data. These are examples of the syntax: the column names will follow Lightspeed's own fields once the integration ships.

=data.sales.sum(net_total, location, A2)
Sales by location. Net sales per location and day, side by side.
=data.sales.sum(net_total, employee, A2)
Sales per employee. Revenue and tickets per staff member and shift.
=data.line_items.sum(quantity, item, A2)
Best sellers. Items ranked by quantity and revenue.
=data.sales.avg(net_total, hour, A2)
Hourly pattern. Average sales by hour of day, to plan staffing.
The data

Tables from Lightspeed

Sales · Line items · Items · Locations · Employees · Payments

How it will run

Your data stays in Lightspeed

You will sign in with your Lightspeed account and give Sheets read access. Sheets runs on our servers in the EU and reads your data through Lightspeed's API when a sheet opens or refreshes. We plan to list it in the Lightspeed App Marketplace.

Want it?

Vote for Sheets for Lightspeed

A thumbs up moves Lightspeed up the roadmap. Leave your e-mail address too and we write once, when it ships.

We use your details only to answer you. Privacy policy

Point of sale: also planned

Cloverplanned
sales, items and locations
Toastplanned
sales, items and locations
FAQ

Questions

Is Sheets for Lightspeed available?

Not yet. Lightspeed is on the Sheets roadmap. Give it a thumbs up and leave your e-mail address on this page: we tell you when it is ready, and the votes decide what we build next.

What will Sheets read from Lightspeed?

Your sales, items and locations, as tables: Sales, Line items, Items, Locations, Employees, and Payments. Each table becomes a data source that formulas, pivot tables and charts read live.

Will Sheets change anything in Lightspeed?

It is planned read-only: Sheets reads your Lightspeed data and does not change it.

What works today?

Sheets works today with QuickBooks Online, Xero, Shopify, WooCommerce, BigCommerce, HubSpot, FreshBooks, monday.com, and Asana.

Want Sheets for Lightspeed?

Requests decide what we build next. We write once, when it is ready.

Tell me when it's ready

85 tools on the integrations page