Patrick Jennings
Accountant/CPA guy that's nice with a little no-code. Serving up templates in all kinds of fields for the n8n community.
Templates by Patrick Jennings
Daily sync of NFL players from Sleeper API to Airtable for fantasy football
Sleeper NFL Players Sync This template uses the Sleeper API to fetch the complete list of NFL players and stores them in an Airtable base. It’s built to run daily and ensures you have the most up-to-date player list for fantasy football workflows --- What it Does Maintain a current player list for fantasy league automations for Sleeper app users / NFL fantasy football managers Pull Sleeper player IDs once daily instead of every request Build smarter workflows using Airtable as your structured dataset Create a subworkflow in n8n for even more Sleeper app workflows --- Setup Instructions Install n8n (Cloud or self-hosted) Import the template JSON Create Airtable Credentials: Generate an API key at airtable.com/account Connect your base and table (you’ll be prompted to do this in n8n) If you would like to customize how you store data please feel free to use what works best for you Match your fields with the data you're storing: player_id (text/number) full_name position team etc. Activate your workflow Remember, you can customize how you trigger this workflow and where you store the data if you choose to do so. --- Notes Sleeper's player API returns 6,000+ entries, including inactive players, retired players, etc. You can filter this down as needed via position, status, or metadata. Airtable record limit on the free tier is 1,000 rows per base — consider upgrading or filtering further. Be careful of rate limits: both Sleeper and Airtable have them (but this workflow stays well within safe boundaries). The Airtable node can be replaced with other data storage nodes (Google Sheets, Excel, etc) if you prefer --- Difficulty Rating & Comment (from the author) 2 out of 10 if this ain't you're first rodeo, respectfully. If you use Sleeper for fantasy football, lets go win some games! ---
By Patrick JenningsView fantasy football roster details with Sleeper API and Telegram chatbot
Sleeper NFL Team Chatbot Starter A Telegram chatbot built to look up your fantasy football team in the Sleeper app and return your roster details, player names, positions, and team info. This starter workflow is perfect for users who want a simple, conversational way to view their Sleeper team in-season or pre-draft. --- What It Does When a user types their Sleeper username into Telegram, this workflow: Extracts the username from Telegram Pulls their Sleeper User ID Retrieves their Leagues and selects the first one (by default) Pulls the full league Rosters Finds the matching roster owned by that user Uses player_ids to look up full player info from a connected database (e.g. Airtable or Google Sheets) Returns a clean list of player names, positions, and teams via Telegram --- Requirements To get this running, you’ll need: A Telegram bot (set up through BotFather) A Sleeper Fantasy Football account A synced player database that matches player_id to full player details (we recommend using the companion template: Sleeper NFL Players Daily Sync) --- Setup Instructions Import the workflow into your n8n instance Add the required credentials: Telegram (API Key from BotFather) Airtable (or replace with another database method like Google Sheets or HTTP request to a hosted JSON file) Trigger the workflow by sending your exact Sleeper username to the bot Your full team roster will return as a formatted message > If the user is in multiple Sleeper leagues, the current logic returns the first league found. --- Example Output You have 19 players on your roster: Cam Akers (RB - NO), Jared Goff (QB - DET), ... --- Customization Notes Replace Telegram Trigger with any other input method (webhook, form input, etc.) Replace Airtable node with Google Sheets, SQL DB, or even a local file if preferred You can hardcode a Sleeper username if you're using this for a single user --- Related Templates Sleeper NFL Players Daily Sync (syncs player_id to player name, position, team) -Create Player Sync first then either integrate it to this template or reate a subworkflow from it & use most recent data set. --- Difficulty Rating & Comment (from the author) 3 out of 10 if this ain't you're first rodeo, respectfully. Just a little bit more work on adding the Players Sync as your data table & knowing how to GET from Sleeper. If you use Sleeper for fantasy football, lets go win some games! ---
By Patrick JenningsRetrieve & share NFL Fantasy Football draft results from Sleeper to Telegram
Sleeper NFL Draft Results to Telegram Easily retrieve and send your Sleeper fantasy football draft picks to Telegram with this plug-and-play n8n workflow template. --- What This Workflow Does This workflow allows you to: Accept a /team {username} command via Telegram Use the Sleeper API to: Get the user’s ID from their username Find the most recent NFL draft associated with that user Fetch all the picks made in that draft Filter only the picks made by that user Format the data into a readable message Send back a Telegram message with full pick results including: Round, draft slot, overall pick Player name, position, and team --- Requirements Sleeper Fantasy Football account with at least one completed draft Telegram Bot created via BotFather n8n instance with: Telegram Trigger credentials set up Access to external HTTP requests (Sleeper API) --- Setup Instructions Import the Template into your n8n instance. Add Telegram Credentials: Go to Credentials > Telegram API Add your bot token Replace REPLACEWITHYOURTELEGRAMAPICREDENTIAL in the workflow Customize: Optional: Modify the /team command trigger Optional: Adjust formatting of the Telegram message --- Example Telegram Response Your draft results From 2024 Your City Here (dynastyppr) season! Here are your picks: • Round 1, Pick 4: (4 overall) Christian McCaffrey (RB - SF) • Round 2, Pick 21: (21 overall) Garrett Wilson (WR - NYJ) • Round 3, Pick 28: (28 overall) Travis Etienne (RB - JAX) --- Notes This workflow defaults to the first Sleeper league/draft returned — you can enhance logic to let users select from multiple leagues. Draft year is hardcoded to 2024. Update for future seasons as needed. Does not require Airtable or Google Sheets. ---
By Patrick Jennings