Latenode

Automatically sync Splitwise expenses to Google Sheets

This automation integration allows users to automatically monitor and record new expenses added to their Splitwise account. It will automatically extract the transaction details, including the description, amount, and date, and log this information in a designated Google Sheets spreadsheet.

This provides users with a centralized and organized record of their shared expenses, streamlining expense tracking and management. The automation connects the Splitwise and Google Sheets platforms, enabling seamless data flow between the two systems to facilitate better financial oversight and collaboration.

Updated Apr 6, 2026Est. run: 26sEst. cost: $0.0703
How Latenode estimates time and cost

Latenode bills workflow runs in credits: 1 credit = 30 seconds of processing. Minimum charge per run depends on your plan. 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 credits work →
Data, spreadsheets & databases

Workflow preview

What this template does

  • Extracts transaction details from a Splitwise account
  • Normalizes the extracted data (description, amount, date)
  • Stores the normalized data in a designated Google Sheets spreadsheet
  • Filters for new expenses and avoids duplicates in the spreadsheet
  • Provides a centralized record of shared expenses for better financial oversight

How it works

1
Trigger

Connect to Splitwise

The automation integration begins by connecting to the user's Splitwise account. This establishes the necessary authentication and authorization to access the user's expense data from Splitwise.

2
Logic

Fetch new expenses from Splitwise

The automation then fetches the details of any new expenses that have been added to the user's Splitwise account since the last sync. This includes the expense description, amount, and date.

3
Action

Scrape expense details from Splitwise

Using a headless browser integration, the automation extracts the transaction details for each new expense from the Splitwise website. This includes parsing the expense description, amount, and date from the Splitwise expense page.

4
Logic

Transform expense data

The automation then normalizes and prepares the extracted expense data for ingestion into the Google Sheets spreadsheet. This may involve formatting the data, handling any necessary unit conversions, or structuring the information in a way that aligns with the Google Sheets template.

5
Action

Log expense in Google Sheets

Finally, the automation adds a new row to the designated Google Sheets spreadsheet, recording the details of the new expense. This provides the user with a centralized, organized record of their shared expenses, streamlining expense tracking and management.

Setup guide

1

Add Splitwise Credentials

In the Latenode Credentials panel, add your Splitwise account credentials. You can obtain an API key by creating a new Splitwise app on their developer platform.

2

Configure Splitwise Expenses Tracker

Add a Splitwise node to your workflow. In the node settings, configure the following: - Select the Splitwise account credentials added in the previous step - Choose the 'Expenses' operation to fetch new expenses - Specify the date range to monitor for new expenses (e.g. last 7 days)

3

Add Google Sheets Credentials

In the Latenode Credentials panel, add your Google account credentials. You can obtain the necessary OAuth2 credentials by creating a new Google Cloud project and enabling the Google Sheets API.

4

Configure Google Sheets Writer

Add a Google Sheets node to your workflow. In the node settings, configure the following: - Select the Google account credentials added in the previous step - Specify the Google Sheets spreadsheet and worksheet where you want to log the expense details - Map the Splitwise expense data (description, amount, date) to the corresponding Google Sheets columns

5

Test and Activate the Workflow

Review your workflow, make any final adjustments, and then activate the automation. The Splitwise Expenses Tracker will now automatically monitor your Splitwise account for new expenses and log the details in the designated Google Sheets spreadsheet.

Requirements

Connect a Splitwise account with read access to fetch new expenses
Configure a Google Sheets spreadsheet to log the expense details
Grant the automation write access to the designated Google Sheets spreadsheet
Set up the automation to regularly check for new expenses in Splitwise and log them to Google Sheets

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.

More templates

You might also like

Browse all templates →
Data, spreadsheets & databases

Automatically sync Notion items to new Google Docs documents

This automation allows users to automatically create a new Google Docs document whenever a new item is added to a Notion database. It streamlines the process of transferring data from Notion to Google Docs, making it easier for teams to collaborate on documents and reports. The automation triggers when a new item is added to the specified Notion database, and it then creates a corresponding Google Docs document with the relevant information. This integration between Notion and Google Docs helps users to centralize their data and workflows, improving productivity and efficiency.

26s$0.0703
Data, spreadsheets & databases

Automatically generate customized Google Docs from new form data

This automation allows users to create a new Google Doc based on a predefined template, using data from a new submission in a linked Google Form. Whenever a new row is added to the associated Google Sheets spreadsheet, the automation will trigger and generate a personalized document using the form data. This streamlines the process of creating documents from structured data, making it more efficient for individuals or teams working with Google's productivity suite. The primary systems involved are Google Forms, Google Sheets, and Google Docs.

26s$0.0703
Data, spreadsheets & databases

Automatically notify via Burst SMS when new rows added to Google Sheets

This Latenode automation allows users to stay focused on their primary workflows by automatically sending SMS messages through the Burst SMS platform whenever a new row is added to a specified Google Sheets spreadsheet. It connects the Google Sheets data source to the Burst SMS service, streamlining the notification process. Users can configure the specific spreadsheet and mobile number to receive the SMS updates, helping them stay informed without getting distracted from their main tasks.

7s$0.0004