Automated Daily Sales Report
Shopify + ads data โ Google Sheets โ one clean email every night at 11 PM
Demo data
Google Sheet
updated automatically
๐ Daily Sales Log
Date
Orders
Revenue
Ad spend
Profit
๐
Pull today's orders & refunds from Shopify
๐ฃ
Pull ad spend from Meta & Google Ads
๐งฎ
Calculate profit, top products, returns
โ๏ธ
Email the summary to the owner
โถ Run today's report now
Email the owner receives
11:00 PM daily
From:
Store Reports
Subject:
โ Daily report โ 148 orders, $9,420 revenue
To:
owner@roselane.com
Today at a glance
Tuesday, Nov 18 ยท compared with last Tuesday
148
Orders
โฒ 12%
$9,420
Revenue
โฒ 8%
$3,180
Profit
โฒ 5%
Revenue โ last 7 days
Top products
Floral Maxi Dress
34 sold
Satin Slip Dress
21 sold
Linen Midi Dress
18 sold
โ 3 products are running low on stock. 4 returns waiting to be processed.
← All demos