My sheet is not updating

The sheet fill won't complete or I get an update error

Date header is missing in row 1

Transactions sheet is missing

Spreadsheet incompatible

Update failed error

Authorization failed error or issue signing in

Permission denied error, "working.." error, or can't launch add-on



My sheet is not updating

To fill data into your Google Sheet after the initial fill when you first linked the sheet, you need to click "Fill" in the sidebar. The add-on should let you know if there is new data available to fill or if there are accounts that need your attention, which you may need to refresh. You can refresh them on the Console (https://sheets.tillerhq.com/auth/login) or under Connected Accounts in the add-on.

Read more about refreshes

Read more about missing transactions

The sheet fill won't complete or I get an update error

If you click "Fill" and it just seems to fill forever without completing (does not show you how many transactions/balances were added), or you get an "update failed error" the add-on has crashed during the fill due to a high volume of accounts connected or complicated dashboards in your sheet. The fill process should not take more than 5 minutes. If it is still "filling" after 5 minutes or you see an "update failed" error it has crashed.

To prevent the fill from crashing try these steps

  • Clean up your Balance History sheet to remove duplicate or extraneous entries. If you want help automating this, try the Trim Balance History tool from Tiller Community Solutions. The Balance History sheet is hidden by default. Unhide from the View > Hidden sheets menu at the top.

  • Go to the Settings menu in the Tiller Money Feeds add-on and toggle on the Auto Sort Override, which will prevent the add-on from sorting your Transactions or Balance History sheets during the fill. This may speed things up and allow the process to complete. You would then need to manually sort the Transactions and Balance History sheets.

  • Remove extra dashboards/templates/sheets you're not using in the spreadsheet that may be consuming the processor's time limit. The fill process shares a time limit with the sheet's calculation process. If you have many dashboards with complicated formulas that need to recalculate when new data is added to the Transactions sheet this can slow things down and cause the fill to crash.

  • Fill accounts in batches by unlinking all but 3-5 accounts under Connected Accounts per fill.

Date header is missing in row 1

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.

Transactions sheet is missing

You're getting the following error: ⚠ This spreadsheet does not contain a Transactions sheet. Tiller Money Feeds will create this sheet when updating feeds.

This means your Transactions sheet was either accidentally deleted or you renamed it. The add-on expects the Transactions sheet (tab) to be named "Transactions" (without the quotes). If you renamed the Transactions sheet tab, you'll need to rename it back to Transactions in order for the add-on to continue filling your original Transactions sheet and not create a new one.

If you accidentally deleted your Transactions sheet you can restore to a previous version where of the Google Sheet using the version history features under the File menu.

Spreadsheet incompatible

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

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...".

Authorization failed message in the sidebar or issue signing in

Click here for steps on how to fix.

If you launch the add-on from the Extensions menu and get the below Authorization Failed message in the sidebar or you get an error message "This action is not supported while logged into multiple accounts in the same domain or multiple consumer accounts. Please log out and try again." when trying to initially sign in to Tiller from the add-on it means there is a conflict between the default Google user signed in to the browser and the Google account you're trying to use to launch/sign in to the add-on.

We recommend using Tiller in a dedicated Google Chrome browser profile where only the Tiller subscribed email is signed in to prevent these types of account authentication conflicts. You can also review other options to fix the issue below.

Options to fix this issue:

  1. Change the default user in the browser

  2. Use a dedicated Google Chrome browser profile

See: what to do if none of these steps help.

To change or set the default user:

⚠️ Be sure you know the passwords to all Google accounts signed in when you get to step 3 below before proceeding to step 4 if you will need to sign back in to those accounts.

  1. Click the profile icon in the upper right of the spreadsheet where you saw the error.

  2. Make sure you have your Google account passwords handy if you don't remember them, then choose "Sign out of all accounts."

  3. Click "Continue" - DO NOT click "Sign in again"

  4. Sign in to the Google account associated with your Tiller subscription. You must sign in to this account first in order to set it as the default.

  5. After signing in you'll be redirected to the Google Drive for this Google account.

  6. Re-open your Google Sheet from this Google Drive or access it from https://sheets.tillerhq.com/auth/login

  7. Launch the Tiller Money Feeds add-on from near the bottom of the Extensions menu. Please note that the Tiller Money Feeds menu can take a few seconds to load so if you just see "Help" just try again after a few seconds.

You can then sign in to other Google accounts in the browser and this won't interfere with your use of Tiller.

Use a dedicated Google Chrome browser profile

  1. Launch Google Chrome

  2. Click the top most profile icon in the upper right

  3. Click "+ Add" at the bottom

  4. Click "Sign in" and sign in to the Google account you used to subscribe to Tiller

If you already have a browser profile for this Google user, sign out of other Google accounts in the profile and only use your Tiller subscribed Google account or set your Tiller-subscribed Google account as the default.

If none of these steps help

  1. Open a new conversation/ask a question using the chat tool in the lower right at https://sheets.tillerhq.com/auth/login

  2. Choose Troubleshoot an issue > Tiller Money Feeds sidebar option

  3. Let us know you're seeing the Authorization Failed error and the help center steps aren't helping.

  4. Send us a screenshot (from your computer, not a pic from your phone please) of the logged in profiles when you access Gmail at https://www.gmail.com

    1. Click your profile icon in the upper right of Gmail (not the browser window)

    2. Take a screenshot of all logged in users

    3. Send us the screenshot. It should look like the example below.

Getting a permission denied error / can't launch add-on

You're trying to launch the add-on from the Document add-ons sidebar (Extensions > Add-ons > Document add-ons) by clicking "use" and you get a permission denied error or you just see the "working" message at the bottom and nothing happens.

To fix:

  1. Open the Extensions menu at the top of your Google Sheet.

  2. Choose Tiller Money Feeds near the bottom of the Extensions menu > Launch

    1. Please note it can take a few seconds for the Tiller Money Feeds menu to full load from Extensions. If you just see "Help" close the Extensions menu, just wait a second and try again.

Did this answer your question?