Automated Daily Financial Analysis from Loyverse POS with Google Sheets & Email
VerifiedFetches daily Loyverse sales via HTTP, calculates metrics, and emails reports from Google Sheets.
What this workflow does
This n8n workflow runs on a schedule, retrieves daily transaction data through HTTP Request, performs financial calculations, stores the output in Google Sheets, and delivers the results by email.
It is intended for business owners, managers, or analysts using Loyverse POS who require automated daily profit tracking and custom reporting in Google Sheets.
Who is this for?
Business owners, managers, and analysts using Loyverse POS in restaurants, bars, or retail who need consolidated daily financial reporting beyond Loyverse's built-in tools.
What problem it solves
Loyverse spreads key metrics like gross profit, net operating profit, and performance vs. historical averages across multiple reports or omits them entirely, requiring manual daily work.
Live workflow preview
Interactive canvas of every node and connection — scroll and click to explore. Powered by n8n's preview.
Open the template on n8n to import and run it. View source template →
What it automates
End-of-day profit tracking
A restaurant owner runs the workflow each morning to get net operating profit and cash handling differences for the prior day's shifts without pulling separate Loyverse reports.
Weekly performance comparison
A retail manager reviews the Google Sheet to see how yesterday's average transaction value compares to the 30-day weekday rolling average.
Automated stakeholder updates
A bar owner receives a concise email summary of total revenue, gross profit, and ATV every morning before opening.
How the workflow works
The 4 nodes in this automation, in order.
- 1Send EmailemailSend
- 2Google SheetsgoogleSheets
- 3HTTP RequesthttpRequest
- 4Codecode
Apps & integrations used
How to set up Automated Daily Financial Analysis from Loyverse POS with Google Sheets & Email
- 1Subscribe to the Loyverse Integrations add-on and generate an API access token
- 2Create HTTP Request, Google Sheets, and Send Email credentials in n8n
- 3Import the workflow JSON into your n8n instance
- 4Update the Schedule trigger and shift-time parameters in the Code node
- 5Connect your Loyverse store and target Google Sheet
- 6Test the workflow manually then activate it
How to customize this workflow
- →Edit the Code node to add or remove calculated metrics
- →Change the Schedule trigger to run at a different time or frequency
- →Modify the email template or add extra recipients
- →Append additional columns to the Google Sheets output row
Automated Daily Financial Analysis from Loyverse POS with Google Sheets & Email: pros & cons
Pros
- +Consolidates metrics Loyverse does not provide in one place
- +Handles overnight shifts correctly
- +Saves results to Google Sheets for historical dashboards
- +Sends a ready-to-read email summary automatically
Cons
- –Requires paid Loyverse Integrations add-on ($9/month)
- –Initial setup needs manual configuration for your POS categories and payment types
- –Custom metric changes require editing the Code node
Frequently asked questions
It pulls daily sales, shifts, and receipts from Loyverse via API, calculates profit and performance metrics, appends them to Google Sheets, and emails a summary.
User reviews
Verified reviews from the community shape this listing's rating.
Loading reviews…
Similar workflows
Other ai & llm automations worth a look.