Automate your spreadsheet.
Install in one click.
Recipes are pre-built analysis scripts that add menus, reports, and dashboards directly to your Google Sheet — no coding required.
Open source · Auditable · Community-powered
How Recipes Work
Three steps from the extension to your spreadsheet menu.
Browse the marketplace
Open the Recipe tab in the SheetLink extension popup. Browse official and community recipes.
One-click install
SheetLink injects the script into your spreadsheet's Apps Script project. No copy-paste, no setup.
Run from your menu
A new "SheetLink Recipes" menu appears in your Google Sheet. Click to run any installed recipe.
Recipes are Google Apps Script functions. They run entirely within your Google account — SheetLink never has access to your spreadsheet data outside of the sync process.
Getting Started
First-time setup takes about 2 minutes. This is a one-time requirement from Google.
Enable Google Apps Script API
ONE-TIME SETUPGoogle requires you to enable the Apps Script API in your account settings before recipes can be installed. This is a security feature to prevent unauthorized script modifications.
- ▸Visit script.google.com/home/usersettings
- ▸Toggle on "Google Apps Script API"
- ▸Wait 2-3 minutes for Google's systems to propagate the change
Create Apps Script Project
Initialize your Apps Script project to enable recipe installation.
- ▸Visit script.google.com/home/my
- ▸Click the "New Project" button
Install Your First Recipe
Now you can install recipes from the SheetLink extension.
- ▸Open the SheetLink extension and go to the Recipes tab
- ▸Click "Install" on any recipe
- ▸The recipe will be added to your spreadsheet's "SheetLink Recipes" menu
You will see a "Google hasn't verified this app" warning
This is expected and safe. The "app" is your own Apps Script project — you are both the developer and the user. Google shows this warning for all container-bound scripts that haven't gone through their app verification process (which isn't applicable here since you own the script).
Click "Advanced" → "Go to SheetLink Recipes (unsafe)" to proceed. You're authorizing your own script to modify your own spreadsheet.
Future installs are instant. Once you've completed the authorization flow once, installing additional recipes requires no further setup.
Troubleshooting Common Issues
- Error: "Apps Script API is disabled"
- Make sure you've enabled the API at script.google.com/home/usersettings and waited 2-3 minutes.
- Error: "Requested entity was not found" (404)
- Make sure you completed Step 2 (creating a new Apps Script project). If you just enabled the API, wait a few more minutes for Google's systems to propagate.
- Menu doesn't appear after install
- Refresh your Google Sheet. The menu is added when the spreadsheet reloads.
Available Recipes
4 official recipes maintained by SheetLink, plus community contributions.
Budget Tracker
OfficialTrack spending vs budget by category with multi-month trending. Automatically calculates actuals from your transaction data and shows variance.
Budget Tracker (by Account)
OfficialExtended budget tracker that shows spending by category with a breakdown by account. See which accounts drive spending in each category.
Recurring Spend Detector
OfficialAutomatically detects subscriptions, memberships, and recurring bills. Shows frequency, average amount, total spent, and annualized cost.
Cash Flow Forecast
OfficialSee your cash flow week by week with income, expenses, net change, and projected ending balance. Configurable starting balance.
Financial Statements Suite
Communityby @rudymdc
Professional-grade financial reporting: Chart of Accounts, General Ledger with debit/credit entries, Income Statement, Balance Sheet, and Cash Flow Statement.
Built by the community, for the community
Anyone can contribute a recipe. All community code is public, auditable, and hosted on GitHub. Install counts are tracked anonymously — no personal data stored.
Want to contribute a recipe?
Submit a pull request to the sheetlink-recipes repository. Each recipe is a recipe.gs file that uses the shared utils.gs API — no boilerplate needed. Once merged, it appears in the marketplace automatically.
Is it safe to install a recipe?
Yes. Here's exactly what happens — and what doesn't.
All code is open source
Every recipe is hosted on GitHub. You can read the entire script before installing — nothing is hidden or obfuscated.
Runs in your Google account
Recipes execute as Google Apps Script inside your own spreadsheet. SheetLink is not in the execution path once installed.
Permission is on-demand
The Apps Script permission is only requested when you choose to install a recipe — not on initial sign-in. Core sync works without it.
You control uninstall
Uninstall any recipe from the extension with one click, or delete the script directly from your Apps Script editor.
Ready to automate your spreadsheet?
Install SheetLink and open the Recipe Marketplace from the extension popup.
Get SheetLink FreeFree forever for 7 days of history. No credit card required.