@stephenk yes, but with lots of caveats.
First, the Auto Update feature runs at a specific time every day, I think 2AM (somewhere - I don’t know if that’s 2AM local time or 2AM EST - it seems to be consistently around 2AM for me, but I’m on the East coast USA).
Let’s say you do not have 2FA turned on for ANY account, and none of your institutions EXPECT you to have any multi-factor authentication turned on. Generally, if your refreshes don’t happen until 3AM then the Auto Update wouldn’t have anything to bring in BUT if the daily email goes out at 8AM you would see the transactions in the daily email, but not the sheet.
Second, and to get even more detailed with how it all works right now, and this is an industry level thing that most 3rd party tools (like Tiller Money and Personal Capital) using Yodlee (our data provider) have to try and work around:
Some institutions require or expect some type of multi-factor authentication to be turned on (MFA) even if you do not have it turned on. These institutions have a “MFA Credentials” auth type. Some institutions have Auto Refresh enabled or disabled depending on the refresh health of the institution. There is a global Auto Refresh status and a individual user login Auto Refresh status. So Chase could globally have Auto Refresh enabled, but your particular login might not have it enabled because it consistently fails. Right now about 45% (and growing) of Yodlee’s supported institutions use the MFA Credentials auth type with Auto Refresh enabled at the Institution level.
For MFA requirements, this might be 2FA codes (most secure). It could also be security questions (e.g. where did you go to high school?) (medium secure). If it’s security questions, and Yodlee learns all the answers AND Auto Refresh is enabled for your login our system can pull the data without you visiting the console. If this happens before 2AM the Auto Update can grab it and put it in your sheet. If Auto Refresh is disabled you will have to visit the console to refresh and then manually update your sheet afterward. If you have 2FA on for your account it doesn’t matter if Auto Refresh is enabled or disabled, you will have to visit the console to refresh.
In any scenario where visiting the console is required to refresh, Auto Update can’t pull the data without your intervention so you need to manually update your sheet.
Each institution has different auth requirements and Auto Refresh statuses that change. One month Auto Update might be enabled, the next it’s not, and then the next it’s re-enabled. The landscape is constantly changing and we’re seeing more and more institutions moving from “Credentials” auth type, which is just username and password and much less secure, to “MFA Credentials” - this is likely the case with Capital One and the change in behavior we’ve seen over the last several months, though I don’t have the historical statuses to prove that.
It’s all compounded by our specific implementation of the API to move data from Yodlee (who grabs it from your bank) into a spreadsheet. That’s why the experience for Personal Capital can be vastly different than the experience with Tiller. Personal Capital has probably 20+ engineers dedicated to this type of work. We have roughly 3.
Anyway, the improvements we hope to make are focused on improving/stabilizing the integration, helping customers understand the auth and refresh requirements expected by the bank, making the re-auth experience more seamless/quicker, and clearing up confusion about our own “Auto Update” feature in Tiller Money Feeds.
Hopefully that helps paint the picture a little more clearly that we’re trying to work with at an industry level.
Thanks for being a loyal and engaged customer and let me know if you have other questions.