I am having trouble with Tiller Money Feeds not working. When I click Add-ons in Google Sheets, select Tiller Money Feeds, and then Update Sheets, it just spins and spins and says Working, and then it times out. I have also tried selecting Open Sidebar, and get the same result. I have tried different browsers and different computers over the past few weeks. I have also uninstalled the Add-on and reinstalled, but have had no success. Does anyone have any other suggestions? thanks
I would try this. Shut down your computer (not restart), wait a couple of minutes, then turn it back on. If it does not work, you have only wasted 3 minutes of time. Let us know.
Have you by chance installed a lot of solutions using the Tiller Money Labs add-on?
If you have a lot of solutions that are trying to process complex formulas in the background this can cause things to slow to a stop.
The help article below outlines the out of the box sheets in the Foundation template. If you have more tabs than this then it could be causing the slow down and you can try removing any you’re not really using and see if that helps?
The other thing that has worked sometimes - thought I don’t recall if this specific behavior - is disabling offline editing.
I tried your suggestions, but they unfortunately didn’t work.
I just use the basic out-of-the-box sheets, plus Debt Progress.
I can’t even get into the sidebar, but can tell you I just have the basic solutions set up.
Any other suggestions?
@khryc debt progress could actually be swamping the processing if you have many accounts configured there and a large Balance History sheet. It’s a processor hog with a lot of complex formulas.
I’d recommend just starting in a fresh sheet, updating it with your data from the same accounts and see if it works fine. If so, then it’s something with that specific sheet and you’ll likely be better off just starting fresh.
Hey everyone, just thought I’d chime in because I had the same issue that khryc was having (assuming you got it solved?) and found a solution to mine.
Similar to khryc, I tried in multiple browsers, with and without extensions, with and without offline editing, but to no avail.
As a bit of background information about the issue, I have 3 google accounts, let’s called them:
- account A
- account B
- account C
Account A is associated with Tiller (it’s the account I log into Tiller with and on which I made the Tiller spreadsheet). I noticed that account B was currently my “default” google account. (I didn’t think this would be an issue because I made sure I was logged into account A when using the Tiller sheet). But as soon as I logged out of all of my google accounts and logged into account A first (causing account A to become the “default”) Tiller Money Feeds loaded up just fine and as quickly as it usually does.
Tl;dr: make sure your current “default” google account is the account also associated with Tiller (if you have >1 google account logged in on your browser).
Thanks @Jeff.Martens !
Another thing we recommend is having a dedicated Google Chrome Browser profile for your Tiller subscribed Google account and only signing into that account in that browser profile. Then you’ll have zero conflicts.
You can see in this screenshot the browser profile is for my Tiller Google account and then there are a few other browser profiles in the list and the option to add more.
You can read more about how to do that here:
If you want the explanation about all this, read on, otherwise just here and go on about your day.
You can tell there is a conflict between the Google user that is signed in to the browser vs the Google user accessing the sheet by looking at the profile pictures or reviewing the account names/emails by clicking on one of the profile pictures.
Because I am signed in to Heather Phillips in the browser (that’s the default) the add-on gets confused about which account I want to use, especially when the default is not the one associated with the subscription (per screenshot and “refused to connect” error below).
Clicking on the profile picture in the upper right of a Google app (sheets, docs, gmail) will show you how many users are signed in to applications in the browser profile you’re using. In the image below, I am signed in to four gmail accounts. Four signed in to apps, but only ONE signed in to the browser, the default.
In general, this is very common especially when we share computers with people who live with us or we have separate work emails and that notorious junk email you use for most things you sign up for on the Internet…
But as you might notice, the Google help content linked above recommends you use a separate browser profile when you share the computer
The dedicated browser profile works because I can’t sign out of the default account in the browser profile it’s assigned to (it’s the default!) and use a different Google account for my Tiller sheet and not continue to run into this issue.
If I choose “sign out of all accounts” it logs me out of that browser profile and “stops synching” and when I sign back in it’s just signed in to the one that the browser profile is assigned to. If that’s the one that’s associated with the subscription, you should be all set. If not, you’ll need to create a separate profile or use a guest / incognito session.
In this particular example, the default Google account also has a Tiller subscription so I get a “link sheet” prompt when I launch Tiller Money Feeds instead of an error / refused to connect message. But I definitely don’t want to link it because it’s already linked to the other subscribing account’s Console/accounts.
Hopefully that helps clarify what’s going on here.