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.

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.

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

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.

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.

You can read more about the differences between Direct Fills and Sidebar Fills in the guide here.

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.

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

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.

Read more here.

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:

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

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.

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.

If you're seeing this message in your activity logs it means that the fill is not working for your sheet due to a duplicate transaction being detected in the sheet. We hope to make improvements to Direct Fills to adjust this behavior, but for the time being follow these steps:

If you'd like to review the duplicates before running this tool you can use this conditional formatting rule to highlight duplicate rows.

You can add conditional formatting rules from the Format menu at the top of your Google Sheet.

Apply to range A1:V (or whatever the last column letter is in your Transactions sheet)

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

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.

Filter by condition issues

Filtering on the Date column using Filter by Condition and great than or equal to (screenshot below) is not currently supported. Clear the filter and the fill will resume.

Only header row exists

If your Transactions sheet only has one row, the header row with the column keywords (Date, Description, etc) the fill will fail with a Google Sheets API error in the activity logs.

Add a second row to your sheet and it should resume filling. Note that if you insert rows with only the header row most likely the rows will adopt the formatting of the header row so you may need to clean up the formatting (background color etc) before the next fill.

Activity Log message: Tiller can't access this spreadsheet. Try reconnecting Google Sheets — if that doesn't help, check your access to the file in Google Drive.

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 or was granted by one of your other Google accounts that does not have access to the Google Sheet.

You may 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.

If you don't see the "Google Sheets Authentication" banner, follow these steps:

OR

Share the sheet with edit access with the Google Account associated with your Tiller subscription, which is likely the account used for the Google Sheets access.