Portfolio
Featured Work
Keyword Milestone Discord Notifier
Runs on a schedule, pulls live keyword rankings from Keyword.com, syncs position data to a Google Sheet (updating existing rows or inserting new ones), detects ranking milestones, and posts a summary alert to Discord.
n8n Workflow Cost Auditor
Manually triggered, it inspects a target n8n workflow (including nested subworkflows) to catalog all AI and non-AI nodes, fetches current model pricing, calculates estimated API costs, and exports a structured JSON cost report.
Annual SEO Report Builder
Triggered via an n8n form, it reads client CSV data, sends it to the Anthropic API to generate a full SEO report, converts the output to a DOCX via CloudConvert, uploads it to Google Drive, and emails the AM a review link.
AI Schema Markup Generator
Webhook-triggered by a Google Apps Script menu, it scrapes page HTML for queued URLs, sends the content to Claude AI to generate JSON-LD schema markup, creates a Google Doc per page with the result, and updates the Schema Queue sheet status to "Awaiting Review."
AI Meta Title & Description Generator
Form-triggered workflow that reads a client's page URLs from Google Sheets, fetches the top 2 GSC queries per page, scrapes the page HTML, and uses GPT-4o to generate SEO-optimized meta titles and descriptions written back to the sheet.
Tech Main Task Completion Cleaner
Mirrors the above but fires from the Tech Main board side — when a Tech Main item is marked "Completed," it reads its formula_1 link column to find the originating client board item and deletes both records.
Client Board Task Completion Cleaner
Listens for "Completed" status changes on client Monday.com boards, searches the Tech Main board for a matching linked item using the formula URL column, then deletes both the Tech Main duplicate and the original client task.
Monthly GA4 & GSC KPI Extractor
Runs on a monthly schedule, loops through all active clients in a config sheet, and pulls full-month GA4 metrics (sessions, conversions, landing pages) plus GSC data per client, appending each to dedicated tabs in the KPI Google Sheet.
Weekly GA4 & GSC KPI Extractor
Fires every Tuesday at 12:01 AM Pacific, reads active clients from the Client Config tab, fetches the prior week's organic GA4 metrics and GSC performance per client, and appends the results to the GA4 Data and GSC Data tabs in the KPI sheet.
Client Anniversary Discord Notifier
Receives a webhook POST containing client milestone data (name, onboarding date, AM, plan) and immediately sends a formatted @here celebration message to a Discord channel. The trigger is handled by the Apps Script code installed on the main sheet.
1 out of 6: TSFS Website
Core tasks involved: Content optimization, GBP optimization, link building, competitive analysis, blog posts creation/publishing, & technical SEO optimization.
2 out of 6: AIS Website
Core tasks involved: Internal linking, content optimization, GBP optimization, link building, blog posts publishing
3 out of 6: MS Ltd Website
Core tasks involved: GBP optimization, link building, blog posts, SEO report.
4 out of 6: PC Ltd Website
Core tasks involved: Keyword research, LLMs, service pages content creation & optimization, blog posts.
5 out of 6: Fastech Ltd Website
Core tasks involved: Content creation & optimization, LLMs/Ais, GBP optimization, link building, competitive analysis, blog posts, on-page/technical optimization.
6 out of 6: SRL Ltd Website
Core tasks involved: Content optimization, GBP optimization, competitive analysis, blog posts, SEO reports, technical optimization.