Sync your bank transactions with google sheets using Open Banking APIs

Overview

this is a markdown version of the copy on the site landing page: https://youneedaspreadsheet.com

You need a spreadsheet 📊

Get on top of your finances by tracking all of your bank accounts in Google Sheets. Having a high level view of your money is a budgeting superpower, you'll be able to analyse your spending & savings over the long term, and work out how to hit your money goals. But it'd be a pain to manually update a spreadsheet with your transactions & balances, why not let the robots do it for you? 🤖

How much does it cost? 💸

£2 per month, billed via Stripe.

If you'd like to connect a business account check out the business page.

Is my bank supported? 🏦

You can find the list of supported banks here.

What is it? 💭

UK banks have a pretty cool, but under-adopted feature called 'open banking' which is a set of APIs provided by all banks that allow users & companies to read data, pay & accept payments via a common interface. This page uses Truelayer to connect to your bank and read the balance & transactions, then writes that data into a spreadsheet using the Google Sheets API.

I use this tool to have my current bank balance in a few different spreadsheets, i also feed it into BigQuery as an external table so i can make a Grafana dashboard for my daily spending & budgets, you can find a guide on how to do that here.

Why should i trust you? 🕵️‍♀️

  • This project is open source, you can find it on GitHub.
  • Y.N.A.S never stores or logs any of your data & the only place the data lives is in your bank, and the spreadsheet you configure.
  • The credentials used to access both google sheets and Truelayer are encrypted at rest via Google Cloud's KMS (Key Management Service).
  • Y.N.A.S doesn't read any of your other spreadsheets, only the one created by this app.
  • Y.N.A.S will only use your Google email to identify your account, send receipts, and notify you if there are any issues.
  • Your data is never shared with a third party without your direct written or verbal consent.
Issues
  • The /banks page includes

    The /banks page includes "Mock bank"

    I believe due to using the TrueLayer trial account, the /banks page includes "Mock Bank" as the top entry. The list is also not alphabetically ordered, which I guess is why this appears at the top.

    opened by AranScope 3
  • Stopped Syncing

    Stopped Syncing

    My connection stopped syncing on March 12th, oddly at exactly 13000 records if there's a limit or something. It hasn't synced since, deleting the linked sheet and trying to reconnect it now doesn't work.

    Really appreciate any help you can offer.

    opened by vrekais 5
Owner
Alex Russell-Saw
Engineer @sourcegraph
Alex Russell-Saw
A Wrapper Client for Google Spreadsheet API (Sheets API)

Senmai A Wrapper Client for Google Spreadsheet API (Sheets API) PREPARATION Service Account and Key File Create a service account on Google Cloud Plat

ytnobody / satoshi azuma 0 Nov 5, 2021
SDK to provide access to JUNO API (Open Banking) (2.0.0)

Juno API - Golang SDK Juno API (Open Banking) (2.0.0) Why? This project is part of my personal portfolio, so, I'll be happy if you could provide me an

Vinícius Boscardin 4 Aug 9, 2021
A banking application for golang

banking Run ./start.sh to download the dependencies and run the the application To run the application, you have to define the environment variables,

null 0 Dec 10, 2021
Auto-generated Google APIs for Go.

Google APIs Client Library for Go Getting Started $ go get google.golang.org/api/tasks/v1 $ go get google.golang.org/api/moderator/v1 $ go get google.

Google APIs 3.1k Jun 25, 2022
Go API Client for NASA's Open APIs

Go Client for Nasa Open APIs Description The Go Client for Nasa Open APIs is a Go Client for the following Nasa Open APIs: APOD: Astronomy Picture of

Ernesto H 3 Sep 24, 2021
Correct the timestamp of photo/video of Google Photo from Google takeout

Correct Timestamp of Google Photo from Google Takeout Development Environment: Ubuntu 20.04 Go 1.17 Usage Require Go 1.16 or later to build. go build

Siong-Ui Te (戴上為) 0 Dec 2, 2021
SaltStack transactions tracker

Peephole Peephole is a web-based events explorer of SaltStack transactions. It can be used to watch for events on several SaltStack master nodes by GE

Immobiliare Labs 28 Jan 21, 2022
Tiny go package for fetching high and low value of a stock for any given period range using kite connect historical data APIs.

Tiny go package for fetching high and low value of stock for any given period range using Kite connect Historical data APIs.

Rakesh R 1 Apr 27, 2022
A serverless sync server for Santa, built on AWS

Rudolph Rudolph is the control server counterpart of Santa, and is used to rapidly deploy configurations to Santa agents. Rudolph is built in Amazon W

Airbnb 49 Jun 5, 2022
AWS Tags Updater - Sync tags with all resources via sheet 🐏🐏

AWS Tags Updater - Sync tags with all resources via sheet ????

PePoDev 1 Mar 22, 2022
Use Google REST api to extract your personal Photo Library

Photo Go A better approach to extracting your photos from Google to your personal cloud. I'm moving my photos out of Google to a Synology NAS. create

James 2 Dec 7, 2021
Google Cloud Messaging for application servers implemented using the Go programming language.

gcm The Android SDK provides a nice convenience library (com.google.android.gcm.server) that greatly simplifies the interaction between Java-based app

Adriano Orioli 30 Nov 16, 2021
Simple translation tool using google translation api.

Translator Simple translation tool using google translation api. To use it you have to provide a valid service account as json file with path in the e

eric regnier 0 Feb 1, 2022
Go library to access geocoding and reverse geocoding APIs

GeoService in Go Code Coverage A geocoding service developed in Go's way, idiomatic and elegant, not just in golang. This product is designed to open

Jerry Zhao 433 Jun 24, 2022
A golang client for the Twitch v3 API - public APIs only (for now)

go-twitch Test CLIENT_ID="<my client ID>" go test -v -cover Usage Example File: package main import ( "log" "os" "github.com/knspriggs/go-twi

Kristian Spriggs 21 May 10, 2021
Twilight is an unofficial Golang SDK for Twilio APIs

Twilight is an unofficial Golang SDK for Twilio APIs. Twilight was born as a result of my inability to spell Twilio correctly. I searched for a Twillio Golang client library and couldn’t find any, I decided to build one. Halfway through building this, I realized I had spelled Twilio as Twillio when searching for a client library on Github.

Ghvst Code 18 Jul 2, 2021
The MinIO Admin Go Client SDK provides APIs to manage MinIO services

Golang Admin Client API Reference The MinIO Admin Golang Client SDK provides APIs to manage MinIO services. This quickstart guide will show you how to

High Performance, Kubernetes Native Object Storage 28 Jun 6, 2022
lambda-go-api-proxy makes it easy to port APIs written with Go frameworks such as Gin to AWS Lambda and Amazon API Gateway.

aws-lambda-go-api-proxy makes it easy to run Golang APIs written with frameworks such as Gin with AWS Lambda and Amazon API Gateway.

Amazon Web Services - Labs 667 Jun 26, 2022
"there" also called "GoThere" aims to be a simple Go Library to reduce redundant code for REST APIs.

there "there" also called "GoThere" aims to be a simple Go Library to reduce redundant code for REST APIs. Despite the existence of the other librarie

Christoph Krassnigg 27 Jun 15, 2022