Script Projects

YouTube Shorts Editor (Hoodie Guy Style | 2.5D Animation)

Experience Level: Entry We’re launching a new YouTube Shorts channel based on the viral “Hoodie Guy / Pins Guy” format, and we’re looking for a highly skilled editor who can replicate this style precisely. This is not basic editing. You must understand: Fast-paced, retention-driven cuts (every 1.5–2.5 seconds) 2.5D animation (layered backgrounds + subject + host) Cartoon face overlays (like the competitor channels) Sound design (whooshes, risers, impact hits, ambient layers) Story pacing synced to script escalation If you’ve never created this exact style before, this role is NOT for you. Your Responsibilities: Edit YouTube Shorts (45–60 sec) Create 2.5D scenes using layered assets Maintain high visual stimulation (no static scenes) Sync cuts to voiceover and sound effects Add captions as final layer (not during editing) Style Reference: Channels similar to: YT: Hoodie Guy YT: Pins Guy (You should already be familiar with this format) “Start your proposal with the word ‘FRAME-BY-FRAME’ so I know you read everything.” What We’re Looking For: Proven experience with high-retention Shorts. Strong understanding of viral pacing and storytelling. Ability to follow a structured editing system (we provide a full blueprint). We provide Script and Voice Over. Skilled in CapCut, Premiere Pro, After Effects, or DaVinci Strong attention to detail (timing, motion, sound). Important (Read Carefully): When applying, you MUST include: 2–3 examples of similar edits (Shorts format preferred) Confirmation that you understand 2.5D animation Your workflow (tools + process) Applications without relevant examples will be ignored. Bonus Skills (Preferred but not required): Scriptwriting for Shorts (Hook → Escalation → Climax format) Experience with viral content strategy Project Details: 3–4 videos per week Long-term opportunity if quality is strong Pay: Negotiable $30 per Short (based on skill level) “If your work matches the reference quality, I’m willing to increase the rate quickly.” Final Note: We are building a serious channel, not testing casually. If you can match or exceed the reference style, this can turn into a long-term, high-volume role.

Sales / Appointment Setter

We're InfaCloud, a North East England based web design, hosting, and SEO agency, we manage 500+ client websites on our own server infrastructure and work with small businesses across the UK We're looking for someone confident on the phone to help us bring in new business, calling leads, booking appointments, and helping us grow What you'll be doing - Calling leads we provide, using a script we'll give you to start with - Booking appointments with businesses interested in our services - Keeping a simple log of calls and outcomes in Google Sheets What we're looking for, - Excellent English, written and spoken, this is a must - Confident on cold calls, comfortable handling rejection without it knocking your momentum - Organised, able to keep accurate records of calls and leads - Reliable laptop/PC and a solid internet connection Payment wise - £100 (Let me know how many calls you are willing to make for this) + commission per successful sale Long term role for the right person If this sounds like something you are interested in, get in touch and tell us a bit about your experience with cold calling or sales

opportunity

Social Media Posts for TikTok / Instagram for a Muslim charity

Seeking a creative social media specialist to create 10 engaging TikTok and Instagram posts for a small UK-based Muslim charity that accepts zakat, sadaqah and lillah donations. Content should be respectful, culturally sensitive and inspiring, designed to raise awareness and encourage giving for urgent community projects. Deliverables: short scripts/captions, suggested visuals and hashtag strategy. Tone: compassionate, authentic and uplifting, optimised for engagement and conversions.

UK Property & Housing Outreach

UK Property & Housing Outreach: Seeking English-fluent UK or Ireland-based callers for telephone outreach using an external interface. Candidates must have telephone outreach experience, strong verbal communication, and willingness to learn using the Close platform. Require laptop, headphones with mic, and occasional attendance at Teams meetings. Must follow scripted guidance carefully, respect sensitivities, record opt-outs, and adhere to GDPR. Part-time engagement for up to one month with supportive client oversight and monitoring.

Cold Caller Needed – Contact 100 Companies about team building

I’m looking for an experienced cold caller / business development freelancer to contact around 100 UK-based companies on my behalf. The goal is to explore interest in corporate volunteering partnerships What you’ll be doing: Call approx. 100 companies (B2B outreach) Introduce a simple corporate volunteering opportunity Speak with HR / CSR / People teams where possible Record outcomes (interested / not interested /pas or current partnerships/ follow-up / email sent) Collect names, emails, and decision-maker details where possible What I will provide: Basic script / pitch (can be refined with your input) List of target companies OR guidance on sourcing them (if needed) Email template for follow-ups if required Ideal person: Confident cold caller with B2B experience Comfortable speaking to HR / corporate departments Good at handling objections and gatekeepers Clear English communication Goal of the campaign: To test interest in corporate volunteering partnerships and identify: Companies open to volunteering days in the next 1–2 months HR/CSR contacts for future follow-up campaigns Feedback on how to improve the offer This is an experimental project and can lead to regular work.

Experienced Cold Caller / Appointment Setter

Expanding marketing agency looking to recruit a rockstar virtual assistant to manage and execute on cold calling and appointment booking tasks. Plenty of room for advancement and long term employment if you’re competent, hard working and efficient. BIG cash incentives to be rewarded if you’re able to deliver! Looking for people who value teamwork, focus and efficiency. Skills required: - Excellent English is a MUST (both written and spoken) - Knowledge of Google sheets - Knowledge of cold calling and sales - Knowledge on how to deal with cold - Understanding basic cold calling techniques - Flexibility with working time and hours Technical requirements: - Laptop/Computer with 64 bit processor (windows or mac) - Fast and reliable internet connection Job roles include but are not limited to… - Calling leads that we will provide using a script we will provide - Booking appointments with companies that are interested - Keeping a log of your calls, recording conversations etc Note - put the number ‘88’ in your application so we know you’ve taken the time to read this description!! Required personal attributes: - Strong work ethic - Focus and efficiency - Great english skills Expect a long term role with plenty of room for growth. Approx 3-6 hours per day to start, but this can grow if you are good!

B2B Telemarketing for marketing, digital, and creative agencies.

Seeking 2–3 experienced B2B telemarketers to generate qualified leads for marketing, digital, and creative agencies. You will make 20–30 calls per hour to schedule meetings with decision-makers. All prospect data, email campaigns, and a bespoke sales script are provided. Ideal candidates demonstrate proven telemarketing success, excellent communication, persistence, and self driven. Join a growing team to drive scalable client acquisition. Compensation: £15–£23/hr, 6 hrs/day, 3–4 days/week.

Experienced UK telemarketer for cold B2B calls to care homes

I run a UK technology company that works with care homes. I have a screened list of around 700 UK care homes (checked against TPS and CTPS) and I need an experienced UK based telemarketer to make cold outbound B2B calls on my behalf. This is cold calling, not warm follow up. The people you call have not heard of us before. Your job is a calm, professional introduction to a low cost, no obligation service (a £195 IT cost review), and booking anyone interested in for a short follow up call with me. Consultative and never pushy, but confident opening a cold conversation and handling a brush off. What I need: 1. UK based, native English speaker with a clear, confident phone manner. I am cold calling British care home managers, so this matters a great deal. 2. Proven cold B2B outbound calling experience, ideally in healthcare, care, or professional services. 3. Comfortable working from a supplied list and script, opening cold, handling objections, logging outcomes, and booking appointments. 4. Happy to start with a small paid trial (a few hours or a small block of calls) before any longer arrangement. Please include in your proposal: 1. Your rate, and whether you charge by the hour, by the day, or per booked appointment. 2. Whether you can start with a small trial rather than a long contract. 3. Your relevant cold calling experience, especially any care sector or IT and technology work. I would like to move quickly, so please include pricing in your first message.

Appointment Setter and Cleaner Recruitment Assistant

We are building a UK cleaning-services network across five cities and need confident sales professionals for a paid trial. Responsibilities: * Research letting agents, property managers and serviced-accommodation companies * Make B2B cold calls during UK business hours * Identify cleaning requirements and collect accurate job details * Provide provisional quotes using our pricing guide * Recruit and pre-screen reliable local cleaning companies * Record every call, follow-up and outcome in our CRM Requirements: * Strong spoken English and confident telephone manner * Previous cold-calling or appointment-setting experience * Reliable internet, quiet workspace and quality headset * Comfortable handling objections without sounding scripted * Excellent record-keeping To apply, provide: 1. Your CV and hourly rate 2. A 60-second voice recording introducing our cleaning service to a letting agent 3. Your previous calling results and average daily call volume 4. Your response when someone says, “We already have a cleaner” 5. Your availability in UK time This begins with a paid practical trial. Continued work and performance bonuses are available for qualified opportunities and completed profitable bookings.

Freelance Editor for Short-Form Video Ads (Remote)

About Us: We’re a small but mighty creative studio built by storytellers and strategists who believe that great content isn't manufactured—it's crafted through genuine conversation. We focus on user acquisition short-form video ads that actually move the needle for brands. What we are looking for are independent content partners, not team members. You retain full control over your own time and working methods. Your Role: We’re looking for a passionate Freelance Editor for User Acquisition Short-Form Video Ads to join our distributed team. You’ll mainly edit high - retention, high - conversion videos for TikTok/YouTube. And your superpower is turning raw footage and scripts into polished, scroll - stopping content that keeps viewers engaged from the first 3 seconds to the very end. What You’ll Do: - Edit at least 15 short - form user acquisition videos per week for TikTok and YouTube Shorts algorithms (we’ll provide clear briefs, raw footage, and scripts to get you started) - Polish visuals, pacing, and transitions to create seamless, scroll-stopping content that maximizes watch time and engagement - Collaborate remotely with our creative team, iterating quickly based on feedback to ensure every video is optimized for performance What We Offer: - Your Vision Matters: We don’t do cookie-cutter cuts. We want your unique visual storytelling style to shine through, and we promise to give you detailed, constructive feedback because we know editing is the heartbeat of engaging content. - Creative Growth: You’ll work across diverse industries (from game to lifestyle), and you’ll have a say in the final visual polish—not just mechanical trimming. This is a role where you can grow your portfolio and skills. Who You Are: - Native English speaker with exceptional visual storytelling skills and a versatile creative eye for detail. - Proven experience editing viral short-form content (please include portfolio links and performance data/retention metrics in your application). - Deep understanding of TikTok/YouTube algorithms, audience psychology, and how to maximize watch time through seamless pacing and transitions. - Ability to translate raw footage and scripts into polished, scroll-stopping videos that align with business goals (B2B or B2C background welcome). - Short-form ad editors who have experience in optimizing user acquisition videos (we'll give priority to it). - Strong self-management skills—you can deliver quality work independently without micromanagement. - Familiarity with AI tools (ChatGPT, Claude, CapCut AI, etc.) is a plus but not required. Utilize cutting-edge AI tools to enhance editing efficiency and creativity. How to Apply: If you’re ready to turn raw footage into visual masterpieces that move the needle for brands, please send the following to : 1. Links to 3-5 short-form videos you’re proud of (include view counts and platforms) 2. Use the subject line: "Visual Storyteller Ready" We review applications daily and we’re excited to connect with talented editors who care about the craft as much as we do. Let’s create something meaningful together.

YouTube Documentary Editor for FIFA World Cup Project

Title: YouTube Documentary Editor Needed (Football / FIFA World Cup) I'm looking for an editor for a football documentary project. The video is approximately 15 minutes long and focuses on the hidden influence of FIFA sponsors and the commercial side of the FIFA World Cup. The project already includes: Complete script Voice-over recordings Detailed visual directions Editing notes Reference videos I'm looking for an editor who is comfortable working with: Documentary-style storytelling Archival footage Motion graphics Maps and visual explanations Fast-paced but professional editing Style references include channels such as MagnatesMedia, James Jani, and Johnny Harris. The goal is to create a high-retention YouTube documentary with a premium feel. When applying, please include: Your rate or project quote Estimated turnaround time Examples of documentary-style work or similar projects The project should include one round of revisions after the first full edit is delivered. Minor adjustments to pacing, visuals, graphics, music, and scene selection may be requested during this revision round. Please let me know if your proposal includes revisions and how many revision rounds are covered Before submitting a proposal, please review the script and voice-over materials. If you believe the budget is unrealistic for the scope of work, or that the project would require a different approach to achieve desired quality or if its not a good ideia. Please let me know honestly I'm looking for realistic feedback and open communication rather than unrealistic promises Budget: 150–300 Euros Thank you.

opportunity

Overflow Client Care Coordinator (Remote)

A Essx-based residential Building Surveyor practice is seeking a professional and friendly individual to provide overflow telephone support on a flexible, ongoing basis. This is not a call centre role. We are looking for one dedicated person who can learn our business, understand our services and become a valued extension of our team. The Role Answer overflow inbound calls. Take messages and log enquiries. Assist homeowners with survey and valuation enquiries. Generate quotations using our systems. Escalate specialist enquiries to the relevant team member. Provide an exceptional client experience. Full training, scripts and support will be provided. What We're Looking For Excellent telephone manner. Fluent spoken and written English. Strong customer service skills. Organised and reliable. Comfortable using online systems and CRM software. Available during UK office hours when required. Property, estate agency, legal, surveying or customer service experience would be advantageous but is not essential. Workload & Earnings This is a retained overflow support position operating on a rolling monthly arrangement. Current call volumes are relatively modest and typically equate to approximately 3–5 hours of telephone activity per month, although this may increase as the business continues to grow. The successful applicant will receive a monthly retainer together with additional payments linked to call handling activity. Typical monthly earnings are expected to be in the region of £200–£350+ per month, depending on call volumes and business requirements. Why Join Us? Flexible remote working. Long-term opportunity. Friendly family-run business. Full training provided. Growing company with genuine progression opportunities. Supportive team environment. How to Apply Please provide: A brief introduction about yourself. Details of any telephone or customer service experience. Your availability during UK office hours. A short voice recording (approximately 60 seconds) introducing yourself. We are seeking an individual freelancer only and are not looking for agencies or call centres.

EDIT: AI Video Creator Required

# AI Video Creation & Creative Editing Support I'm looking for an experienced freelancer to help create four high-quality AI-generated videos to accompany a series of business presentations. ## Scope of Work ### AI Video Production I will provide: * The completed presentations * Full video scripts * Brand guidelines and direction I'm looking for someone who can take the content and bring it to life through creative video production. Responsibilities will include: * Developing the visual concept and creative approach for each video * Creating AI-generated visuals, animations and supporting imagery * Selecting appropriate AI tools and workflows * Professional editing, pacing and transitions * Voiceover creation (AI or human-generated options considered) * Background music and sound design where appropriate * Ensuring all videos are polished, engaging and suitable for client-facing use ## What I'm Looking For * Strong experience creating AI-generated business videos * Creative input rather than simply following instructions * Ability to recommend visual styles, storytelling approaches and formats * Portfolio of previous AI video projects * Good communication and collaborative working style ## Revisions This is a collaborative project and I expect revisions and refinements to be included until the final outputs are approved. ## Deliverables * 4 completed AI-generated videos * All editable source files * Final video files in suitable formats for web, email and presentation use ## Timescales Looking to start immediately with delivery over the next 1–2 weeks. Please include examples of similar AI video projects you have produced and details of the AI tools/platforms you typically use.

UK Telesales Closer, Warm Leads. Paid Trial + Commission

LocalWins (localwins.co.uk) is a UK AI agency for small and local businesses, from £49/month. We build, install and run AI for trades and local SMEs: missed-call text-back, 24/7 AI text-back chat that answers questions and books jobs in, an AI receptionist, AI replies to Google reviews, automatic review requests after every job, instant lead response, AI website chat, online booking and brand-new websites. LocalWins Ltd, Companies House 17242503. THE ROLE We need a confident phone closer with native or fluent UK English to call WARM leads and sign them up to the £49/month service. These are not cold lists. Every business has already received a personalised report on their own missed-call and online-presence gaps, and many have opened and read it. You call, talk it through like a local, and close. WHAT YOU GET - Paid trial: around 20 hours at £15 to £20 per hour depending on experience - Then £75 to £100 bonus per signup (clawback if the customer cancels within 60 days) - A ready-made web call console: lead details, what they opened and replied to, their personalised report link, one-tap outcome logging - Call script and objection-handling notes provided - Remote, flexible UK daytime hours, self-employed basis - Ongoing work and better commission terms for the right person WHO YOU ARE - Native or fluent UK English speaker with natural rapport with tradespeople and small business owners (callers must sound local, that is the whole point of our service) - Proven B2B telesales or phone sales experience, comfortable closing low-ticket monthly subscriptions - Own phone and laptop, reliable internet - Genuinely self-employed (you handle your own tax) TO APPLY Send a short note on your relevant sales experience plus a 1-minute voice note introducing yourself as if you were calling a plumber who missed a customer's call this morning.

APPOINTMENT SETTING FOR NURSERY MILK SERVICE

Project Overview Bright Start Milk is a newly approved Nursery Milk Scheme agent helping nurseries across the UK receive government-funded milk for children under 5 years old. We are looking for an experienced telesales professional to contact nursery settings, introduce our service, and arrange appointments with nursery managers, owners, or decision-makers. This is an excellent opportunity for a confident appointment setter with experience in B2B telemarketing, education, childcare, or healthcare sectors. What We Do Bright Start Milk helps nurseries: • Access government-funded milk through the Nursery Milk Scheme Free Milk delivery service from local dairies • Reduce administration and paperwork • Receive friendly, local support • Manage their milk claims efficiently Promote local dairies will be delivering not large corporations Your Role • Call nurseries from our supplied database • Introduce Bright Start Milk professionally • Identify the decision maker Identify current supplier • Explain the benefits of switching to Bright Start Milk • Book telephone or online appointments for our Director • Maintain accurate call notes and outcomes • Follow up interested prospects where required We Provide • Target nursery database • Email templates • Sales script and FAQs • CRM/tracking spreadsheet • Full briefing on the Nursery Milk Scheme Ideal Candidate • Previous telesales or appointment-setting experience • Excellent spoken English • Professional telephone manner • Comfortable speaking with nursery managers and business owners • Self-motivated and target-driven • Experience using CRM systems is beneficial Project Scope Initial trial campaign: • 500 nursery calls per month • Minimum target: 25 qualified appointments per month • Ongoing work available for the right candidate Bonus structure per qualified appointment sat and successful switch. Please Include In Your Proposal Relevant telesales experience Experience booking B2B appointments Your expected hourly or daily rate Estimated calls per hour Any experience within childcare, education, healthcare, or government-funded services We are seeking a long-term freelancer who can help us build relationships with nursery settings and support our growth plans throughout 2026 and beyond. We look forward to hearing from you.

Member Engagement & Relationship Manager (Outbound Calling)

Member Engagement & Relationship Manager (Outbound Calling) **Location:** Remote **Hours:** Flexible (Initial project basis with the potential for ongoing work) **Company:** Beaufort Private Equity About Us Beaufort Private Equity is a private members' club focused on connecting sophisticated and high-net-worth investors with private investment opportunities, education, events, and industry insights. We have a community of over 1,000 members and pride ourselves on being a highly relationship-driven business. Unlike many organisations, we believe in building genuine relationships with our members and maintaining personal communication wherever possible. We are now seeking an experienced and professional individual to help us reconnect with members, strengthen engagement, and ensure our community continues to receive a high level of personal service. The Role This is **not a sales role**. You will be contacting existing members who have previously registered with Beaufort Private Equity. Some members may have become less engaged over time, unsubscribed from communications, changed email addresses, or simply not spoken with us for a while. Your role will be to reconnect with these members, understand their current situation, gather feedback, update records where required, and help strengthen relationships within our investor community. You will be representing Beaufort and therefore must be able to communicate professionally and confidently with business owners, investors, entrepreneurs, and senior professionals. Responsibilities * Reconnect with existing members in a friendly, professional manner. * Update member contact information where required. * Understand why members may have disengaged from communications. * Gather feedback and insights from members. * Reintroduce members to our weekly updates, events, and communications. * Identify members who would welcome further contact from our team. * Maintain accurate call notes and CRM records. * Represent the Beaufort brand professionally at all times. * Escalate any opportunities, concerns, or member feedback to the team where appropriate. What Success Looks Like The successful candidate will help us: * Re-establish contact with existing members. * Improve member engagement and communication. * Ensure member records remain accurate and up to date. * Identify members who would welcome further conversations with our team. * Gather valuable feedback to help us improve our member experience. * Strengthen relationships within our investor community. This is a quality-focused role rather than a volume-based calling position. We value meaningful conversations over call numbers. What We're Looking For We are specifically seeking someone who has: * Strong outbound calling experience. * Excellent communication, rapport-building, and listening skills. * A warm, professional, and relationship-focused approach. * Confidence speaking with business owners, investors, entrepreneurs, and senior decision-makers. * Experience using CRM systems and maintaining accurate records. * A proactive attitude and the ability to work independently. Highly Desirable Experience Experience within any of the following sectors would be advantageous: * Financial Services * Wealth Management * Private Equity * Investment Firms * Investor Relations * Membership Organisations * Professional Services * Business Coaching or Consulting Important This role is focused on relationship building, member engagement, and client care. We are **not** looking for aggressive salespeople or script-readers. We are looking for someone who can build rapport quickly, hold intelligent conversations, make people feel valued, and represent our business professionally. Application Requirements To help us identify the most suitable candidates, please include the following in your proposal: 1. A brief overview of your outbound calling experience. 2. Details of any experience working with investors, financial services firms, wealth management businesses, membership organisations, or professional services companies. 3. Examples of member engagement, client retention, reactivation, or relationship-building projects you have worked on. 4. Your expected hourly rate. 5. Your availability over the next four weeks. 6. How many quality outbound calls you would typically expect to complete per hour. 7. A short voice recording (1–2 minutes) introducing yourself and explaining why you would be suitable for this role. ### Important Please start your proposal with the words: **MEMBER ENGAGEMENT** Applications that do not follow this instruction may not be considered. We are looking for someone who genuinely enjoys building relationships and creating positive experiences for members, rather than someone focused purely on making sales calls.

"New Customer" Conversion Phone Sales

Position Purpose This appointment operates as the primary professional gateway for landlords, managing agents, and property operators seeking immediate guidance on regulatory compliance and enforcement exposure within England, with responsibility to convert those enquiries into paying clients. This is a sales role requiring strong human sales skills and availability for UK working and evening hours, making UK based candidates most suitable. Comfort must be demonstrated in asking direct and sometimes difficult questions to obtain accurate and truthful answers. Information must be gathered efficiently and prospects must be guided with authority to book and pay for a consultation. Each lead will already have identified a need for the firm’s services. The role requires structured interviewing, qualification against the firm’s offering, and progression to a paid, high value consultation with the Casework Director. Responsibility includes disciplined management of inbound and outbound communications, rapid extraction of relevant information, and structured progression of enquiries into retained legal consultations valued in excess of £500. This is not an administrative post. This is a revenue enabling, compliance sensitive, front line role requiring judgement, authority, and measurable commercial impact. Key Responsibilities All telephone engagements must be conducted promptly, professionally, and with controlled authority. Approved diagnostic frameworks and scripts must be followed precisely during initial development in the role. Conversations must be steered firmly to maintain focus, clarity, and relevance. All required data must be captured accurately in real time and recorded in compliance with internal standards. The seriousness of each legal issue must be assessed through structured questioning, with matters triaged appropriately. Where appropriate, callers must be confidently guided towards booking a paid consultation. Financial transactions must be processed calmly, securely, and in accordance with company procedures. Between 20 and 30 calls per day will be managed once established in the role. A minimum of 2 structured triage calls per hour is expected during a 6 to 7 hour working day once competent. All personal and case information must be verified verbally and confirmed for accuracy. All post booking communications must be triggered correctly without omission. Any inconsistency, uncertainty, or legal risk must be escalated immediately. Absolute Requirements Fluent spoken English is mandatory, delivered with clarity, confidence, and a professional tone. A natural alignment with England based communication standards is required. A working understanding of UK address structures, postcode formats, local authority terminology, and regulatory language is essential. Strict adherence to process and compliance protocols is non negotiable. Each call must be conducted with calm authority and commercial awareness. Experience Required Prior experience in a structured telephone environment such as professional services intake, regulated sales, or call centre operations is required. Proven success in converting prospects into paid professional services is essential. Experience handling high value transactions and processing card payments by telephone is required. Experience working in target driven environments is expected. Exposure to legal, property, or compliance sectors is desirable. Skills and Attributes Strong listening capability with the ability to isolate key facts quickly. Ability to redirect conversations while maintaining authority. Commercial confidence to secure payment when appropriate. High attention to detail with zero tolerance for inaccuracy. Resilience under sustained call volume. A composed and authoritative telephone presence. Professional scepticism with no assumptions made. Security and Integrity References must be verifiable. Background screening will be required. Confidentiality and data protection standards must be upheld at all times. Sensitive legal and financial information will be handled, requiring absolute integrity. Working Pattern Availability of 6 to 7 hours per day is required. Call volumes must be managed within that period without backlog. Flexibility may be required to meet demand. Final Statement This appointment sits at the commercial heart of the organisation. It requires discipline, structure, authority, and commercial awareness. This role suits an individual who understands that precision and control generate trust and results, and who is capable of converting new customer engagement into retained business through structured relationships.

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.