Automate Daily Sports Event and Score Tracking with TheOddsAPI and Airtable
detail.loadingPreview
This n8n workflow fully automates the collection of daily sports event data and scores from TheOddsAPI, storing and updating records in Airtable. Scheduled triggers ensure you always have up-to-date information on upcoming games and their final results, perfect for analysis or personal tracking.
About This Workflow
This robust n8n workflow empowers you to automatically gather comprehensive sports event data and scores, centralizing it all within Airtable. Running twice daily, it first fetches upcoming events for your chosen sport (e.g., Ice Hockey NHL) in the morning. This initial data, including team names, event IDs, and start times, is then meticulously organized into new records in your Airtable base. In the evening, the workflow automatically retrieves the latest scores for the day's events. It intelligently merges these scores with your existing records, updating them with completed status and final results. This ensures your Airtable base remains a real-time, accurate repository of sports information, fully customizable for different sports, odds data, or sportsbooks.
Key Features
- Dual Daily Triggers: Automatically fetches upcoming events in the morning and updates scores in the evening, ensuring timely data.
- TheOddsAPI Integration: Seamlessly pulls detailed sports event data, including game IDs, teams, and commence times, from a leading sports data provider.
- Airtable Data Management: Efficiently creates new records for upcoming events and intelligently updates them with final scores, keeping your database current.
- Customizable Sport Selection: Easily adjust the workflow to track various sports beyond the default Ice Hockey (e.g., Football, Basketball, Soccer).
- Extensible Data Points: Modify the workflow to include additional data like specific betting odds, sportsbook information, or more intricate event details.
How To Use
- Airtable Setup: Create an Airtable Base and Table. Ensure your table includes columns for
id,away_team,home_team,sports_key,sport_title,commence_time,completed, andscoresto accurately map the incoming data. - TheOddsAPI Key: Obtain an API key from TheOddsAPI and configure it as a 'Generic Credential' in n8n for 'HTTP Header Auth'.
- Configure HTTP Requests:
- In the "Retrieve Data Of Upcoming Sport Events For The Day" node, replace the placeholder
apiKeyin the URL with your actual TheOddsAPI key. - To change the sport, modify
icehockey_nhlin the URL to your desired sport key (e.g.,americanfootball_nfl,basketball_nba). - (Optional) Refer to TheOddsAPI documentation for how to retrieve additional data like odds or sportsbooks.
- In the "Retrieve Data Of Upcoming Sport Events For The Day" node, replace the placeholder
- Airtable Node Configuration: In the "Create Records Of Upcoming Events For The Day" node (and the subsequent "Update Records" node for scores), select your Airtable Base and Table. Verify the column mappings to ensure data from TheOddsAPI correctly populates your Airtable fields.
- Adjust Schedule Triggers: Modify the "Morning Trigger" (7:00 am) and "Evening Trigger" (11:00 pm) nodes to adjust the times for data collection to your personal preference.
Apps Used
Workflow JSON
{
"id": "62c3729a-ffb3-4e77-a4a4-73256a9e6572",
"name": "Automate Daily Sports Event and Score Tracking with TheOddsAPI and Airtable",
"nodes": 17,
"category": "Operations",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 62c3729a-ffb3...
About the Author
DevOps_Master_X
Infrastructure Expert
Specializing in CI/CD pipelines, Docker, and Kubernetes automations.
Statistics
Related Workflows
Discover more workflows you might like
Google Sheets to Icypeas: Automated Bulk Domain Scanning
This workflow streamlines the process of performing bulk domain scans by integrating your Google Sheets data directly with the Icypeas platform. Automate the submission of company names from your spreadsheet to Icypeas for comprehensive domain information, saving valuable time and effort.
Instant WooCommerce Order Notifications via Telegram
When a new order is placed on your WooCommerce store, instantly receive detailed notifications directly to your Telegram chat. Stay on top of your e-commerce operations with real-time alerts, including order specifics and a direct link to view the order.
On-Demand Microsoft SQL Query Execution
This workflow allows you to manually trigger and execute any SQL query against your Microsoft SQL Server database. Perfect for ad-hoc data lookups, administrative tasks, or quick tests, giving you direct control over your database operations.