Direct Fills is our new faster, more reliable, and more automatic way to fill your bank data into Google Sheets. 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.

Check your spreadsheet's settings on the Tiller Console by clicking the spreadsheet's name in the left navigation and choosing the Action button next to the Open Sheet button in the upper right to see which Fill Service is powering your spreadsheet.

New! If you started Tiller before Feb 2026, you can now upgrade your existing sheet from Sidebar Fills to the new Direct Fills service, from the Tiller Console. Read more & get the steps here.

How it works

Using a more robust API from Google, this new onboarding experience 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 to Direct Fills Google Sheets

When new data is available to Tiller via one of these actions this triggers a fill to your Google Sheet.

An institution refreshes (either automatically or via manual refresh you perform on the Console - see info about how refreshes work),
A manual account's balance is updated on the Tiller Console,
A CSV is imported via the Tiller Console.

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.

There are also a few reasons you may see a delay in data being filled that we are working to address.

Using Tiller Money Feeds

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, adding a manual transaction or running AutoCat right in your spreadsheet instead of from the Console.

Features available for Direct Fills sheets

Since Direct Fills are the future of Tiller-powered Google Sheets, we're building new feature exclusively for Direct Fills sheets. To get access to these features you'll need to upgrade your Sidebar Fills sheets to Direct Fills.

AI Suggest

The AI Suggest feature for AutoCat is only available for Direct Fills Google Sheets. Read more about AI Suggest & AutoCat here.

Data Clean Up

The Data Clean Up tool help you remove unwanted transaction and balance history data from your Google Sheet. It's useful when you're unlinking an account and no longer want to see that account's data in your spreadsheet, and also offers a workflow for changing a connection's aggregator so you don't end up with duplicates.

Activity Logs

The Activity Log 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.

To access the Activity Log:

Visit the Tiller Console at https://my.tiller.com
Click on the name of your spreadsheet in the left side navigation
Click the Action button in the upper right
Choose Activity Log

Creating a spreadsheet

Here are the steps for creating a Direct Fills Google Sheet.

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 if you haven't already given this permission.
After the authorization step, your Foundation Template spreadsheet will be created and filled with transaction and balance data.
1. 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

This section does not apply to problems, errors, or issues with spreadsheet creation.

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: Google Sheets API error

There are several known causes for this error to show in the Activity Logs.

Vertically merged cells

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.

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 should see a "Google Sheets Authentication" banner at the top of the Tiller Console indicating that the Google Sheets spreadsheet access has been revoked with a Re-authenticate button. Click the Re-authenticate button to grant the necessary permission and fix this issue.

There is a delay filling or my fills are being skipped

As of Aug 18, 2026 our team has incrementally started rolling out changes to improve this behavior so fills no longer get skipped, but we don't have an ETA on when this will be rolled out 100%.

You may experience a delay in your data being filled into a Direct Fills spreadsheet for the following reasons and usually you'll see a message indicating "Skipped filling to prevent data corruption due to another process editing the sheet." in the Activity Log for the spreadsheet:

If you're using AI Suggest and have it set to Auto Run on Fill you may see delays in your data filling. Since AI Suggest processes the data using AI before the data is filled into the spreadsheet, you may see a delay in your data getting filled as AutoCat is running behind the scenes to categorize your data before another fill can start.
You have many accounts connected and you use the Refresh Accounts option. Only one fill can be processed at a time, so if you have many accounts that refresh all at once or in quick succession this can cause a very short delay in data getting filled while one fill is in process, which is compounded by the AI Suggest running on Fill behavior noted above.

Until we can roll out the changes that address this fully, to prevent delays and skipped fills:

Turn off Auto Run on Fill for AutoCat if it's turned on and run AutoCat manually after the fill succeeds
Refresh your financial connections one at a time rather than using Refresh Accounts