Keep a daily sales log from Square in Google Sheets
Each completed Square payment becomes a row. A second tab totals the day, so closing out takes one look.
A guide, not professional advice. Test before you use it for real. See terms.
A restaurant, café, or small shop that takes payments with Square.
Problem
The end-of-day total lives in the Square dashboard, and nobody copies it anywhere the owner checks.
What you need
How it connects
- SquareNative app
Make: Watch Payments. We found no official Square node in the n8n docs, so this recipe is Make only.
- Google SheetsNative app
Make: Search Rows and Add a Row. One row per payment id.
Steps
Set up two tabs
Payments: date, time, payment id, location, amount, tip, status. Daily: one row per date with a SUMIF over the Payments tab.
Watch payments
Make: Square Watch Payments. Run it once on a test sale and check which status value a finished payment shows.
Keep only finished payments
Add a filter so only completed payments go on. Square sends money in the smallest unit, so divide cents by 100.
Skip duplicates and add the row
Search Rows for the payment id first. If it isn't there, Add a Row. Write the date in your store's time zone so late-night sales land on the right day.
Time
Build time is about 30 minutes, estimated by the recipe’s author. It is not a measured average.
Saves copying payments or daily totals by hand. The Square dashboard is still the record.
Cost
Your Square account, a Google account, and Make per its current pricing.
What it doesn’t do
It doesn’t reconcile refunds, fees, or payouts, and it isn’t your sales tax report. If you use n8n, Square’s payment.updated webhook into a Webhook node is an option, but this recipe doesn’t cover it.
Build it
The account is yours. The Make link is an affiliate link.