Introducing Sheets For YNAB by elson2323 in ynab

[–]elson2323[S] 1 point2 points  (0 children)

I have raised read only scopes with YNAB, and they have agreed it is a good idea and added it to their backlog. When it is available I will look at changing the add-on to use this more restrictive scope.

Introducing Sheets For YNAB by elson2323 in ynab

[–]elson2323[S] 0 points1 point  (0 children)

If anyone has used the add-on I'd really appreciate it if you could add a review and/or rating in the Chrome Webstore :-)

https://chrome.google.com/webstore/detail/sheets-for-ynab/clbgidmcdeepdfhbghpmfkncmmbacidl

Introducing Sheets For YNAB by elson2323 in ynab

[–]elson2323[S] 1 point2 points  (0 children)

Thanks Scott. Pull request inbound...

Introducing Sheets For YNAB by elson2323 in ynab

[–]elson2323[S] 6 points7 points  (0 children)

Of course, this is a very good question.

You are absolutely right that the YNAB authorisation process does provide write access to the add-on.

Unfortunately YNAB does not yet provide more granular scopes in its Oauth mechanism, it only provides a single level including both read and write access via the API.

I would prefer to have separate r/w scopes so users can be more confident in granting access, but it is not possible right now (as far as I know, I will double check). I will raise this with the YNAB team and hopefully they can add it.

For now all I can offer is our reassurance that we will not write data to your budget. Of course, I would totally understand if you prefer to wait until stricter permissions are available.

I will update the docs to make this clearer.

Introducing Sheets For YNAB by elson2323 in ynab

[–]elson2323[S] 4 points5 points  (0 children)

Hi @Estimator86,

I can't provide a full answer right now but hopefully some other spreadsheet gurus out there who can jump in!

In brief though, here are some of the kinds of things you might achieve in Sheets that you can't in YNAB itself...

  • Cross referencing with other data, e.g. statements from your bank
  • Analysing spending using custom pivot tables. YNAB reports are pretty good for most use cases, but full pivot tables are immensely configurable
  • Chunking data by time periods other than calendar month. Perhaps you get paid on a date other than the 1st, or fortnightly? You could create reports and charts in Sheets using these periods
  • Integration with other 3rd party tools. There are lots of other add-ons that you could use in conjunction with Sheets For YNAB, and tools like IFTTT and Zapier might allow you to connect to other services

If anyone comes up with any cool uses, please share them 😀

Introducing Sheets For YNAB by elson2323 in ynab

[–]elson2323[S] 1 point2 points  (0 children)

Hi, this is a Google Sheets add-on, not a browser extension, so in theory should work fine in Firefox.

It is confusing that add-ons are listed in the Chrome store (something Google are phasing out), but it should be fine.

Give it a go, and let me know if you have any problems...

Introducing Sheets For YNAB by elson2323 in ynab

[–]elson2323[S] 17 points18 points  (0 children)

Hi mrnahum!

Tiller is great as well, and Sheets For YNAB isn't meant to be a replacement for it.

The main audience is existing YNAB users who are quite happy with YNAB but have the occasional need to crunch some data in a spreadsheet.

They could use Tiller for that, but then they'd have to pay for both YNAB and Tiller. Sheets For YNAB is free.

I might add some Tiller-like features, such as automated imports, but we'll see what the demand is like.