Joel Gamble
I streamline complex operations into clean, efficient workflows, using n8n to build practical automations that help teams work smarter.
Templates by Joel Gamble
Aggregate news articles from NewsAPI, Mediastack & CurrentsAPI into database
This workflow pulls news articles from NewsAPI, Mediastack, and CurrentsAPI on a scheduled basis. Each provider’s results are normalized into a consistent schema, then written into your database (NocoDB by default). Use case: automated aggregation of categorized news for content pipelines, research agents, or editorial queues. What You Must Update Before Running API Keys Replace all placeholder keys: call newsapi.org - Top Headlines → update API_KEY in URL call newsapi.org - categories → update API_KEY call mediastack → update "ACCESS_KEY" in JSON call currentsapi → update "API_KEY" param Database Connection Workflow uses NocoDB to store results. You must: Update the NocoDB API Token credential to your own Ensure your table includes the fields used in the create operations (sourcecategory, title, summary, author, sources, content, images, publisherdate, etc.) If you prefer Google Sheets, Airtable, or another DB: Replace each NocoDB node with your equivalent “create row” operation The Set nodes already provide all normalized fields you need Scheduling All schedulers are disabled by default. Enable the following so the workflow runs automatically: NewsAPI – Top Headlines NewsAPI – Categories Mediastack CurrentsAPI You may change the run times, but all four must be scheduled for the workflow to function as designed. What You Can Configure Categories Defined in: newsapi.org categories mediastack categories Edit these arrays to pull only the categories you care about or to match your API plan limits. Article Limits Adjust article_limit in: newsapi.org categories mediastack categories currentsapi config
By Joel GambleAI-powered cover letter generator with resume matching & Google Docs
This workflow generates a tailored cover letter using a provided resume and job description. Users submit a job description via form (or workflow input), the workflow uses an LLM to write a professional, casual cover letter, then creates and populates a Google Doc and redirects the user to download or review it. --- What You Must Update Before Running Resume Content Update the Configuration node to include your own resume text. This resume is injected directly into the prompt and used as the sole source of experience and qualifications. LLM Credentials The workflow uses OpenRouter with an OpenAI-compatible model. You must: Add your own OpenRouter API credentials Optionally change the model selection if desired Google Docs Credentials This workflow creates and edits Google Docs. You must: Connect your own Google Docs OAuth credentials Update the destination folder ID if you want files saved elsewhere --- What You Can Configure Prompt Tone & Constraints Edit the Write Cover Letter agent system prompt to adjust: Tone (more formal or more casual) Length Writing style constraints Execution Method The workflow supports: Manual execution via form submission Execution as a sub-workflow via workflow inputs
By Joel Gamble