My sheet is not updating

Most likely you haven't yet turned on the Auto Fill feature under Settings in the sidebar so you need to click "Fill sheets" in the sidebar manually to have the sheet update. Otherwise, you may need to refresh your accounts on the Console at

Read more about refreshes

Read more about missing transactions

Transactions sheet is not compatible

⚠ This spreadsheet's Transactions sheet is not compatible with Tiller. Archive or delete your Transactions sheet...

This error happens when the word "Date" is missing in row 1 for the Date column in the Transactions sheet. Add the word "Date" back to row 1 in the date column and then click the "reload" link in the warning message.

Spreadsheet incompatible

Sorry, but it looks like this Google Sheet is already being updated by the Tiller Feedbot.

Feed Bot sheets cannot be connected to the Tiller Money Feeds add-on. Learn more about transitioning to Tiller Money Feeds.

Update Failed error

There are a few common update failed errors you might get during the update process (after you click "Fill sheets") if something goes wrong in your sheet.

Failed to update Transactions with Error: Exception: The data validation rule argument "=Statements!$N$3:$N" is invalid

This error is usually due to having a Statement column in the Transactions sheet, but the Statements sheet was removed. You can fix this issue by deleting the Statement column in the Transactions sheet and re-running the update.

Note: if you see a different "argument" that does not reference "Statements" in this error there is a data validation rule in a cell/column on your Transactions sheet that is no longer valid. This means that the sheet referenced in the error (in the example above, Statements) no longer exists in your Google Sheet. To correct this, find the column with an invalid data validation rule and remove it. You can tell a column has an invalid rule by clicking the dropdown in a cell and see an empty list that just presents the word "loading...".

Sidebar doesn't load due to error

If you launch the add-on and get the following error in the sidebar it's usually because you're signed in to more than one Google Account in the browser.

Tiller works best in Google Chrome and we recommend using a dedicated Google Chrome profile for use with Tiller to prevent authentication conflicts like this.

To validate this issue, try using an incognito browser profile and if that works, you should set up a dedicate browser profile.

Did this answer your question?