Direct Fills is our new faster, more reliable, and more automatic way to fill your bank data into Google Sheets. As of Feb 4, 2026, all newly created Google Sheets from the Tiller Console will use Direct Fills. These spreadsheets will not have a fill button in the Tiller Money Feeds sidebar.
Spreadsheets linked using the Tiller Money Feeds add-on will still use Sidebar Fills.
Check your spreadsheet's settings on the Tiller Console by clicking the spreadsheet's name and choosing Settings to see which Fill Service is powering your spreadsheet.
If you are still using a Sidebar Fills sheet there is NO requirement to create a new spreadsheet to switch to Direct Fills at this time. Sidebar Fills sheets will continue to be supported until we offer a seamless transition for you, which will NOT require you to start over in a new spreadsheet. You should only create a new Direct Fills sheet if you want to use these features before that transition path is available. Read more in the FAQ.
How it works
Using a more robust API from Google, this new onboarding experiences creates your spreadsheet for you, installing the sheets and dashboards that are found by default in the Tiller Foundation Template and filling your bank data usually in less than a minute. Subsequent fills happen automatically, without the need to click the fill button or wait for a timed fill.
How data is filled
After an institution refreshes (either automatically or via manual refresh you perform on the Console - see info about how refreshes work) the data should be automatically filled into the Direct Fills spreadsheet pretty quickly so if your spreadsheet is powered by Direct Fills you will NOT see a Fill button in the Tiller Money Feeds sidebar.
If your accounts have recently refreshed but you're not seeing your latest data in the spreadsheet, check the Activity Logs for errors. Click here to learn more.
Since only one fill can be performed at a time, there are some cases where the data for some institutions that refresh, especially in the case of manual refreshes, can take a little longer to appear in the spreadsheet.
There is no requirement to use Tiller Money Feeds at all, but there are helpful features in the add-on that you may still want to use, such as the Split Transaction tool or running AutoCat right in your spreadsheet instead of from the Console.
Spreadsheet settings
The spreadsheet settings section on the Tiller Console for Direct Fills sheets has AutoCat settings, the option to unlink the sheet, and the Fill Service details.
In some cases you may see a message indicating that the Google Sheets access is authorized with a different email address than the one used for your Tiller subscription. Sometimes this is intentional, like if you sign in to Tiller using a Microsoft account, other times it was accidental and could cause confusion about spreadsheet Google Drive ownership.
If it was unintentional, visit https://my.tiller.com/settings and click "Revoke access" for Google Sheets under the Spreadsheet Access section and then click "Grant access" to re-authorize with the correct account.
Activity Logs
The Activity Logs section for your Direct Fills sheet gives you some helpful information about when data was filled, when AutoCat completed, and if the fill ran into any errors.
Creating a spreadsheet
Here are the steps for creating a Google Sheet powered by Tiller when you have this feature enabled.
Sign in to the Tiller Console at https://my.tiller.com
Click "Create a spreadsheet"
Click "Start with Google Sheets"
You’ll first be prompted to “Authorize Sheets” and grant permission for Tiller to create and fill your spreadsheet using our Direct Fills service.
After the authorization step, your Foundation Template spreadsheet will be created and filled with transaction and balance data.
If you already have at least one spreadsheet linked, you'll be prompted to select which accounts you want to link to the sheet before the data gets filled. For brand new users, we fill all the data for all the accounts they've connected into the first spreadsheet they create.
Click the “Open My Spreadsheet” button when prompted.
Troubleshooting
I'm having trouble with the Authorize Sheets step
If you're getting stuck on the step where you're prompted to "Authorize Sheets" it may be due to your browser blocking pop ups. We are aware of this behavior in Safari, but it could be an issue in other browsers as well.
In Safari you can click the "Show blocked pop up window" button to show the authentication screen.
Fill errors or missing data
If you notice that your Transactions or Balances aren't filling into your Direct Fills spreadsheet please review the Activity Logs for the spreadsheet on the Tiller Console by clicking the spreadsheet's name and then choosing "Activity Logs" and use the error guidance below to help you decide on next steps.
Fill error: SHEETS_API_ERROR or Google Sheets API error
If you're seeing Fill error: SHEETS_API_ERROR or Google Sheets API error there is at least one known cause. If you have a group of cells in a column that are merged vertically it will cause the fill to fail with this error. Review your columns for vertically merged cells and unmerge the cells. There may be cases we have yet to identify that cause this issue so we recommend letting our team know that you're running into this error so we can investigate further and continue improving.
Fill error: Sheets auth token is missing or MISSING_AUTH_TOKEN
If you're seeing this type of error either in the Activity Logs or when you launch Tiller Money Feeds in a Direct Fills sheet, it's because the necessary spreadsheet access has been revoked. You'll need to restore the access using the steps below:
Navigate to https://my.tiller.com/settings
Scroll down to the Authentication section
Click the "Grant Access" button for Google Sheets under Spreadsheet access
The button should change to "Revoke access"
If you visit this setting and it already says "Revoke access" please reach out to our support team via Chat.
