This template loads sports odds from The Odds API into Airtable and Google Sheets. A schedule runs twice daily.
JavaScript calls The Odds API with a key stored in that node: morning runs write upcoming events and odds; evening runs write scores onto the same records. Airtable is the upsert hub; Google Sheets holds the spreadsheet view.
Latenode bills workflow runtime in CPU seconds. The first 10,000 CPU seconds are free each month, then usage follows pay-as-you-go CPU-second pricing. Plug-and-Play (PnP) AI nodes are billed separately—each PnP token is $1 USD, charged pay-as-you-go at vendor cost plus a small processing fee, with no API keys required.
Full pricing — how CPU seconds work →Workflow preview
A schedule fires in the morning and again in the evening. JavaScript branches on time of day.
JavaScript requests upcoming events in the morning and scores in the evening. Put The Odds API key in that JavaScript node.
Airtable writes event id, teams, odds, and score, creating or updating by event id.
Google Sheets gets new event rows in the morning, and updated score cells when evening results arrive.
Create a key at The Odds API. Put it in the JavaScript node or in Latenode secrets that node can read.
Add an Airtable connection. Use a table with a stable event-id field plus teams, odds, and result columns.
Add a Google Sheets connection and a worksheet with matching columns.
Add a schedule, for example 07:00 and 23:00 in your timezone. In JavaScript, fetch odds in the morning and scores in the evening. Then upsert Airtable and refresh Google Sheets.
FAQ
More templates
This template runs on a schedule, opens each URL in a headless browser, and compares visible text to the last snapshot in Latenode Database. When the change crosses your threshold, JavaScript builds RSS XML and Google Drive saves the feed file. Connect Google Drive. Keep snapshots in Latenode Database keyed by URL.
This template receives Cognito Forms submissions on a Latenode webhook, maps the payload, then creates or updates the contact in ActiveCampaign and applies a tag. Paste the webhook URL into Cognito Forms. Connect ActiveCampaign and put the API URL and key on that connection. Map email so matches update the same person.
This template watches a Discord channel for new messages, translates the text with Google Cloud Translate, and posts the translation back to Discord. Connect a Discord bot and Google Cloud Translate. Put the Translate API key on the Google Cloud Translate connection. Point the trigger at the channel you want to translate and pick the target language.
