Web Developer Projects

AI Engineer / NLP Engineer for an AI BF/GF Product

We are launching a product in the AI romantic companions / AI BF/GF niche and need a specialist to take over the AI development part. The website, registration, design, menu and payment system are handled separately. This role focuses only on the AI core: dialogue models, AI characters, memory, user adaptation, realistic image generation and MVP AI architecture. Required skills LLMs for conversational AI products. Testing and comparing open-source and commercial models. Llama / Hugging Face / vLLM / Text Generation Inference. System prompts for AI characters. Prompt engineering, fine-tuning and LoRA. Memory layer design: mem0, Qdrant, embeddings, RAG. Python, Docker, PostgreSQL, Redis. GPU infrastructure and model deployment. AI image generation: FLUX.1 / Stable Diffusion / ComfyUI. Consistent face setup for AI characters. Moderation / safety filters for AI dialogues. Tasks Select and test LLMs for romantic AI dialogues, set up AI characters, design user memory, plan adaptation to the user’s communication style, and suggest a pipeline for realistic AI selfies. Experience with AI companions, dating, chatbots, virtual characters, roleplay scenarios or conversational AI is a plus. The candidate should be ready to complete a short test task. Please include your stack, relevant experience, project examples, readiness to complete the test task and your rate / estimated project cost.

Create Packshot Images from Lifestyle Photography (Ecommerce)

I am looking for a designer / retoucher to create clean, premium ecommerce packshots from my existing lifestyle photography (approx 40 in total). My brand is Loome Lifestyle, elevated, slow living, artisan aesthetic with a natural, premium feel. I already have lifestyle imagery live on my website and would like these converted into consistent product packshots suitable for ecommerce listings. Scope of work; Use existing lifestyle product images supplied by me Extract product cleanly from the existing background Replace background with a plain background (white and/or soft neutral depending on product) Preserve true product colour and texture (particularly important for organic cotton fabrics) Retouch lightly only - do not over smooth, distort or alter the product Ensure edges are clean and professional (especially robes, tassels, textiles and soft fabric edges) Remove distracting creases/background shadows where appropriate whilst keeping products natural Maintain consistent scale, positioning and spacing across all images Export web-ready files Products include: Organic cotton robes Towels Bags and accessories Slippers Deliverables: High-resolution PNG (transparent background) JPEG on pure white background (#FFFFFF) Square format for Shopify Consistent cropping across collection Editable source files preferred Style references Please aim for: Premium ecommerce finish Natural fabric texture retained Clean and minimal Similar standard to premium lifestyle brands rather than heavily retouched fashion imagery Please include in your proposal Examples of previous packshot retouching work Whether extraction is done manually or AI-assisted Cost per image and volume discounts Estimated turnaround time Whether one test image can be completed first Please quote both: Cost per image Cost for full batch

TikTok Video Editor – 150 Short-Form Videos (Bulk/AI Workflow)

TikTok Video Workflow Specialist – 150 Short-Form Videos (Bulk/AI Workflow + 1 Month Account Setup) Job Description: We are an independent small agile AI travel platform launching a global consumer-advocacy campaign to expose predatory rental car damage scams. We have fully developed the scripts, raw materials, and core messaging. We are looking for a system-driven Video Editor & Account Manager with deep experience in bulk-creation tools (CapCut Pro, Canva, HeyGen or specialized AI video infrastructure) to produce our core 150-video asset vault and establish our initial channel presence. This is not a traditional "frame-by-frame" creative editing job. We are optimization-focused; we want to leverage smart workflows, clean master templates, and automated assets to generate a high-volume batch efficiently without sacrificing a clean, high-impact aesthetic. Key Deliverables: 1. The 150-Video Vault (Fixed Price Component A): Edit and export 150 short-form videos based entirely on our provided scripts. 2. Customizable Master Templates: All master templates, graphics, and timeline frameworks must remain editable/transferable so I can make minor text or asset tweaks in the future, alternatively utilizing the original creator. 3. Account Management Trial (Fixed Price Component B): Basic setup and 30 days of standard feed management/scheduling for our initial launch account. Mandatory Submission Requirements: To be considered, your proposal must break down your bid into these distinct lines: • Quote 1: Fixed-price for the complete production of the 150-video vault. • Quote 2: Fixed-price for basic account setup and 1 month of scheduling/management. • Workflow Detail: A 2-sentence summary of the specific batch-processing tools or AI software you plan to use to complete this efficiently. The Selection Process: We will select top candidates for a paid 1-video sample milestone. Upon approval of the template visual design, pacing, and quality, we will release the contract for the full batch of 150 videos immediately. Please ensure pricing is realistic for the project this is about saving me personal time effort and resources by not having to do it myself with the potential for extending future ongoing work to the selected creator. Sincerely

AI Video Creator (Reels, TikTok & Facebook)

AI Video Creator (Reels, TikTok & Facebook) We're looking for a talented AI Video Creator who knows how to create scroll-stopping short-form videos for Instagram Reels, TikTok, and Facebook. This is not an entry-level position. You must have real experience creating AI-generated video content and be able to show examples of your work. ## What You'll Do * Create engaging short-form videos for Instagram Reels, TikTok, and Facebook * Use AI tools such as Kling, Veo, Runway, Midjourney, ChatGPT, and similar platforms * Develop powerful hooks that grab attention in the first few seconds * Create content that feels organic and entertaining, not like traditional ads * Edit and optimize videos for social media performance * Turn ideas into high-quality content quickly and efficiently ## Requirements * Proven experience creating AI-generated videos * Strong understanding of social media content and trends * Ability to create videos that drive engagement, views, and conversions * Experience with video editing and storytelling * Ability to work independently and deliver consistently * Must be able to provide a portfolio or examples of previous work ## Bonus Points * Experience creating content for e-commerce brands * Understanding of direct-response marketing * Experience running or creating winning ad creatives * Knowledge of viral content strategies ## To Apply Please send: 1. A short introduction about yourself 2. The AI tools you use regularly 3. Links to at least 3 videos you have created 4. Any results you've achieved (views, engagement, sales, leads, etc.) We are looking for someone who can start immediately and produce content at a high level. **Important:** Applications without examples of previous AI video work will not be considered.

opportunity

Build SEO Landing Page for Accountancy Website (WordPress)

PROJECT DESCRIPTION We are an established UK accountancy practice expanding our brand My Office Accountant (myofficeaccountant.co.uk) into a national online service. We need an experienced WordPress developer/implementer to build out a structured library of SEO landing pages in three tiers: Tier 1 — Industry pages (25 pages). e.g. /accountants-for/contractors, /accountants-for/landlords, /accountants-for/ecommerce Tier 2 — Location pages (25 pages). e.g. /locations/manchester, /locations/birmingham, /locations/enfield Tier 3 — Intersection pages (approx. 15-25 pages). e.g. /accountants-for/contractors/manchester Important: we supply the content. Every page's copy, title tag, meta description, H1 and FAQ text will be provided by us in a structured content document, built from master templates we already have. Your job is implementation, not copywriting. Do not generate, spin or AI-write page content — any submission containing content we did not supply will be rejected at milestone review. Scope of work Reusable page template(s). Build one flexible landing-page template (or one per tier if cleaner) in the site's existing theme/page builder, matching our current branding — hero with dual CTA buttons, tick-list strip, content sections, FAQ accordion, CTA block, internal-links footer. Mobile-responsive, fast-loading (target 90+ mobile PageSpeed on template pages). Page build. Populate all ~30–33 pages from our content document into the templates, with correct URL slugs exactly as specified. Technical SEO per page: title tags, meta descriptions, single H1, correct heading hierarchy, FAQPage schema on FAQ blocks, breadcrumb schema on intersection pages, Service/Organization schema sitewide, canonical tags, all pages added to the XML sitemap. Internal linking exactly as mapped in our content document (industry ↔ location ↔ intersection three-way pattern), plus navigation/footer entries where specified. Site plumbing: ensure clean URL structure (no pattern mixing), 301 redirects if any existing pages are superseded, no orphan pages, submit updated sitemap in Google Search Console. Handover: a short screen-recorded walkthrough (10–15 min) showing how we add the next wave of pages ourselves using the template, plus documentation of any plugins/settings added. Milestones & payment M1 (25%): Template(s) approved on staging — one fully built sample page per tier, matching brand and passing mobile PageSpeed check. M2 (35%): All Tier 1 + Tier 2 pages built, schema validating (Google Rich Results Test), internal links in place. M3 (30%): Tier 3 pages built; full crawl check (Screaming Frog or similar) showing no broken links, duplicate titles or missing meta; sitemap submitted. M4 (10%): Handover video + documentation delivered. Requirements — please confirm each in your proposal Proven WordPress experience (or confirm ability on our platform after viewing the site) with landing-page/programmatic-SEO builds — include 2–3 live examples of multi-page SEO builds you've implemented Comfortable with schema markup and validating it Experience with Elementor / WPBakery / Gutenberg (state which — we'll confirm what the site uses) Basic Search Console familiarity (sitemap submission) UK English; UK working-hours overlap preferred but not essential You will be given limited-role site access (Editor/custom role) — not full admin — and staging access where available To apply, please answer these three questions (proposals that don't will be skipped) Link to one multi-page SEO/landing-page system you built: what was your role, and how many pages? How would you implement FAQPage schema on a repeatable template so non-developers can add pages later? What's your realistic timeline for M1 and M2, and your total fixed price? What we provide Full content document (all copy, metadata, slugs, FAQ text, link map) Brand assets (logo, colours, fonts) and access to the existing site One point of contact with fast turnaround on approvals (24–48h) What this is NOT Not a redesign of the whole site (template must fit existing branding) Not a copywriting job Not ongoing SEO/link-building (may be discussed separately after delivery)

opportunity

SEO, AI Search & Website Audit (WordPress)

# Technical SEO & AI Search Audit ## Project Overview I am looking for an experienced SEO consultant to carry out a comprehensive audit of my WordPress website. This is **not** a request for a generic automated SEO report. I want an experienced professional to identify the highest-impact opportunities to improve rankings, AI search visibility and, most importantly, qualified lead generation. The website belongs to an established UK ecommerce fulfilment company and has recently undergone a significant SEO expansion, including new commercial landing pages, industry pages and supporting content to build topical authority. Google Search Console shows rankings have generally improved over the past 12 months, but enquiries have slowed slightly. I would like an independent assessment of whether there are any technical, structural or strategic issues preventing further growth. ## Scope of Work Please review: ### Technical SEO * Crawlability & indexation * XML sitemap & robots.txt * Canonicals & redirects * Duplicate content * Broken links * URL structure * Core Web Vitals & page speed * Mobile usability * Schema * JavaScript rendering * Image optimisation * Any technical issues affecting rankings ### Website Structure * Information architecture * Internal linking * Topic clusters & silos * Navigation * Keyword cannibalisation ### Content Identify: * Thin or weak pages * Content gaps * Duplicate topics * Opportunities to consolidate or expand content I do **not** want pages rewritten - I want to know what should be improved and why. ### Competitor Analysis Compare against leading UK fulfilment companies and identify: * Keyword opportunities * Content gaps * Authority gaps * Competitive advantages we are missing ### Commercial SEO Assess how well the website targets high-intent searches such as Shopify Fulfilment, Ecommerce Fulfilment, Fashion Fulfilment, Omnichannel Fulfilment and other commercially valuable terms. ### AI Search Please assess how well the website is positioned for: * Google AI Overviews * ChatGPT Search * Perplexity * Claude * Gemini * Bing Copilot Review: * Topical authority * Entity optimisation * Semantic coverage * EEAT * Structured data * Internal linking * Brand authority * Opportunities to become a trusted AI citation ### Conversion Optimisation Review the site from a potential customer's perspective and identify opportunities to improve: * Calls to action * Trust signals * User journey * Contact forms * Commercial messaging * Overall conversion rate ## Deliverables Please provide: * Executive summary * Prioritised recommendations * Expected business impact * Estimated implementation difficulty * Quick wins Please categorise recommendations as: * High Impact / Low Effort * High Impact / High Effort * Low Impact / Low Effort * Low Impact / High Effort Finally, if this were **your own business**, what are the **five improvements** you would make first, and why? ## Important I am **not** looking for generic advice such as "write more blogs", "add keywords" or "build backlinks". Recommendations should be specific, evidence-based and prioritised according to business impact. Please do not use AI to generate your report. I am paying for your expertise, experience and judgement. ## Future Work There may be additional work available to implement the agreed recommendations following the audit. ## To Apply Please include: * Similar SEO audits you have completed * Your WordPress experience * Ecommerce/B2B SEO experience * Experience with AI Search / GEO * Tools used (Screaming Frog, Ahrefs, Semrush, GSC etc.) * Fixed price and timescale Please do not send a generic proposal. I'm looking for an experienced consultant who can provide practical, strategic recommendations that will generate more qualified enquiries.

Freelance DevOps Support Engineer (Part-Time, Remote) | EUROPE

About Us: We are building next-generation DevOps and Cloud engineers through hands-on, outcome-driven education. Our students don't just watch content — they build, deploy, break, and ship real systems. To support this mission, we're looking for an experienced DevOps / Cloud Engineer who genuinely enjoys helping others learn and grow. This is a part-time, support role — straightforward, focused, and impactful. The Role: As a DevOps / Cloud Support Engineer, your primary responsibility is to provide technical support to our students on Discord across our DevOps and DevSecOps bootcamp programs. You will combine deep technical expertise with clear, patient communication to ensure students feel supported and unblocked throughout their learning journey. This role is 100% remote, part-time, must overlap with EUROPE time zone(CEST). Key Responsibilities Student Technical Support Answer student technical questions within 2 hours on Discord across our DevOps and DevSecOps trainings Help students troubleshoot issues with tools, commands, configurations, and concepts Proactively check in on open threads to ensure students are unblocked and making progress Foster a supportive, high-trust learning environment Open, communicative, and approachable — students should feel comfortable reaching out at any time Support is primarily written via Discord, but when needed, be ready to jump on a short call with a student to solve issues in real time and unblock them faster Course Quality Feedback Flag and document course content that appears outdated, broken, or unclear Report recurring student issues to the course maintenance team for fixes and updates Contribute observations that help keep our bootcamp content aligned with current industry standards Career Development Support (occasional, on-demand) Conduct 1-on-1 career calls with students — mock interviews, career planning, and job search strategy Review and provide actionable feedback on student CVs and LinkedIn profiles Help students prepare for technical interviews Guide students on how to present their bootcamp projects and hands-on experience to hiring managers Required Skills & Experience 3+ years of professional DevOps experience Solid hands-on experience with Docker, Kubernetes, CI/CD pipelines, Terraform, AWS and Scripting Strong understanding of DevOps concepts and workflows Strong written English — clear, patient, and helpful communication style Available to cover EUROPE time zone (CEST) Comfortable working in a fast-moving, remote environment Nice to Have Prior experience with DevSecOps concepts and tools Experience mentoring, teaching, or coaching engineers Familiarity with Discord as a support and community channel Exposure to AI-driven DevOps tools and workflows Compensation & Hours Hourly contract + Base salary for availability 10-20 hours per week, flexible schedule based on student demand Competitive hourly rate for top-tier candidates Why Join Us Direct influence on engineers' careers High-autonomy and ownership in your work. Work with modern DevOps tooling and a passionate learning community Fully remote, flexible schedule Long-term collaboration potential

Seeking eCommerce Beta Testers

Beta Tester - Optagen Portal & Integrations What you’re testing The Optagen portal lets you manage multiple stores by bringing together data from your commerce, analytics, accounting, inventory, and CRM systems. It creates a single ranked action list, with each recommendation labeled for trust and checked against real results. We need beta testers to use the portal with real store data and identify what breaks, what’s slow, what’s missing, and what doesn’t match reality. Integration coverage required You will test syncing and data accuracy across these integrations: Commerce platforms: Shopify, BigCommerce, WooCommerce, Etsy Analytics: Google Analytics 4, Search Console Shipping/3PL: ShipBob, ShipStation, Easyship Inventory systems: Cin7, Katana Accounting: QuickBooks, Xero Marketing/CRM: Klaviyo You don’t need to use every integration—just test the ones you already use. We’re aiming for each tester to cover at least 3 or 4 integrations from different categories. What we’re asking 1. Sync completeness: Check if all the expected fields from each integration show up in the portal. Are SKU, pricing, margin, sales, traffic, inventory, and competitor data there? 2. Refresh latency: See how long it takes for changes in your source system (like a price update in Shopify or a GA4 event) to show up in the ranked plan. 3. Data accuracy: Choose 5 to 10 data points you can check in both your source system and Optagen. Do they match? 4. Signal read accuracy: The portal calculates metrics such as AI visibility, SKU margins, demand signals, returns concentration, pricing elasticity, and competitor share of voice. Check these against your store. Do they make sense? Can you find the data sources if you look for them? 5. Ranked plan stability: Run the same store scan twice in one week. Does the ranked plan update based on new data, or does it stay the same? Are the revenue-impact numbers realistic? What we’re not asking * Testing the governed execution agent (scheduled to ship later; currently in development) * Load testing or scale testing * Security testing or pen testing * UX/design feedback (we’ll gather that separately) Timeline and access * Beta runs from [DATE] to [DATE] * You’ll get portal access for your own stores, using your real data—not test data. * We’ll keep an eye on logs and collect diagnostics if something fails. Please report any issues as they happen via a feedback button. * We’ll have a weekly sync call to talk about any blockers or patterns you notice. Who should apply * You run 1-5 stores across 2+ of these platforms. * You can verify data accuracy (you know your actual margins, traffic, and sales numbers) * You’re willing to spend 2-4 hours per week auditing sync health and data correctness. * You’re okay with bugs and incomplete features since this is a beta test. When you apply, please indicate: * Which platforms you currently use (Shopify, BigCommerce, WooCommerce, Etsy etc.) * Rough store size (monthly revenue or annual, average order value, SKU count) * Any specific data quality concerns you have with your current setup

Small Webiste Reskin Project

Scope: exactly 7 pages + main menu. No content creation, no full-site rebuild — see details below. Project Summary: We have an existing, live company website and need it reskinned/updated with a new template — not rebuilt from scratch. This means selecting a new theme/template and applying it to 7 existing page types, plus a simplified main menu. Most of the pages already exist in some form on the current site (linked below) and simply need to be rebuilt using the new template with the content we provide. This is a template selection and build-out project, not a content creation or bespoke design project. Once those 7 Pages are in place, we should be able to roll out the rest of it across the site ourselves, no help required. What We Are Providing: All copy and content for every page — ready to insert All images required for each page Brand style guide (colors, fonts, logo files) Content structure guides showing which sections/blocks each page needs, where available (see below) What Is In Scope: - Select a website theme/template suitable for our needs (our current site runs on WordPress) - Build 7 page templates using that theme, with the content blocks/sections required for each page type (see below) — this replaces the existing versions of these pages on our live site - Populate each page with the content and images we provide - Apply a new blog post template across the existing blog via a standard WordPress theme/template change (this cascades automatically to existing posts — no per-post rebuilding required) - Set up the new main menu — simplified structure with basic dropdowns, using the theme's existing menu/drag-and-drop functionality What Is Explicitly Out of Scope: Writing or sourcing any content or copy (we provide this) Auditing, fixing, or manually rebuilding individual existing blog posts Custom coding beyond standard theme/template configuration Ongoing content population beyond the initial 7 pages Brand & Design Requirements: We have an existing brand style guide (colors, fonts, logo usage) which will be provided The selected theme must be configured to match our brand colors, fonts, and logo throughout The homepage should receive extra design attention — this is our highest-visibility page and should look polished and considered, not just a generic template fill. Some minor bespoke design work coudl be utilized here. Expect more iteration/review on this page than on the others Other pages should be clean, professional, and consistent with the brand, but do not require the same level of bespoke polish as the homepage The 7 Pages: 1. Homepage - Content structure guide pending — to follow 2. Solution/Challenge & Industry page - One template covering both page types. Reference example: Aerospace & Defence industry page (link to follow) 3. Product/Technology page - One template to cover 2 existing product pages (URLs to be shared with shortlisted candidates) 4. "Insights" content overview page - New page — covers blog articles, case studies, whitepapers 5. Blog post template - Applied via standard WordPress template change across all existing posts 6. Company/About Us pageCurrent page exists (URL to be shared with shortlisted candidates) — content structure guide to follow 7. Industry Overview page - Content document to follow (Also - Simplified Main Menu - We can build it out once it is in place) Notes: Simplified structure with basic dropdowns Uses the selected theme's existing menu builder (no custom navigation development required) Targeting completion within August. What We're Looking For in a Quote: Please provide a day-rate or fixed-price quote broken down by: Theme selection/setup Per-page template build (x7) Blog template application Menu setup (Shoudl be faily minor task as we just need it put in place) Extra time for tweaks/rework. Please also provide examples of your work. This will help us compare quotes on a like-for-like basis.

Pilot Program Agreement — Singapore EdTech

Client: U.S.-based developer of children's social-emotional learning (SEL) products Project: Beta pilot testing with Montessori schools and after-school programs in Singapore Documents to produce: 2 final, execution-ready instruments Deliverables Table # Deliverable Specification 1 Pilot Participation Agreement Singapore law governing; SIAC arbitration clause; PDPA 2012 compliance for children's data; GST treatment for non-registered supplier; IP ownership and feedback assignment; "AS-IS" beta disclaimer with liability cap; 3 pages maximum 2 Parental Consent Form PDPA 2012 compliant; clear data collection purpose and scope; controller/processor identification; voluntary participation with withdrawal right; data subject rights (access, correction, deletion); cross-border transfer disclosure (U.S. servers); 30-day retention and destruction method; contact for inquiries; parent/guardian signature block; 1 page maximum, plain language for non-lawyer parents Timeline Propose your own — include estimated drafting days and revision rounds in your response. What We Provide Product description and pilot structure (4-week, capped participants, SGD fee, remote training, automated telemetry) Data categories collected (first name/pseudonym, age bracket, session interaction logs, card linger time, aggregated behavioural telemetry) Confirmation: no photographs, full names, government ID, or medical data collected U.S. server location for digital processing Target markets: Montessori institutions and private after-school enrichment centers What We Expect From You Called to the Singapore Bar Demonstrated experience with PDPA 2012 and technology/service agreements Fixed-fee proposal or hourly rate with not-to-exceed estimate Proposed timeline from engagement to final delivery One round of revisions included in quote (additional changes billed separately or re-quoted) Selection Process Proposals accepted on rolling basis Decision based on: relevant experience, clarity of proposal, timeline fit, fee reasonableness fit and demonstrated expertise weighted heavily Submit: Fee proposal, timeline, and 2 relevant matter examples.

opportunity

Accountant Required: Insolvency & Going Concern Advisory

We are a small limited company registered in England operating in the property management and short term lettings sector. The company is currently believed to be balance sheet insolvent and we are seeking professional accounting advice on the options available to us. We have developed a restructuring plan that would allow the company to continue trading as a going concern, repaying existing debts over time without taking on any additional borrowing or increasing the total amount owed. We need a qualified accountant to review our financial position, assess the viability of this plan and advise on the most appropriate route forward. What We Need A thorough review of our current financial position including balance sheet, profit and loss, and outstanding creditor obligations Assessment of whether the company meets the legal tests for insolvency (cash flow and balance sheet) Professional opinion on whether our proposed going concern plan is viable and defensible Advice on directors' duties and obligations when trading while insolvent, including wrongful trading risk under Section 214 of the Insolvency Act 1986 Guidance on available options such as Company Voluntary Arrangement (CVA), creditor negotiations, or formal restructuring A written summary or report that we can present to creditors and use for our own records Required Qualifications & AccreditationThis is a non negotiable requirement. The accountant must hold one of the following: ACA or FCA (Associate or Fellow of the Institute of Chartered Accountants in England and Wales, ICAEW) Must hold a current ICAEW practising certificate Ideally licensed by the ICAEW as an Insolvency Practitioner or have demonstrable experience advising owner managed businesses on insolvency, restructuring and going concern matters We will verify your ICAEW membership before engagement. Accountants registered with ACCA, CIMA or other bodies only will not be considered for this role. We specifically require ICAEW accreditation. Experience We Are Looking For Advising small or micro limited companies (turnover under £200k) on insolvency and restructuring Working with owner managed or director led businesses Familiarity with creditor negotiation, CVAs and informal arrangements Understanding of the property or hospitality sector is a bonus but not essential Deliverables An initial consultation (video call or phone) to understand our situation Review of financial records we provide (Xero accounts, creditor schedule, restructuring plan) Written advice or report covering viability, risks and recommended next steps Ongoing availability for follow up questions during the restructuring process (to be agreed) Please quote your hourly rate or a fixed fee for the initial review and report. We are a small business so cost awareness is important, but we understand the value of proper professional advice and are happy to pay a fair rate for qualified expertise. Please include in your proposal: Your ICAEW membership number and practising certificate status A brief summary of your experience with insolvency or going concern advisory work Your proposed approach and estimated timeline Your fee structure (hourly or fixed) A few notes: I've kept the company name, specific figures and property details out of the posting so you're not sharing sensitive information publicly The ICAEW requirement is clearly stated as non negotiable with a note that you'll verify membership I've mentioned S214 wrongful trading and CVAs specifically so you attract people who actually know this area, not just general bookkeepers Budget is left open for them to quote rather than setting a number, which should get you a range of proposals to compare

Create automated planning application spreadsheet

I am looking for someone to create an automated spreadsheet/report that pulls the previous week’s UK planning applications from the UK PlanIt data/API. The purpose of the report is to help identify potential trade opportunities for builders, loft conversion companies, kitchen/renovation firms, roofers and other home improvement trades. I need the spreadsheet to be refreshable each week, so I can update it with the latest planning applications and then export or share the data with ChatGPT for analysis. What I need is a spreadsheet system, ideally in Google Sheets or Excel, that can: 1. Pull planning application data from UK PlanIt. 2. Refresh the report weekly to show the previous 7 days of applications. 3. Cover all UK counties / planning areas, not just one local authority. 4. Handle multiple planning authorities within each county where needed. 5. Pull clean, structured data into a spreadsheet. 6. Allow me to filter by county, planning authority, date, application type and likely trade opportunity. 7. Create summary tabs that make the data easy to review. 8. Be simple enough for a non-technical user to refresh each week. **Important functionality required:** The spreadsheet should include: * A refresh button or clear refresh process. * A date range selector, ideally defaulting to the last 7 days. * County / area filtering. * Planning authority filtering. * Keyword filtering for relevant trade opportunities. * Automatic categorisation where possible, for example: * Extensions * Loft conversions * Garage conversions * Renovations/refurbishments * Kitchens * Roofing * Outbuildings * Commercial fit-outs * Other building works * A clean export tab that can be copied into ChatGPT for analysis. * Basic error handling if the API limit is reached or if a request fails. * A simple instruction tab explaining how I refresh and use the report. **Suggested spreadsheet tabs:** 1. **Instructions** Simple user guide explaining how to refresh the data and use the spreadsheet. 2. **Settings / Control Panel** Date range, counties/areas to include, keywords, refresh controls and any API settings. 3. **Raw Planning Applications** The unedited data pulled from PlanIt. 4. **Cleaned Applications** Clean version of the data with standardised columns. 5. **Trade Categorisation** Applications categorised by likely trade relevance. 6. **County Summary** Number of opportunities by county and trade type. 7. **Planning Authority Summary** Number of opportunities by local authority. 8. **ChatGPT Export** A clean tab designed specifically so I can copy/export the data and ask ChatGPT to analyse it. **Required data fields:** Where available from PlanIt, I would like the spreadsheet to include: * Application name/reference * Planning authority * County / area * Application start date * Address * Description * Application type * Development type * Status * Decision, if available * Applicant / agent details, if available * Link to planning application * Latitude / longitude, if available * Last scraped / last changed date * Suggested trade category * Opportunity score, if possible **Trade opportunity scoring:** Ideally, I would like a simple scoring system to highlight the best opportunities. For example: * High relevance: extension, loft conversion, conversion, major renovation * Medium relevance: alterations, outbuildings, roof works, garage conversion * Low relevance: tree works, signage, minor admin applications, discharge of conditions I am happy for the freelancer to suggest the best scoring approach. **Technical requirements:** The freelancer should be comfortable working with: * APIs * Google Sheets Apps Script and/or Excel Power Query * CSV/JSON data imports * Pagination * Rate limits * Data cleaning * Building refreshable dashboards/reports The PlanIt API has paging and request limits, so the system must be built responsibly and should not rely on one huge request. **End goal:** Each week I want to be able to refresh the spreadsheet, see the latest planning applications across all counties, identify the best trade opportunities, and then ask ChatGPT to analyse the data by county, trade type and opportunity quality. **Deliverables:** 1. A working Google Sheet or Excel workbook. 2. Automated or semi-automated weekly refresh process. 3. All required tabs and filters. 4. Clean data structure ready for ChatGPT analysis. 5. Simple instructions for use. 6. A short handover call or written walkthrough. 7. Notes on any limitations of the PlanIt API or recommended future improvements. **Please include in your response:** * Whether you recommend Google Sheets or Excel for this. * Examples of similar API/spreadsheet automation work. * How you would handle all counties and multiple planning authorities. * How you would manage API limits and pagination. * Estimated delivery time. * Fixed price quote.