Latenode

Automatically sync Splitwise expenses to Google Sheets

This template watches Splitwise for new expenses, maps description, amount, date, and expense id in JavaScript, and appends a Google Sheets row.

Connect Splitwise and Google Sheets, pick the group you care about and the spreadsheet, and keep credentials on those connections. Put the Splitwise key on the Splitwise connection.

Updated Sep 16, 2026Est. run: 10sEst. cost: $0.0006
How Latenode estimates time and cost

Latenode bills workflow runtime in CPU seconds. The first 10,000 CPU seconds are free each month, then usage follows pay-as-you-go CPU-second pricing. Plug-and-Play (PnP) AI nodes are billed separately—each PnP token is $1 USD, charged pay-as-you-go at vendor cost plus a small processing fee, with no API keys required.

Full pricing — how CPU seconds work →

Workflow preview

What this template does

  • Logs new Splitwise expenses in Google Sheets
  • Starts when an expense is added
  • Maps description, amount, and date in JavaScript
  • Keeps the Splitwise API key on the Splitwise connection

How it works

1
Trigger

New Splitwise expense

The scenario starts when a new expense is added in the Splitwise account you connect.

2
Logic

Map description, amount, and date

JavaScript reads those fields plus the expense id for the spreadsheet row.

3
Action

Append the row

Google Sheets gets a new row. Search rows by expense id first when you want to skip expenses you already logged.

Setup guide

1

Connect Splitwise

Add a Splitwise connection and paste your Splitwise API key there. Add a trigger for new expenses.

2

Connect Google Sheets

Add a Google Sheets connection. Use a sheet with columns for description, amount, date, and expense id.

3

Map and append

In JavaScript, set description, amount, date, and expense id. Append a Google Sheets row. Add a test expense in Splitwise and confirm the row.

Requirements

A Splitwise account and API key stored on the Splitwise connection
A Google Sheet Latenode can append to
Permission to read expenses and write rows

FAQ

Common questions about this template

Each run uses credits on your Latenode plan. We charge for processing time (1 credit = 30 seconds). Your actual cost depends on your plan and how long the run takes. See pricing plans for plans and how credits work.