All Collections
Categories
Troubleshooting
AutoCat for Google Sheets Troubleshooting
AutoCat for Google Sheets Troubleshooting
Get troubleshooting tips for AutoCat for Google Sheets
Heather Phillips avatar
Written by Heather Phillips
Updated over a week ago

I'm seeing errors in the sidebar after running AutoCat in the Tiller Money Feeds add-on 

  • Your sheet is NOT sorted newest to oldest AND you have a filter turned on for one of the columns that is filtering out an invalid category (i.e. a category that does not exist on your Categories sheet).

To fix: 

  1. Select all the data in your sheet and turn off the filter

  2. Sort your sheet from newest to oldest by the date column

  3. Re-run AutoCat

I'm getting an error that my spreadsheet is not compatible with this version of AutoCat

  • This means you're trying to install or use AutoCat for Feed Bot in a Tiller Money Feeds add-on powered sheet. 

To fix: 

  • Open the Tiller Money Feeds add-on from the Add-ons (or Extensions) menu at the top of your Google Sheet

  • Click AutoCat in the sidebar

  • Install AutoCat

I'm getting a popup in my AutoCat sheet that a newer version is available

You receive this message if you're trying to run AutoCat for Feed Bot in a Tiller Money Feeds sheet. 

To fix: 

  1. Refresh your Google Sheet/browser 

  2. Open the Tiller Money Feeds add-on from the Add-ons (or Extensions) menu at the top of your Google Sheet

  3. Choose AutoCat and migrate, install, or run AutoCat in the sheet. 

After I click "Run AutoCat" the process never finishes

If the AutoCat run process seems to take forever and never complete it has likely crashed. If the run process takes more than about 5 minutes it has definitely crashed. Sometimes certain conditions in your filter criteria can cause AutoCat to crash. These are possible causes.

  • double "" somewhere in the list of filter criteria for your rules

  • categories that contain apostrohpes

  • several thousand extra blank rows at the bottom of your Transactions sheet

I see a "No rules present in AutoCat sheet" error

After opening the AutoCat sidebar you see a "no rules present in AutoCat sheet" error at the top.

  • Make sure that your AutoCat sheet header row (the blue one) is in row 1

  • Make sure the header row has both "Category" and "Description contains" (without the quotes) in the AutoCat sheet - usually this is in cell A1 and B1 - AutoCat won't recognize there are rules without the Category or Description Contains columns

I see a "Transactions Sheet Required" error

After opening the AutoCat sidebar you see a "Transactions Sheet Required" error.

  • Make sure you haven't renamed or removed your Transactions sheet

Did this answer your question?