What is the Tiller Community Solutions (formerly Tiller Money Labs) add-on?
The Tiller Community Solutions add-on allows you to easily discover and explore financial spreadsheet templates built by members of the Tiller Community and leverage powerful tools for boosting your financial tracking productivity. You can quickly add a new solution into any Google Sheet powered by the Tiller Money Feeds add-on.
The Tiller Community Solutions Add-on takes a modular approach to experimenting with various financial spreadsheet templates, making it easy to discover, integrate, and manage new workflows and dashboards. Quickly drop a Debt Progress or Net Worth sheet right into your Foundation Template.
- Discover and easily add compatible single or multi-sheet spreadsheet solutions and workflows.
- Track and manage solution versioning with easy restore and upgrade workflows.
- Use tools like splitting transactions, manually adding and reconciling transactions, running reports, and importing CSV line items.
Note: This tool is works best with sheets being fed by the Tiller Money Feeds add-on for Google Sheets. The Tiller Console will indicate whether your sheet is a Feedbot or Feeds add-on powered sheet. Some solutions are not compatible with Feedbot sheets
How to Install the Tiller Community Solutions Add-on
- Open the add-on store listing and click Install near the top.
- Click âContinueâ when prompted by a modal in this sheet.
- Authorize the add-on to run with your Google account.
- Open a blank Google Sheet or your Tiller Foundation Template.
- Open the Extensions menu and choose
Tiller Community Solutions
near the bottom. - Choose âLaunchâ.
- Review and accept the Tiller Community Solutions and Privacy disclosures.
- Browse and install solutions.
Included Solutions & workflows
Solutions
You can browse a list of solutions available in the Tiller Community Solutions add-on on the Tiller website at https://www.tillerhq.com/community-solutions/
Tools & Workflows
- Reconcile manually added transactions - Use Tiller Money Feeds to manually add transactions now.
- Rename Category - from the tools menu
- Import CSV line items from other tools like Mint, Personal Capital, YNAB, and Amazon
- Create reports
- Sanitize a sheet for sharing in the community
- Migration Helper for transitioning customized data from one Tiller Google Sheet to another
- Trim Balance History
How to Install a Solution
You can install solutions via the Tiller Community Solutions add-on into any Tiller Money Feeds add-on powered Google Sheet. If a solution is incompatible with the current sheet in which youâre trying to install it, the add-on will let you know.
- Open the add-ons menu at the top of your Google Sheet
- Choose Tiller Community Solutions > Launch
- Choose a tag from the dropdown in the âExploreâ tab. Alternatively, you can search for solution keywords using the search feature at the top of the add-on.
- Browse the solutions for the tag.
- Click on a sheet to review the details. In some cases, a solution may require dependent sheets or columns. The add-on will add dependent sheets & columns if necessary.
- Choose âAdd to spreadsheetâ for any solutions you want to add.
The add-on sidebar will indicate itâs installing the sheet and one or more tabs will appear in your Google Sheet. Post install, youâll be directed to the âHelpâ tab for the solution where you can access the support topic in the community as well as existing topics about the solution.
Please note, these solutions are supported here in the Tiller Community and are not supported by Tillerâs success team via the chat tool or support email.
How to supercharge your Google Sheet with automated financial feeds from Tiller
Use the Tiller Money Feeds add-on to feed your daily spending, transactions, and balances into the Google Sheet youâve been using to experiment with these community solutions in 4 easy steps:
- Start your free trial if you havenât already.
- Add financial accounts to the Tiller Console
- Install the Tiller Money Feeds add-on
- Launch the add-on in your Google Sheet to automated your data entry
How to Update or Restore an Installed Solution
Solutions that you install using the Tiller Community Solutions add-on are âmanaged solutions.â You can update or restore these by visiting the âManaged Solutionsâ pane in the add-on. Here you will see what solutions the add-on has installed and also if updated versions are available.
If an update is available, the add-on can update the solution to the latest version. The add-on can also restore a solution for you if youâve made an edit that has caused an error in a dashboard.
- Launch (or Install) the Tiller Community Solutions add-on.
- Click the âManageâ tab
- Click the dropdown triangle for the solution you wish to update or restore.
- Choose âUpdate Solutionâ or âRestore Solutionâ.
- Choose whether you want to overwrite existing or create an archive.
- Copy configuration data from the archive to the new version if necessary
NOTE: We recommend archiving sheets that have configuration data, especially the Accounts sheets. Other sheets that often contain configuration data are Debt Progress, Statements, Spending Money, and the Holiday Gift Tracker.
How to Learn More About an Installed Solution
You can get more details and quickly access the help content about an installed solution using the following steps:
- Click on the installed solutionâs tab at the bottom of your Google Sheet
- Launch the Tiller Community Solutions add-on from the Add-ons menu at the top of the Google Sheet. You can also choose Solutions > Get Help.
- Click the âHelpâ tab
- Click to navigate to the support documentation or recent threads about the solution.
You can review the version history for changes, fixes, and upgrades made to the solution under Manage Solutions in the sidebar.
Troubleshooting & FAQ
Are Tiller Community Solutions add-ons, solutions and templates supported by Tiller?
Tiller Community Solutions add-on installation and mechanics are supported by the Tiller team. The add-on itself is a Tiller product that serves as a delivery mechanism for solutions created by Tiller Community members. Solutions, workflows, and tools installed or managed within the add-on are supported by the Tiller Community.
Why is the add-on asking me to adopt a sheet?
The Tiller Community Solutions add-on uses metadata to read and write version metadata to individual sheets in your Google spreadsheet. Feed Bot powered Google Sheets created prior to August 26, 2019 do not have any version metadata information for Transactions, Categories, and Balance History. The Tiller Community Solutions add-on can understand what these sheets should look like and will ask you to adopt them and assign version metadata upon first startup in your sheet. This helps determine whether solutions available in the Tiller Community Solutions add-on are compatible or not.
How does the add-on use the requested scopes?
âSee, edit, create, and delete your spreadsheets in Google Driveâ
https://www.googleapis.com/auth/spreadsheets
Allows access to the Google Sheets v4 API to execute batch changes to spreadsheetsâ like inserting new sheets and updating existing ones
âDisplay and run third-party web content in prompts and sidebars inside Google applicationsâ
https://www.googleapis.com/auth/script.container.ui
Implements the sidebar user interface
âConnect to an external serviceâ
https://www.googleapis.com/auth/script.external_request
Fetches the Tiller-hosted solutions list
âAllow this application to run when you are not presentâ
https://www.googleapis.com/auth/script.scriptapp
Loads user-interface code & html assets stored in the add-on
Can I use this add-on if I have Advanced Protection turned on?
Due to the permissions and scopes required for the add-on at this time you cannot use the add-on with a Google account that has Advanced Protection turned on. Our recommendation right now is to install and run the add-on using a separate Google account that does not have advanced protection turned on.
Ask a question or get help
If you have a question or need help first search the community to see if someone has already asked and if not click here to quickly post a question about this tool in the Google Sheets category.
Be sure to customize the title of your post with keywords about the issue or question so others can easily find the Q&A in search.