AutoCat won't run when I choose "Run" from the AutoCat Run dropdown menu

  1. Make sure there aren't any blank rows in the AutoCat ruleset sheet.
  2. Make sure all your Categories are valid and don't have errors. Errors/invalid categories are indicated by a red triangle in the upper right corner of a Category cell. This indicates you renamed or removed a category from the Categories sheet. 
  3. If either of the above was true, try running AutoCat again by choosing "Run" from the "Run AutoCat" dropdown in cell F2 on the AutoCat sheet. 

If you still can't get AutoCat to run, try turning the Run Automatically feature on then off. 

  1. Open the Add-ons menu at the top of the Google Sheet
  2. Choose Tiller > Tools > AutoCat > Run Automatically 

If it indicates that automatic run was already turned on, turn it off then back on. 

  1. Open the Add-ons menu at the top of the Google Sheet
  2. Choose Tiller > Tools > AutoCat > Don't Run Automatically 
  3. Then turn it back on. 

If that still doesn't work try re-installing the AutoCat sheet. 

  1. Change the name of your existing AutoCat sheet from AutoCat to AutoCat-old by double clicking the tab to rename. 
  2. Refresh your browser to refresh the sheet so the Tiller add-on will no longer "see" the AutoCat sheet. 
  3. Open the Add-ons menu from the top of the Google Sheet.
  4. Choose Tiller > Tools > AutoCat > Create
  5. Copy/paste your ruleset from the AutoCat-Old sheet to the new one. Right click and choose Paste Special > Values only for best results.
  6. Run AutoCat.

Getting "Authorization is required to perform this action" error

You may receive this message when trying to run or install AutoCat if you're logged into multiple Google Accounts in the same browser session. 

To fix:

  1. Visit the Tiller Console and click the log out button at the bottom. 
  2. Log out of all Google Accounts in your browser (visit gmail.com and log out).
  3. Log back in to the Tiller Console.
  4. Open your sheet and re-run the add-on. 

AutoCat is not running automatically in my sheet

If you have the Automatic Run feature turned on, but find that AutoCat is not running automatically and categorizing transactions in the background for you. 

  1. Open the Add-ons menu at the top of the Google Sheet
  2. Choose Tiller > Tools > AutoCat > Don't Run Automatically 
  3. Turn the Automatic Run feature back on: Choose Tiller > Tools > AutoCat > Run Automatically 

AutoCat is stuck on "AutoCat Running...."

How to Fix It

  1. Delete the words "AutoCat running..." from the cell (Cell E3).
  2. Make sure there aren't any blank rows in the AutoCat rules you’ve set up. If there are blank rows, delete them.
  3. Set the Run dropdown back to "Ready."
  4. Refresh your browser to refresh your sheet.
  5. Set the Run dropdown to “Run.”

AutoCat won't run because Account Column is missing

If you're using an older version of a Tiller spreadsheet template you might not have the account column, which is required for AutoCat to run. 

  1. Insert a new column
  2. Title it Account

AutoCat gives a "Cannot call method "copy" of null" error

If your category validation is broken (or you don't have a Category column) on your Transactions sheet you may get this error when trying to run AutoCat. 

To fix:

If your sheet is not set up to use Categories (raw data template) 

  1. Add the Categories sheet and create your categories list
  2. Add the Category column to your Transactions sheet 
  3. Set up the validation for the Category column using these steps

If your category column is missing the dropdown box

  1. Fix your category validation using  these steps

Need More Help?

Are you still having trouble? For more help, reach out to support@tillerhq.com or use the chat window in the lower right corner of this page.

Did this answer your question?