Automated daily financial analysis from Loyverse POS with Google Sheets & email

by Nik B. · 2,498 views · created 2025-11-01 · Document Extraction

What this workflow does

This workflow has 13 nodes and runs manually, when you click “Execute workflow” (plus 1 other trigger). Along the way it connects Google Sheets. It also calls api.loyverse.com over HTTP.

How it runs

Trigger: Manually, when you click “Execute workflow” (plus 1 other trigger).

1. MASTER CONFIG (Code): runs custom JavaScript code
2. Get all products from Loyverse (HTTP Request): calls api.loyverse.com
3. Format Product Data (Code): runs custom JavaScript code
4. Save Product List (Google Sheets): append or update
5. Calculate Shift Time (Code): runs custom JavaScript code
6. Get Yesterday's Shifts From Loyverse (HTTP Request): calls api.loyverse.com
7. Get Yesterday's Receipts From Loyverse (HTTP Request): calls api.loyverse.com
8. Read Historical Data (Google Sheets): uses Google Sheets
9. Calculate All Metrics (Code): runs custom JavaScript code
10. Send Email: sends an email over SMTP

…plus 1 more step. See the full node list below.

Services it uses

Google Sheets

HTTP calls to: api.loyverse.com

Before you upgrade to n8n 3.0

Nodes used (6)

• Manual Triggern8n-nodes-base.manualTrigger
• Google Sheetsn8n-nodes-base.googleSheets
• Coden8n-nodes-base.code
• HTTP Requestn8n-nodes-base.httpRequest
• Send Emailn8n-nodes-base.emailSend
• Schedule Triggern8n-nodes-base.scheduleTrigger

From the author

Automatically fetches daily sales, shifts, and receipts from Loyverse. Calculates gross profit, net operating profit, other key metrics, saves them to a Google Sheet and sends out a daily report via email. Who’s it for This template is for any business owner,…

View the original on n8n.io → Check your own copy