Make.com Automation Specialist — WordPress Content Pipeline + 24 Calculators (Full Spec Provided)

### Overview I need a Make.com specialist to build a fully automated content pipeline and 24 interactive calculators for two WordPress websites hosted on Hostinger. A complete 1,700-line implementation specification document is provided — you will not need to make any design or strategic decisions. Build exactly what is specified. Both sites are live. No theme changes, no design work, no SEO audits required. --- ### What you will build **4 Make.com scenarios:** 1. Weekly keyword scheduler (Google Sheets → triggers both article pipelines) 2. FurryTalez article pipeline — keyword → GPT-4o article → internal links → DALL-E image → WordPress auto-publish → Buffer social (Facebook + Instagram + Pinterest) 3. WeightLossTeachers article pipeline — same flow, saves as WordPress draft + owner email notification + social posts trigger automatically on manual publish via WP Webhooks 4. Search Console feedback loop — weekly GSC data pull → GPT identifies content gaps → auto-adds keywords to queue → sends owner 5-line summary email **24 interactive calculators (12 per site — self-contained HTML + JavaScript, no plugins):** FurryTalez (4 suites): - Nutrition Suite: Dog Food Portion Calculator, Cat Food Portion Calculator, Pet Calorie Calculator - Ownership Suite: Pet Ownership Cost Calculator, Puppy First Year Cost Calculator, Pet Adoption Readiness Score (quiz) - Health Suite: Dog Vaccination Schedule Tracker, Deworming Schedule Tracker, Pet Healthy Weight Checker - Engagement Suite: Dog Age in Human Years, Cat Age in Human Years, Dog Breed Selector Quiz WeightLossTeachers (4 suites): - Metabolic Health Suite: Metabolic Health Risk Scorer, BMI and Ideal Weight Calculator, Weight Loss Timeline Calculator, Body Fat Percentage Estimator - Fasting Suite: IF Protocol Selector, Fasting Window Calculator, Calorie Deficit Estimator - Keto Suite: Keto Macro Calculator (Indian foods), Carb Limit and Food Swapper, Protein Requirement Calculator - Clinical Conversion Suite: GLP-1 Eligibility Checker, PCOS and Diabetes Weight Risk Calculator **Email lead magnet system (both sites):** - FurryTalez: 5 Brevo sequences + 4 PDFs (no owner review required) - WeightLossTeachers: 3 Brevo sequences + 3 PDFs (one-time pre-launch owner review, 20–30 min) - All 7 PDFs created by freelancer in Canva using AI-generated content **Static pages:** - 2 calculator hub pages (/pet-tools/ and /tools/) with grid of all 12 calculators per site - 6 cornerstone authority pages (3 per site — /dogs/, /cats/, /pet-care/ and /glp1/, /intermittent-fasting/, /keto/) **Tracking and integrations:** - Google Analytics 4 installed on both sites with calculator engagement events - Affiliate click tracking: ThirstyAffiliates → GA4 → Google Sheets weekly pull - WP Webhooks plugin configured on WeightLossTeachers - RankMath SEO + ThirstyAffiliates configured on both sites - Google Search Console connected to Make.com via OAuth - Brevo API + Buffer API connected --- ### What is provided to you Complete 1,700-line implementation specification document covering: - Every Make.com module in exact order with full GPT prompts written out - All 24 calculator input fields, formulas, output logic, routing, affiliate CTAs, and Brevo tags - All 7 PDF content briefs - All email sequence structures (3 emails per sequence) - WLT content compliance rules (no brand drug names — full details in spec) - Keyword starter lists (50 per site, categorised and sequenced) - Google Sheets structure with column definitions - ThirstyAffiliates keyword lists for both sites - Buffer post copy templates and scheduling times - GA4 tracking code snippets - Testing protocol checklist (21 items — all must pass before final payment) - Monthly running cost breakdown Document provided immediately after contract accepted. --- ### Tools and platforms - Make.com Core plan - OpenAI API — GPT-4o + DALL-E 3 (client provides API key) - WordPress REST API + Application Passwords (both sites on Hostinger) - Google Sheets + Google Search Console API (OAuth) - Google Analytics 4 - Brevo API (email automation) - Buffer API (social scheduling) - Canva (free tier — PDF creation) - WP Webhooks plugin (free, WordPress.org) - ThirstyAffiliates plugin (free, WordPress.org) - RankMath SEO plugin (free, WordPress.org) --- ### Article output - FurryTalez: 3 articles/week, auto-published - WeightLossTeachers: 2 articles/week, saved as drafts for owner review Bylines: "FurryTalez Editorial Team" and "WeightLossTeachers Editorial Team" — no fictional named personas. --- ### Deliverables checklist 1. All 4 Make.com scenarios live and tested 2. All 24 calculators live at correct WordPress URLs 3. Mobile responsive on all 24 calculators (test at 375px) 4. All Brevo sequences active with PDF delivery working 5. Google Sheets keyword queues pre-populated (50 keywords per site) 6. ThirstyAffiliates, WP Webhooks, RankMath configured on both sites 7. Buffer connected — 3 channels per site 8. /pet-tools hub page live (FurryTalez, all 12 calculator links) 9. /tools hub page live (WeightLossTeachers, all 12 calculator links) 10. All 6 cornerstone pages live at correct URLs with internal links 11. GA4 installed on both sites with pageview tracking active 12. Affiliate click event tracking (ThirstyAffiliates → GA4 → Sheets) 13. Calculator engagement events firing in GA4 14. Screen recording walkthrough (5–10 min) showing key flows 15. Handover note with all credentials, API keys, and settings used --- ### Payment structure — 3 milestones **Milestone 1 (30%) — paid on contract start:** Build one working calculator + one working Make.com scenario (your choice). Released when: Calculator correct with 3 test inputs AND scenario runs end-to-end. **Milestone 2 (40%):** All deliverables complete. All 21 testing checklist items confirmed. Released when: Owner confirms full testing checklist passes. **Milestone 3 (30%):** 30-day post-delivery support complete, no outstanding issues. --- ### Post-delivery support (included in price) 30 days post-delivery at no extra cost. Covers: Make.com scenario failures, API connection issues, calculator errors, Brevo delivery failures — any issue from the delivered work. Excludes: New features, issues from owner changing theme/plugins, third-party platform outages. Response: 24 hours. Resolution: 72 hours for critical, 5 working days for minor. --- ### Interview process Shortlisted candidates will be asked to: 1. Share a screenshot of a Make.com scenario they have built 2. Confirm experience with WordPress REST API --- ### Required skills - Make.com — essential, multi-step scenarios with webhooks and iterators - WordPress REST API — essential - OpenAI API (GPT-4o + DALL-E 3) — essential - Google Sheets + Google APIs — essential - Brevo API — preferred - Buffer API — preferred - HTML + JavaScript — essential (for 24 calculators) - Canva — basic (PDF creation) --- ### How to apply Answer these 4 questions: 1. Describe a Make.com scenario you have built — what did it do, which APIs? 2. WordPress REST API experience — Yes/No, brief description 3. Have you built HTML/JS calculators in WordPress before — Yes/No 4. Estimated timeline from contract start to delivery **Mandatory screening question:** To confirm you read this description, include in your proposal: "In Scenario 4, what metric from Google Search Console triggers a keyword being added to the queue?" Answer is in this job description. Proposals without this answer will not be considered. **Do not apply if:** - You have not used Make.com (Zapier experience is not sufficient) - You plan to subcontract - You cannot start within 3 days of contract award