Create SEO content brief from keyword to Google Doc
Who’s it for ------------ Content/SEO teams who want a fast, consistent, research-driven brief for a copywriters from a single keyword—without manual review and analysis of the SERP (Google results). How it works / What it does --------------------------- Form Trigger collects the keyword/topic and redirects to Google Drive Folder after the final node. FireCrawl Search & Scrape pulls the top 5 pages for the chosen keyword. AI Agent (with Think + OpenAI Chat Model) analyzes sources and generates an original Markdown brief. Markdown to JSON converts the Markdown into Google Docs batchUpdate requests (H1/H2/H3, lists, links, spacing). Then this is used in Update a document for updating the empty doc. Create a document + Update a document write a Google Doc titled “SEO Brief for ” and update the Google Doc in your target Drive folder. How to set up ------------- Add credentials: Firecrawl (Authorization header), OpenAI (Chat), Google Docs OAuth2. Replace placeholders: {{APIKEY}}, {{googledrivefolderid}}, {{googledrivefolderurl}}. Publish and open the Form URL to test. Requirements ------------ Firecrawl API key • OpenAI API key • Google account with access to the target Drive folder. Resources --------- Google OAuth2 Credentials Setup - https://docs.n8n.io/integrations/builtin/credentials/google/oauth-generic/ Firecrawl API key - https://take.ms/lGcUp OpenAI API key - https://docs.n8n.io/integrations/builtin/credentials/openai/
By Simeon PenevDaily 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 Jennings