Field Projects

AI assistant call handling

I’m looking for a developer to build an AI-powered call handling and dispatch system for emergency/facilities maintenance calls, similar to corecall.co.uk. I have an existing IP phone system this needs to integrate with. ( Hihi) What it needs to do: • Answer inbound calls via AI (voice agent), 24/7 • Have a natural conversation to capture caller name, location, fault description, and urgency • Automatically match and dispatch the right engineer based on skill, location, and availability • Send SMS/email notifications to both the engineer and the customer • Provide a live dashboard showing incidents, statuses, and engineer availability • Integrate with our existing systems Ideal experience: • Voice AI platforms (Vapi, Retell, Bland, or similar) • SIP/VoIP and PBX integration (3CX experience a strong plus) • Backend development (Node.js or similar) — APIs, webhooks, databases • Twilio or similar for SMS/email notifications • Comfortable building a clean operational dashboard Nice to have: • Prior experience building call-handling/dispatch systems for trades, FM, or field service businesses • Experience with Anthropic/OpenAI APIs for conversational logic To apply, please include: • Relevant past projects (especially anything involving voice AI or SIP/PBX integration) • Your estimated hourly rate and roughly how many hours you’d expect this to take • Any questions about scope I already have a working architecture plan and some backend code scaffolded, so this isn’t starting from zero happy to share on request. PLEASE DO NOT ADD ME ON LINKED IN OR EMAIL ME OR MAKE ANY CONTACT OUTSIDE OF THIS PLATFORM I WILL REPORT AND BLOCK

I have written a poem, I want videos played throughout.

I have just this evening written a poem, I still need to revise it slightly, but I would ideally love someone who could compile a 3:29 video with background music 'Sand Drawing - Judah Earl'. I have read it out loud with this song playing quietly in the background, I am no video editor, but with weeks of planning and software and time - which I do not have - I may be able to pull something off. Alas, I require the help of a professional. I have worked out roughly, each video needs to be 3-5 seconds long. I don't know whether it's easier to compile them all at 5 seconds and then shorten the clip to match the words? I have details below the scenes I would love to have based on the chronological order of the poem. The one caveat, is ideally I would love to make all the clips my own, using me, my friends and family. However, that will take much longer. Therefore, I thought, if I can pay someone to get the whole video created, with the text and timing done to a tee, then I could ideally work with you again to revise some if not all of the video clips and swap them out with my own. How does that sound? I don't know the price, might have to be an hourly basis. It would also be lovely if you have your own video footage, to make it personable, otherwise stock footage is fine. As I say, with potential revisions done later. Video Scene Order: 1- A man sat quietly on a bench in the background, looking somewhat sad, with hustle and bustle, crowds of people in the foreground passing by as he looks around. 2- A man or woman praying in a church, chapel, then looking out the stained glass window at the end. 3 - two friends hugging and talking 4 - A Mother and Father dancing or grandparents 5 - A man crying looking to the skies, cloudy grey skies, close up of the eyes, filled with sadness - this could be a couple of videos 6 - Sky scenes, clouds, rain, sunsets in the sky, birds flying, a few montage scenes 5-8 seconds 7 - Flying birds, like a murmuration of birds would be wonderful 8 - Crying person with great emotion, letting it all out, saying goodbye perhaps 9 - someone skimming with a stone, the stone disappears - farewell. another drop in the ocean so to speak. 10 - Traveller, explorer, filmed from behind, with a rugged backpack, climbing a hill, mountain, coast path, adventure themed, moving on, going forth with great strength. 11 - Young couple kissing, intimate, young love 12 - Older couple embracing, long lasting love 13 - Seasons Montage - Spring, Summer, Autumn, Winter. - beautiful. 14 - Clocking spinning, turning, large railway clock, maybe a time lapse of people at times quare station flying by - hinting time flying by. 15 - Someone thinking, deep in thought, pondering questions, maybe sat somewhere quiet. 16 - Something to portray gladness and sadness - good times and bad times, laughter and difficult times. 17 - Workout video, a man or woman pushing through the pain, close up shot in their eyes lifting heavy weight or at the gym, showing power, strength and resilience. 18 - Heartbreak, someone alone by a tree, in a park, relationship ended, sad tears, something to show the world falling around them, maybe leaves falling from a tree as a secondary video. 19 - Clear, calm seas, a beautiful shot of calm waves and maybe a sunset or a whale breaching. 20 - Trees blowing in the wind, shot looking up through the trees. 21 - Moonlight, a breeze at night, a night time scene, maybe the night sky and a shooting star afterwards. 22 - Sunrise, the most beautiful sunrise shot, maybe even with someone in it, looking at the sun as it rises. 23 - A man - me eventually - sat in a meadow, a lovely field, an old English Oak Tree, a wooden field gate, something such as this, looking into the sunset, the shot filmed from behind, contemplating life and lost in thought. End Scene. Thanks p.s. I don't have bags of money, but this is so special to me, I want it to be the first video on my new Instagram account, dedicated to my film making and poetry, reigniting my old self.

Full-Cycle UI/UX Redesign & Custom WP Development

Hello, We are seeking a senior-level digital agency, a structured team, or an expert Full-Stack Product Creator to handle the complete end-to-end overhaul (UI/UX Design in Figma + Custom WordPress Development) for our corporate employee benefits and insurance agency platform. The current website is text-heavy and lacks interactive features. The goal is to build a sleek, high-converting, and modern enterprise platform from scratch. PHASE 1: UI/UX DESIGN REQUIREMENTS User Path Segmentation: The design must instantly segment three distinct audiences on the homepage: Employers/HR Managers, Insurance Brokers, and End Employees. Key Layouts Needed: A premium segmented Homepage (with onboarding pipeline timelines and custom dashboard mockups), a detailed Services/Tech showcase, and a high-trust Lead-Gen/Demo booking funnel. Design System: Deliver a highly disciplined Figma project using a rigid Layout Grid System (12-column desktop @ 1440px / 4-column mobile @ 375px) and a complete corporate UI Kit (exact typography scales, interactive states, organized naming conventions). PHASE 2: NATIVE WORDPRESS DEVELOPMENT Strict Code Architecture: Clean custom theme build utilizing native Gutenberg blocks combined with Advanced Custom Fields (ACF Pro). Zero Page Builders Policy: Absolute ban on heavy infrastructure like Elementor, Divi, or WPBakery. All elements must be rendered using lightweight, custom HTML/PHP. Performance & Core Web Vitals: Exceptional optimization out of the box to guarantee elite loading speeds (strictly targeting 90+ score on Google PageSpeed Insights for both Desktop and Mobile views) and absolute control over CLS. Asset Compliance: All icons, badges, and layout vectors must be coded using native, lightweight inline SVG shapes. WHAT WE EXPECT IN YOUR PROPOSAL: Links to premium, live corporate B2B, SaaS, or fintech websites that your team designed AND coded from scratch. Confirmation that you develop natively on WP (without visual builders like Elementor). Your estimated timeline split by Phase 1 (Design) and Phase 2 (Development). We have attached a detailed 3-page Technical Specification PDF below. Please analyze it carefully before bidding. Generic or automated boilerplate proposals will be archived instantly. Thank you!

opportunity

Set Up Simple CRM & Automation System

I run a small accommodation matching business and need help setting up a simple, low-cost CRM and workflow automation system. At the moment, I have a WordPress website with enquiry forms using Google Forms. Responses go into Google Sheets. My business email is Microsoft Outlook. I am finding it too time-consuming to manually manage enquiries, update spreadsheets, track follow-ups, write similar emails, and create booking confirmation documents and host/guest summary forms. I do not want a complex or expensive CRM. I need a practical system that is easy for me to use and maintain. The system should help me manage: * Candidate enquiries * Host enquiries * Bookings * Follow-ups * Daily tasks * Outlook email drafts * Booking confirmation documents * Host/guest summary documents Ideally, I would like: 1. A simple CRM/tracker for candidates, hosts and bookings. 2. Statuses such as new enquiry, needs reply, awaiting response, ready to match, host offered, awaiting payment/details, booking confirmed, active stay, completed and not proceeding. 3. A daily to-do view showing overdue and due-today actions. 4. Fields for priority, next action, follow-up date, last contacted date, notes, area, dates, budget, host offered and booking status. 5. New enquiries from Google Forms/Google Sheets to feed into the system. 6. Outlook email draft templates for common replies. I do not want emails auto-sent without review. 7. Templates for booking confirmation documents and host/guest summaries. 8. A way to populate documents from booking details and save them in an organised folder structure. 9. A simple setup that keeps monthly software costs low. 10. A short guide or video showing me how to use and maintain the system. I am open to suggestions on the best tools, but possible options include Microsoft Lists, Microsoft Planner/To Do, Power Automate, Airtable, Make, Zapier, Google Sheets, Word templates or Google Docs templates. I would like someone who can recommend the best low-cost setup and build the first version. Please quote a fixed price and explain: * What system/tools you recommend * Why you recommend them * What will be included * How long it will take * What information you need from me * Any monthly software costs * Whether I will be able to manage it myself afterwards I want a simple, practical first version rather than a complicated custom system.

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

opportunity

Add functionality to app - Dart / Flutter app

Project Brief – App Development Overview This project involves adding new functionality across two existing checklist/reporting applications. Both apps allow users to complete food safety checklists which are then stored and generated into reports. Several features already exist in one application and now need to be duplicated into the other, alongside new functionality. Application 1 – GS App 1. Live Temperature Sensor Updates Implement live updating temperature readings from connected sensors. 2. Manual Label Printing Add a "Print Manual Label" screen. Users should be able to generate and print labels without selecting an existing food item. 3. Amazon Label Reordering Add an Order Labels button. When pressed: Customer's saved Stripe payment method is charged. Amazon Multi-Channel Fulfilment (MCF) automatically ships a new roll of labels to the customer's registered address. No manual intervention required. 4. Delivery Comments Add a comments field to Delivery records. Comments should also appear on generated reports. 5. Report History At the bottom of the Reports screen display the last 5 reports generated. Users should be able to download/view these reports again. 6. Compliance Improvements Add two new compliance sections: Pest Control Agreement Oil Disposal Agreement The documents will be uploaded through the dashboard and viewable from the mobile app. 7. Copy Compliance Allow compliance checklists to be copied/imported from the second application. Application 2 – SF 1. Duplicate Label Printing System Copy the complete label printing functionality already built into the GS App, including: Manual Label Printing screen Existing label printer functionality 2. Amazon Label Reordering Add an Order Labels button. When selected: Customer's Stripe payment method is charged. Amazon MCF automatically dispatches label rolls. Printer purchases remain available within the Owner Account section. 3. Delivery Comments Add comments to delivery records. Include these comments on generated reports. 4. Report History Display the last 5 generated reports at the bottom of the Reports screen with download capability. 5. Compliance Documents Add two new compliance sections: Pest Control Agreement Oil Disposal Agreement Documents are uploaded through the dashboard and viewable within the mobile application. SFBB Pro – Subscription & Multi-Site Upgrade Subscription Changes Remove the existing: Normal Plan Premium Plan Replace with: Standard Subscription Current application functionality. Label Printing Subscription Includes label printing functionality. Multiple Site Subscription Additional charge: £12.95 per additional location Multi-Site Management Create owner-level multi-site functionality. The account owner should be able to: Add new locations. Remove locations. View all locations from a dashboard. Be charged for each additional location. Assign a Location Administrator for each site. Each Location Administrator should: Only access their assigned location. Complete daily checklists. Manage staff for their location. View reports for their location only. The Owner should have visibility and reporting across every location. General Requirements The developer should: Reuse existing functionality wherever possible rather than rebuilding it. Maintain the current design style. Ensure all new features are fully integrated into reporting. Test all new functionality before completion. Deliverables GS App Live sensor updates Manual label printing Amazon MCF label ordering Delivery comments Report history Compliance document upload/view Compliance copy feature SFBB Pro Duplicate label printing system Amazon MCF label ordering Delivery comments Report history Compliance document upload/view Subscription restructuring Multi-site management Owner dashboard Location administrator functionality Agreement Please review the above scope carefully. If you are happy with everything listed, please confirm that you agree this represents the full scope of work before development begins.

opportunity

SEO Audit + Basics

Project Overview We are looking for a junior–mid level SEO specialist to support a new website for a three-year professional training programme in the Adria region (Croatia, Slovenia, and surrounding markets). The programme is part-online, part-onsite, and based on the Grof Legacy Training lineage (Stanislav Grof / Holotropic Breathwork). The target audience is licensed therapists, facilitators, and professionals in the field of psychedelic-assisted therapy and transpersonal psychology. This is not a clinical service website and not intended for general consumer or patient acquisition. The goal is to ensure the site is fully optimised and discoverable ahead of our enrolment campaign launching 1 July, with the programme starting 15 October. Scope of Work 1. SEO Audit Technical SEO audit On-page SEO review Off-page/backlink analysis Regional visibility review 2. Keyword Research & Strategy Focus on professional intent search terms such as: “holotropic breathwork training” “psychedelic-assisted therapy certification Europe” “Grof legacy training” Include English plus relevant regional keywords (Croatian/Slovenian where appropriate) 3. On-Page Optimisation Meta titles and descriptions H1–H3 structure optimisation Content refinement for clarity and SEO Image alt text SEO-friendly URL structure 4. Technical SEO Fix crawl/indexing issues Broken links and page speed improvements Sitemap and robots.txt checks Mobile optimisation Schema implementation (Course / EducationalOrganization) 5. Tracking Setup GA4 setup Google Search Console setup Simple performance reporting template 6. Backlink Opportunities Identify 10–15 relevant backlink sources (training directories, associations, podcasts, professional networks) Deliverables SEO audit report (actionable) Keyword strategy + mapping On-page implementation of agreed fixes GA4 + Search Console setup Backlink opportunity list Short recommendations for ongoing optimisation Ideal Candidate Experience with SEO audits and on-page implementation Comfortable working with education / wellness / professional training content Familiar with GA4, Search Console, and tools like Screaming Frog + SEMrush/Ahrefs Bonus: multilingual or international SEO experience (Europe/Balkan region) Timeline Must be completed and live by 1 July. Please include your estimated turnaround time in your application. Budget Fixed fee: €450–€600 for full scope.

Build a Secure Live AI Research Data Processing Prototype

Rapid Low-Code AI Document-Parsing Web Prototype (Secure Cloud Tenant) in Microsoft Copilot Studio / Azure OpenAI Project Overview: I need a highly concise, working prototype of a secure web application interface. The sole purpose of this app is to demonstrate a secure, live text-processing pipeline during a brief stakeholder review. It must ingest a raw text document/dataset, simulate a structured evaluation process against a pre-set compliance rubric, and dynamically display an optimization analytics page. Key Requirements to Implement: 1. Secure File Upload Interface A minimal, clean user interface with a file drop zone labeled: "Secure Sandbox: Upload Manuscript / Dataset Draft (PDF, DOCX, or CSV)". A secondary text field labeled: "Alternative Manual Input: Paste Methodology / Text Details". A dropdown parameter selector: [Parameter Group A / Baseline Metrics Checklist]. 2. Localized Governance Engine Setup Connect this frontend interface securely to an LLM endpoint (via Microsoft Copilot Studio, Azure OpenAI Studio template, or a standard private API pipeline). Define system prompts to parse the document's sections (checking for structural clarity, data mapping consistency, and alignment with baseline formatting rules). 3. Dynamic Output & Accountability Dashboard Upon document submission, the UI must refresh dynamically to show: Maturity / Verification Score: A clean progress gauge (e.g., Ecosystem Readiness Level: 84%). Compliance Rules Checklist: Visual indicators displaying: [Passed] Citation & Data Anonymization Check [Passed] Methodological Parameter Scope [Warning] Formatting Ambiguity Detected in Section 3 Actionable Next Steps: A generated text box detailing exactly what parameters need optimization. Technical Constraints: Must be deployed on a functional, live preview web URL so I can interact with it live during the meeting. Data privacy configuration must be explicitly set to ensure no data processed is utilized for public model training datasets. Important Fail-Safe: Hardcode a single specific fallback template path into the interface so that if the live internet connection fluctuates during the review, the target upload file will immediately trigger the exact correct completed dashboard layout cleanly.

Machine Learning Research Proposal Specialist

Overview We are looking for a Machine Learning Research Proposal Specialist to create a polished, professional research-style write-up for an ML evaluation task. The submission should propose a machine learning problem within the writer’s domain of expertise and must be directly related to machine learning. The final deliverable should be written in markdown format, follow the provided template exactly, and be no longer than 1–2 pages with a maximum of 8 paragraphs. Project Goal The goal of this project is to design a machine learning benchmark or problem that is complex enough to challenge a strong state-of-the-art LLM. The problem should not be a simple generic ML pipeline task. It should require deep domain expertise, advanced reasoning, and layered technical understanding that would be difficult for a general-purpose model to solve without specialized knowledge. Responsibilities The selected specialist will write a complete research proposal-style submission using the required sections: Domain and Motivation, Task Design, Data and Data Generation, Sources of Difficulty, Reference Solution and Scoring, and Citations. Each section should be concise, polished, and limited to one paragraph. The proposal should clearly explain the ML domain, why the task is meaningful, what is being predicted, how the data would be generated or adapted, why the task requires extrapolation, and why naive approaches would fail. Ideal Candidate The ideal candidate has strong experience in machine learning, applied AI, data science, or ML research, with expertise in at least one technical or scientific domain such as healthcare, finance, robotics, cybersecurity, biology, materials science, geospatial analysis, NLP, computer vision, or another complex field. They should be able to design a creative ML task that rewards real domain knowledge rather than basic textbook ML skills. Required Skills Strong understanding of machine learning problem formulation, benchmark design, data generation strategies, train/test split methodology, model evaluation, and scoring metrics is required. The candidate should also be comfortable explaining why a task is difficult, what domain-specific insights are needed, and how an expert would approach solving the problem. Clear technical writing and the ability to produce concise markdown-formatted documentation are essential. Deliverable The final deliverable will be a markdown-formatted research proposal following the provided template. It should be professional, concise, and no more than 8 paragraphs total. The proposal must involve machine learning directly and should include citations where applicable, such as relevant research papers, datasets, GitHub repositories, or other credible references that support the proposed task. Important Notes This is a machine learning evaluation project, so proposals that are not directly related to ML will not be accepted. The model output should be ignored during the evaluation process, and once the prompt has been entered and the model generates a response, the evaluator should select “Done Chatting.”

opportunity

Bespoke Online Booking System for External Assessors

OVERVIEW We're a care home group with 8 homes. We need a simple, self-service web booking tool for external assessors (DoLS Best Interests Assessors, CHC assessors, FNC reviewers, IMCAs, and others) to book their own visit slots to assess a resident. Currently done manually by phone/email — slow and time consuming. We want this replaced with a lightweight tool. WHO USES IT External assessors (primary users) — book their own slot, no account hassle. Our central Assessments and Contracts team (oversees all 8 homes) — configures settings and sees all bookings. CORE FEATURES Public booking page(s) — one per home or a single page with a home selector. Assessment type selection (DoLS, CHC, FNC Review, DST, IMCA, Best Interests Meeting, "Other" free text) — expandable later. Live availability & direct booking — no manual approval needed for MVP. Configurable minimum notice period per assessment type — e.g. DoLS bookable next day, CHC needs 2 weeks minimum, others TBC. Must be adjustable by our Assessments and Contracts team via a settings screen, not hardcoded. Outlook Calendar integration (Microsoft Graph API) — bookings sync with real per-home calendars and auto-create events. Automatic confirmation/reminder emails to assessor and home contact on booking, change, or cancellation. Microsoft Teams integration — auto-generate a Teams link for remote/hybrid visits. Booking form fields: assessor name/organisation/email/phone; resident's name; resident's DOB or NHS number; assessment type; "will staff time be required?" (Y/N); "will medical records be required?" (Y/N); "has NOK been notified?" (Y/N); free-text notes. Self-service reschedule/cancel via link in confirmation email. Central dashboard for the Assessments and Contracts team — view bookings across all homes, manage notice-period settings. NICE-TO-HAVES (not required for MVP) Per-home blackout dates; CSV/Excel export; SMS reminders. TECHNICAL PREFERENCES Must integrate with Microsoft 365 (Outlook + Teams) via Graph API or equivalent — no third-party calendar system. Freelancer's choice of platform/stack, as long as it integrates well with M365 and is easy for us to maintain (please explain your approach, e.g. Power Apps/Power Automate vs custom web app). Mobile-friendly, since assessors will often book from their phone. DATA PROTECTION Resident DOB/NHS number plus assessment type counts as special category health data under UK GDPR. Please address in your proposal: hosting/encryption (at rest & in transit); who can view resident-identifying records; retention/auto-purge policy; relevant experience with health-adjacent data in a UK/CQC-regulated context. No full medical records/care notes should be stored in the tool. DELIVERABLES Working system live across all 8 homes, link shareable with assessors. Outlook sync + Teams link generation, tested. Short (1-2 page) admin guide for the Assessments and Contracts team. Handover of admin credentials/access. BUDGET & TIMELINE Under £500 (MVP scope). A few weeks. Open to a phased approach — core booking + calendar sync first, nice-to-haves later if budget allows. PLEASE INCLUDE IN YOUR PROPOSAL Proposed tech approach and why it suits Microsoft 365; relevant experience with booking systems/Graph API/Outlook/Teams integrations; rough timeline and milestones; assumptions/questions given the budget.

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.