Today, we're launching Advanced Scheduling for our Castodia Database Connector for Google Sheets. This feature significantly improves scheduling flexibility for our users, allowing them to create nearly any kind of auto-refresh schedule. Some of the new scheduling use cases enabled with this launch are monthly, quarterly, and year-end reports that refresh at specific times of the day.
With this new update, we are also pushing the limits on auto-refresh frequency - customers can now auto-refresh their Google Sheets every 1 minute. This is particularly useful for customers with high volume databases that update with new data very often. Customers who optimize ad-spend down to the minute level can now pull their data into Google Sheets for more timely analysis.
This update, combined with our UI redesign, makes Castodia the most user-friendly, advanced, and powerful auto-refresh scheduler for Google Sheets - with all the features accessible within the add-on (there's no need to access different interfaces for saving queries/reports and scheduling).
Customers can set queries and target sheets to auto-refresh data on. Schedules can repeat every minute, of every day, as shown in the screenshot below. They can also specify the time range at which the auto-refreshes will run at and how the data will be auto-refreshed on Google Sheets (Append and Overwrite).
Weekly auto-refreshes allows customers to select the days of the week to auto-refresh their Sheets. It could be for example weekdays only or weekends only. Like with daily schedules, customers can specify the time range and frequency to run auto-refreshes.
Alternatively, users can select specific days of the month, for example every 1st of the each month to run auto refreshes. This is particularly useful for analysts building monthly reports.
Advanced Scheduling now makes possible to run auto-refreshes for quarterly or yearly reports that are particularly useful for marketing and finance teams. The example below shows how to build a schedule that updates yearly on various months of the year and on various days of those months, with a 1 minute auto-refresh frequency.