Your Square sales, live in Google Sheets.
Rowquill keeps a Google Sheet up to date with your Square daily sales, item sales and every transaction — fees, tips and refunds included. Set it up once; it refreshes itself. No CSV exports, no scripts, no per-task automation bills.
Early access opens soon. Early-access members get their first month free. We’ll email you about launch — nothing else, and you can unsubscribe anytime.
| Date | Gross sales | Discounts | Refunds | Net sales | Tips | Fees |
|---|---|---|---|---|---|---|
| Mon Nov 2 | $1,842.50 | −$61.00 | −$24.00 | $1,757.50 | $212.40 | −$52.37 |
| Tue Nov 3 | $1,610.25 | −$40.00 | $0.00 | $1,570.25 | $188.10 | −$46.12 |
| Wed Nov 4 | $2,034.75 | −$72.50 | −$18.50 | $1,943.75 | $240.65 | −$57.81 |
| Thu Nov 5 | $2,288.00 | −$55.00 | $0.00 | $2,233.00 | $266.30 | −$65.49 |
| Fri Nov 6 | $3,115.40 | −$98.25 | −$31.00 | $2,986.15 | $371.95 | −$88.40 |
How it works
Three steps, about two minutes. You never touch an API key.
Connect Square
Sign in with Square and approve read-only access. Rowquill can read your sales; it can’t change anything.
Pick your reports
Choose locations, a start date for history, and which report tabs you want.
Your Sheet stays current
Rowquill creates the Sheet in your Google Drive and refreshes it daily or hourly. Share it with your bookkeeper, build your own charts.
What lands in your Sheet
Clean, consistent tabs that you can build on — formulas, pivot tables and charts keep working after every refresh.
- Daily sales summary — gross, discounts, refunds, net, tax, tips and fees per day and location
- Item & category sales — units and revenue by item, variation and category
- Transactions — every payment with fees, tips, tender type and refund status
- Payment methods — card, cash and other tenders, with processing fees
- History backfill — pull past months on day one, not just new sales
- Multiple locations — one tab per report, filterable by location
- Read-only & private — Rowquill can only see the one Sheet it creates in your Drive
- Yours to keep — cancel anytime; the Sheet stays in your Drive
Simple pricing
7-day free trial. Cancel anytime from your account. Prices in USD; sales tax handled by our payment provider.
- 1 Square location
- Daily refresh
- Daily sales, Item sales and Transactions tabs
- Up to 2 years of history
- Up to 5 Square locations
- Hourly refresh
- All report tabs, including Payment methods
- Full history
Join early access — first month free when we launch.
Questions
Is Rowquill made by Square or Google?
No. Rowquill is an independent product that connects to Square and Google using their official, permission-based sign-in. It isn’t affiliated with or endorsed by Block, Inc. or Google.
Can Rowquill change my Square data?
No. We request read-only permissions for sales, orders, items and locations. Rowquill never creates, edits or refunds anything in Square.
What can Rowquill see in my Google Drive?
Only the spreadsheet Rowquill creates for you. We use Google’s narrowest file permission, which gives us no access to your other files.
How is this different from exporting a CSV?
A CSV is a snapshot you have to redo. Rowquill updates the same Sheet on a schedule, so your formulas, charts and shared links stay current without you doing anything.
What happens if I cancel?
Refreshes stop at the end of your billing period. The Sheet and everything in it stays in your Drive. When you disconnect, we delete your stored connection credentials.
Can I do this myself for free?
Yes, if you’re comfortable with code — our step-by-step guide shows the free methods too. Rowquill is for people who’d rather not maintain a script.