# \#scripts **URL:** https://community.tiller.com/tag/scripts/77.md [Latest](https://community.tiller.com/latest.md) · [Categories](https://community.tiller.com/categories.md) · [Tags](https://community.tiller.com/tags.md) --- ## [New Amazon import process just released on Google Marketplace](https://community.tiller.com/t/new-amazon-import-process-just-released-on-google-marketplace/34441)
**Author:** [@daveahlers](https://community.tiller.com/u/daveahlers)\ **Replies:** 93\ **Last updated:** [September 23, 2026, 1:14am UTC](https://community.tiller.com/t/new-amazon-import-process-just-released-on-google-marketplace/34441 "2026-09-23T01:14:54Z")
Update: Finally approved by Google, and can be installed from here: https://workspace.google.com/marketplace/app/tiller\_tools\_by\_dave/135351721412 User guide here: GitHub - daveinlosbarriles/TillerTools: Provides Amazon… --- ## [Investment Balances to Budget Sheet Without Transactions](https://community.tiller.com/t/investment-balances-to-budget-sheet-without-transactions/30524)
**Author:** [@m00](https://community.tiller.com/u/m00)\ **Replies:** 8\ **Last updated:** [September 8, 2026, 4:53pm UTC](https://community.tiller.com/t/investment-balances-to-budget-sheet-without-transactions/30524 "2026-09-08T16:53:04Z")
Overview I have 2 Tiller sheets, one for Investments and one for Budgeting. I would like to have the balances of my Investments sheet show up in my Budgeting sheet, but do not want to add them as accounts, and get all … --- ## [Including Redfin Home Values Automatically](https://community.tiller.com/t/including-redfin-home-values-automatically/29994)
**Author:** [@bwentwor](https://community.tiller.com/u/bwentwor)\ **Replies:** 21\ **Last updated:** [August 25, 2026, 8:04pm UTC](https://community.tiller.com/t/including-redfin-home-values-automatically/29994 "2026-08-25T20:04:25Z")
I wanted to include the value of my home in my assets and could not find an automated way to do it until recently. The way that I implemented this solution expands upon this thread: Home Value for Net Worth - #13 by jpm.… --- ## [Introducing AutoKitten, an alternative to AutoCat](https://community.tiller.com/t/introducing-autokitten-an-alternative-to-autocat/30154)
**Author:** [@andrei](https://community.tiller.com/u/andrei)\ **Replies:** 54\ **Last updated:** [August 4, 2026, 6:12pm UTC](https://community.tiller.com/t/introducing-autokitten-an-alternative-to-autocat/30154 "2026-08-04T18:12:17Z")
AutoCat is great, however there were a few things I had difficulty with: Rules are not flexible enough - I needed some complex logic and to change descriptions or adjust amounts; Adding rules is very slow; Editing rule… --- ## [Import/remap CSV](https://community.tiller.com/t/import-remap-csv/31466)
**Author:** [@jack.bates](https://community.tiller.com/u/jack.bates)\ **Replies:** 13\ **Last updated:** [July 20, 2026, 3:57pm UTC](https://community.tiller.com/t/import-remap-csv/31466 "2026-07-20T15:57:40Z")
Overview This is the script I use to manually import my Canadian transactions. You install it the same way you install Simple CSV Import, by copying the Code.js and Index.html files into a new Apps Script project. You… --- ## [Code for maintaining vehicle values automatically](https://community.tiller.com/t/code-for-maintaining-vehicle-values-automatically/34166)
**Author:** [@andrei](https://community.tiller.com/u/andrei)\ **Replies:** 8\ **Last updated:** [June 23, 2026, 11:53am UTC](https://community.tiller.com/t/code-for-maintaining-vehicle-values-automatically/34166 "2026-06-23T11:53:55Z")
Hi all, allow me to share a Google Sheet for maintaining your vehicle values automatically: To use this code, you need to create a manual account for each car as follows: Account name - enter a nickname for your car… --- ## [Auto Insert generated paycheck deduction transactions (Apps Script)](https://community.tiller.com/t/auto-insert-generated-paycheck-deduction-transactions-apps-script/29976)
**Author:** [@m00](https://community.tiller.com/u/m00)\ **Replies:** 8\ **Last updated:** [May 27, 2026, 7:21pm UTC](https://community.tiller.com/t/auto-insert-generated-paycheck-deduction-transactions-apps-script/29976 "2026-05-27T19:21:36Z")
Overview This is a helper function for jpfieber’s Paycheck Deduction Transaction Generator. It will automatically (with a click) insert the generated transaction rows into the Transactions sheet. Installation It is a… --- ## [Custom UI Menu with Google Apps Script](https://community.tiller.com/t/custom-ui-menu-with-google-apps-script/29980)
**Author:** [@m00](https://community.tiller.com/u/m00)\ **Replies:** 3\ **Last updated:** [October 8, 2025, 5:10pm UTC](https://community.tiller.com/t/custom-ui-menu-with-google-apps-script/29980 "2025-10-08T17:10:46Z")
Custom UI Menu with Google Apps Script Want to make a custom UI to quickly run your Google Apps Script functions? Here is how to quickly get another UI menu that you can fill with anything you want. Initial Setup O… --- ## [Automatic "Transfer" Matcher with Clickable Links (Google Apps script version)](https://community.tiller.com/t/automatic-transfer-matcher-with-clickable-links-google-apps-script-version/30525)
**Author:** [@alan.heatherley](https://community.tiller.com/u/alan.heatherley)\ **Replies:** 0\ **Last updated:** [February 6, 2025, 9:13pm UTC](https://community.tiller.com/t/automatic-transfer-matcher-with-clickable-links-google-apps-script-version/30525 "2025-02-06T21:13:37Z")
Overview This solution provides a clickable link in your Transaction sheet that takes you to the other side of a transfer. This solution can usually automatically identify the 2 transactions that represent the origin a… --- ## [Adding a "kill switch" to stop reports from recalculating while filling transactions](https://community.tiller.com/t/adding-a-kill-switch-to-stop-reports-from-recalculating-while-filling-transactions/29319)
**Author:** [@alan.heatherley](https://community.tiller.com/u/alan.heatherley)\ **Replies:** 2\ **Last updated:** [December 10, 2024, 5:11pm UTC](https://community.tiller.com/t/adding-a-kill-switch-to-stop-reports-from-recalculating-while-filling-transactions/29319 "2024-12-10T17:11:02Z")
Overview I’ve had a bit of trouble with filling data and adding manual transactions taking an excruciatingly long time - sometimes upwards of 90 seconds. There are a lot of great suggestions on this community already f… --- ## [Script to scrape Sofi Credit Card transactions into your Tiller Spreadsheet](https://community.tiller.com/t/script-to-scrape-sofi-credit-card-transactions-into-your-tiller-spreadsheet/21784)
**Author:** [@ebonsignori](https://community.tiller.com/u/ebonsignori)\ **Replies:** 2\ **Last updated:** [August 4, 2024, 6:10pm UTC](https://community.tiller.com/t/script-to-scrape-sofi-credit-card-transactions-into-your-tiller-spreadsheet/21784 "2024-08-04T18:10:58Z")
Per Is SoFi Credit Card supported? , Sofi Credit Cards aren’t yet supported for automatic importing. Wrote a little script that you can run in your console to get a .csv of transactions that you can paste into you sprea… --- ## [Track the Value of Your Vehicle with a vinAudit Script](https://community.tiller.com/t/track-the-value-of-your-vehicle-with-a-vinaudit-script/5346)
**Author:** [@kevinmclaughlin](https://community.tiller.com/u/kevinmclaughlin)\ **Replies:** 24\ **Last updated:** [January 14, 2024, 8:52pm UTC](https://community.tiller.com/t/track-the-value-of-your-vehicle-with-a-vinaudit-script/5346 "2024-01-14T20:52:35Z")
Based on the \[Track the value of your home via a Zillow script example I created a Google script that will track the value of a car using the VIN number and vinAudit. vinAudit (Simple) Automation The tiller-vinaudit-sim… --- ## [Email/text-msg Alerting Based on a Transaction (Google Sheets)](https://community.tiller.com/t/email-text-msg-alerting-based-on-a-transaction-google-sheets/18677)
**Author:** [@albano.mike](https://community.tiller.com/u/albano.mike)\ **Replies:** 5\ **Last updated:** [July 20, 2023, 5:59pm UTC](https://community.tiller.com/t/email-text-msg-alerting-based-on-a-transaction-google-sheets/18677 "2023-07-20T17:59:51Z")
Sharing my use-case and solution here. What brought me to Tiller was a need to send myself an alert (text message, email, etc.) if/when a transaction appears on any account which matches a search string. Use Case I canc… --- ## [Script to archive columns in google sheets](https://community.tiller.com/t/script-to-archive-columns-in-google-sheets/13890)
**Author:** [@bees22](https://community.tiller.com/u/bees22)\ **Replies:** 1\ **Last updated:** [September 1, 2022, 12:26pm UTC](https://community.tiller.com/t/script-to-archive-columns-in-google-sheets/13890 "2022-09-01T12:26:14Z")
Hello! I am looking to write a script that takes the entire columns of data in columns B and C, and archives/inserts it into D&E on a weekly basis, so that eventually the older data is on the far right with weekly newer… --- ## [Startup Macro or Script to reduce steps required to fill my spreadsheet with new data](https://community.tiller.com/t/startup-macro-or-script-to-reduce-steps-required-to-fill-my-spreadsheet-with-new-data/12617)
**Author:** [@bprojects](https://community.tiller.com/u/bprojects)\ **Replies:** 5\ **Last updated:** [May 19, 2022, 6:47pm UTC](https://community.tiller.com/t/startup-macro-or-script-to-reduce-steps-required-to-fill-my-spreadsheet-with-new-data/12617 "2022-05-19T18:47:06Z")
To open and begin work on my tiller spreadsheet (which I primarily use once monthly to track expenses for tax purposes) I need to take the following 13 steps (less steps 6-10 if i log in more often). Surely there must be… --- ## [Tags in Transactions - multiselect and data validated, but errors in the Tags Report](https://community.tiller.com/t/tags-in-transactions-multiselect-and-data-validated-but-errors-in-the-tags-report/12153)
**Author:** [@kjlawless](https://community.tiller.com/u/kjlawless)\ **Replies:** 5\ **Last updated:** [April 10, 2022, 7:45pm UTC](https://community.tiller.com/t/tags-in-transactions-multiselect-and-data-validated-but-errors-in-the-tags-report/12153 "2022-04-10T19:45:43Z")
:wave: Hi all, I have what I think is a scripting issue I’d love some eyes on… Admittedly, I’m very new to script editing, so I’d appreciate any help with this. I’ve used the Tags column in my Transactions spreadsheet … --- ## [Adding a Manual Transaction using Google Apps Script](https://community.tiller.com/t/adding-a-manual-transaction-using-google-apps-script/6663)
**Author:** [@mttandrsn](https://community.tiller.com/u/mttandrsn)\ **Replies:** 5\ **Last updated:** [August 20, 2021, 5:54pm UTC](https://community.tiller.com/t/adding-a-manual-transaction-using-google-apps-script/6663 "2021-08-20T17:54:32Z")
I’m trying to automate more things in my Tiller sheet, one of them being adding credit card payments as manual/future transactions, so I can see my account balance projection over time. I’m able to pull my statement dat… --- ## [Script for matching Simple Bank expenses to transaction categories](https://community.tiller.com/t/script-for-matching-simple-bank-expenses-to-transaction-categories/6683)
**Author:** [@benmccormack](https://community.tiller.com/u/benmccormack)\ **Replies:** 0\ **Last updated:** [December 29, 2020, 5:35pm UTC](https://community.tiller.com/t/script-for-matching-simple-bank-expenses-to-transaction-categories/6683 "2020-12-29T17:35:14Z")
I wrote some Google Apps Script code for updating transaction categories in a Tiller transactions spreadsheet based on transactions exported from Simple Bank. The code is available on Github at https://github.com/bmccorm… --- ## [How Do I Archive Data in a Cell Daily](https://community.tiller.com/t/how-do-i-archive-data-in-a-cell-daily/4890)
**Author:** [@susandennis](https://community.tiller.com/u/susandennis)\ **Replies:** 4\ **Last updated:** [July 25, 2020, 9:20pm UTC](https://community.tiller.com/t/how-do-i-archive-data-in-a-cell-daily/4890 "2020-07-25T21:20:46Z")
I have a me-made sheet in my Tiller template. I set it up to automatically copy over one number from my Budget sheet. Then every day, I copy that number down to another cell (one with a date) and then add it to another…