Ready-made analysis,in one click.
Recipes add budgets, recurring-charge checks, cash-flow forecasts and financial statements to your Google Sheet. Open source, no coding.
Recipes work in Google Sheets, from the Chrome extension.
Five recipes, all open source.
Budget TrackerOfficial
Spending against budget by category, with multi-month trends. Actuals come from your transactions, with the variance shown.
Budget Tracker (by Account)Official
The budget tracker with a breakdown by account, so you can see which accounts drive spending in each category.
Recurring Spend DetectorOfficial
Finds subscriptions, memberships and recurring bills, with frequency, average amount, total spent and annualized cost.
Cash Flow ForecastOfficial
Cash flow week by week: income, expenses, net change and a projected ending balance from a starting balance you set.
Financial Statements SuiteOfficial
Chart of accounts, a general ledger with debit and credit entries, an income statement, a balance sheet and a cash flow statement.
How recipes work.
Pick a recipe
Open the Recipes tab in the SheetLink extension.
Install it
SheetLink adds the script to your spreadsheet’s Apps Script project. No copy and paste.
Run it from your menu
A SheetLink Recipes menu appears in your sheet. Run any installed recipe from there.
Recipes run entirely in your Google account. SheetLink never has access to your spreadsheet data outside of a sync.
First-time setup.
About two minutes, once. Google asks for it before any script can be installed.
Turn on the Google Apps Script API
Visit script.google.com/home/usersettings, switch on “Google Apps Script API” and give Google two or three minutes to catch up.
Create an Apps Script project
Visit script.google.com/home/my and click New Project.
Install your first recipe
Open SheetLink’s Recipes tab and click Install. The recipe joins the SheetLink Recipes menu in your sheet.
You’ll see “Google hasn’t verified this app”. That’s expected: the app is your own Apps Script project, so you are both its developer and its user. Click Advanced, then “Go to SheetLink Recipes (unsafe)” to authorize your own script on your own sheet. Later installs need no setup.
If something goes wrong
“Apps Script API is disabled”
Turn the API on at script.google.com/home/usersettings and wait two or three minutes.
“Requested entity was not found” (404)
Make sure you created a new Apps Script project (step 2). If you just turned the API on, wait a few more minutes.
The menu doesn’t appear after installing
Reload your Google Sheet. The menu is added when the spreadsheet loads.
Is a recipe safe to install?
All code is open source
Every recipe is on GitHub. Read the whole script before you install it; nothing is hidden or obfuscated.
Runs in your Google account
Recipes run as Google Apps Script inside your own spreadsheet. SheetLink isn’t in the path once they’re installed.
Permission when you ask for it
The Apps Script permission is requested when you install a recipe, not at sign-in. Syncing works without it.
Remove any time
Uninstall a recipe from the extension, or delete the script in the Apps Script editor.
Write your own.
Anyone can contribute a recipe: a recipe.gs file that uses the shared utils.gs, sent as a pull request to sheetlink-recipes. Install counts are kept anonymously.
Your sheet, analyzed.
Install SheetLink and open the Recipes tab.