Send Open Holidays data to Google Sheets
Load Open Holidays calendars into your data warehouse first, join them to orders and traffic by date, then send the answers to Google Sheets on a schedule. The sheet stays tied to your source of truth, not to a calendar you copied.
Open HolidaysConnectedPublic Holidays
Google SheetsDateIdNameDaily 09:00The holiday calendar in Google Sheets was copied once, and the team plans next quarter from last year's dates.
Paste this into your AI assistant. It loads Open Holidays into your data warehouse, joins the dates to orders and traffic, and sends the result to Google Sheets on a schedule.
The prompt
Read https://www.owox.com/ai-agent-setup.md and follow it to set up OWOX Data Marts for me, starting from /connectors/open-holidays-connector-to-google-sheets.md. The task: send a Google Sheets tab every Monday with upcoming public holidays from Open Holidays for our countries, next to daily orders and traffic, so we can see how past holidays changed demand. Tag the links you give me with utm_campaign=ai-task and utm_term=data-foundation. Use what you know about my context and goals
Open Holidays Endpoints
1 Open Holidays endpoints you can import. Each lands in its own table in your data warehouse.
Why Open Holidays does not go straight to Google Sheets
A holiday list beside a sales sheet needs someone to check the dates by eye. It does not say whether a dip was demand or a closed shop, because orders, traffic and the calendar live in different places. A sheet is not built to join them reliably, at scale or business-ready, so the join happens in a warehouse first.
- Open Holidays reports the calendar, not its effect on sales
- The data analyst joins holidays to orders and traffic by date and controls the result
- Stakeholders keep the sheet they like, now with the calendar built in
Open HolidaysHoliday calendarGoogle Sheets
Data warehouseJoined by idStep 1: Load Open Holidays into your data warehouse first
Create a Data Mart with Open Holidays as the source and choose where the data lands. It works with any popular data warehouse.
- One endpoint, Public Holidays, with seven fields, in one table
- Pick a country ISO code and a language for holiday names
- Open the Open Holidays connector for your data warehouse below
Open Holida…Data MartGoogle BigQuery
AWS Athena
Snowflake
AWS Redshift
Databricksopen_holidays.public_holidaysStep 2: Link Open Holidays to orders and traffic
In your data warehouse the model joins the holiday calendar to sessions and store traffic by date and country code. Pick an industry to see the shape of its model.
- In the Retail model, Open Holidays fills the is_holiday flag on Store Traffic
- Orders and sessions join by SQL keys, not by eye
- The measures, such as conversion_rate, are defined once
Open HolidaysPublic HolidaysStep 3: Send Open Holidays data to Google Sheets
Connect a Sheets report to the Data Mart. Aliases and field descriptions arrive as notes in the column headers, so everyone reads the same definitions.
- The sheet reads your data warehouse, not the Open Holidays API
- Hover a header to see what nationwide means
Google SheetsNotes in headersdatenamenationwideStep 4: Refresh your Open Holidays sheet on a schedule
Set a scheduled refresh once. Daily is the usual choice and hourly is possible when you need it.
- Every refresh is logged in Run History
- The calendar changes rarely, so a daily refresh is more than enough
Google SheetsUpdatedStep 5: Reuse Open Holidays inside OWOX MCP
The same Data Mart works in OWOX MCP, your assistant for data. Request any report, chat with your data, then get the report in Google Sheets or Excel in one click.
- Ask in plain words; the answer comes from your data warehouse
- Define the numbers once and every report reads them
Google SheetsOpen
ExcelOpen
- 0.41.0Reuse one Google Sheets or Google Chat key across Destinations
- 0.40.0Warnings when a Count reads a joined Data Mart
- 0.40.0Open the Google Sheet a scheduled report fills, right from Triggers
- 0.39.0Reload a year of history in one backfill, not twelve
- 0.38.0Google Sheets errors in Run History explain the cause and the fix
Why OWOX for Open Holidays in Google Sheets
Hand-built API scripts and add-ons that pull straight from Open Holidays get numbers into a sheet. OWOX also keeps the data yours, linked and ready to model.
- You own the data. It lands in your own data warehouse, in tables you control.
- The calendar next to the numbers. Holiday days are flagged beside orders and traffic, so a dip is read against the calendar.
- Nationwide or regional. The nationwide and regional scope fields separate holidays that apply everywhere from local ones.
- Sheets stay in sync. Notes in the headers, a schedule you set once, no export to redo in the sheet.
- Maintained for you. No scripts to repair when Open Holidays changes how it serves data.
You are booked. The invitation is on its way to , with the calendar invite and the meeting link.