5 Projects

Scrape 22 Sources – Approx. 110k Records

Scrape 22 Sources – Approx. 110k Records Please find attached the detailed scraping instructions for each source. The highlighted sections (yellow) identify the 22 data sources to be processed, with an estimated total of approximately 110k school records. DELIVERABLES For each highlighted source, create a separate folder containing: • One Excel (.xlsx) file with the extracted data. • The Excel should include, whenever available, at least the following columns: o School Name o Address o Email o Telephone If a source provides additional useful fields requested in the detailed instructions (e.g. postal code, school code, city, etc.), include them as extra columns. IMPORTANT • Follow the source-specific instructions in the attached document, as they take precedence over these general guidelines. • One output folder per highlighted source. • One Excel file per source. • Preserve all available records from each source. VALIDATION SAMPLE To demonstrate that you fully understood the task before the full assignment starts, please provide a sample Excel containing 5 records for each of the following sources: • Austria • Greece • Belgium – Wallonie WBE The sample should follow exactly the same structure and extraction rules that will be used for the final delivery. TIMELINE • Submit the validation sample as soon as possible. • I will be on holiday from 17 July to 30 July. Please ask any questions before 17 July, as I may not be available during that period. • The final delivery is required within 7 days of the project award. Please use the time before the assignment confirmation to review the instructions and prepare the validation sample. Once the work is assigned, the extraction can proceed without further clarification.

API Integration & CRM Automation Specialist Needed

API Integration & CRM Automation Specialist Needed (Long-Term Opportunity) We're looking for an experienced API Integration & CRM Automation Specialist to help streamline our business processes and build reliable automation workflows. Responsibilities - Integrate third-party APIs (REST APIs, webhooks, OAuth) - Set up and optimize CRM platforms (HubSpot, Salesforce, Zoho, Pipedrive, etc.) - Build automation workflows using tools like n8n, Make.com, or Zapier - Connect applications such as Google Workspace, Slack, Stripe, Airtable, Notion, OpenAI, and other SaaS platforms - Troubleshoot and maintain existing integrations - Create scalable, well-documented automation solutions Required Skills - Strong experience with REST APIs, JSON, webhooks, and authentication methods - Hands-on experience with at least one major CRM platform - Experience with automation tools (n8n preferred, Make.com or Zapier also acceptable) - Ability to understand business workflows and translate them into automated systems - Strong debugging and problem-solving skills - Good communication and fluent English Preferred - Experience with OpenAI or other AI APIs - Knowledge of JavaScript or Python - Experience with databases such as Airtable, Supabase, or PostgreSQL To Apply Please include: 1. Your top 3 API integration projects. 2. Which CRM platforms you've worked with. 3. Which automation tools you use most. 4. A brief explanation of the most complex workflow you've built. 5. Your hourly rate and availability. We're looking for someone who focuses on quality, reliability, and long-term collaboration—not someone who only connects apps using basic templates.

Construct 3 Developer for Interactive Educational Web Game

Experienced Construct 3 developer needed to create a polished HTML5 educational game for ages 8–12 focused on environmental awareness and recycling. Build a responsive browser game with main menu, settings, instructions, 5–8 levels, drag-and-drop sorting, timer challenges, point/reward system, progress tracking, simple character animations, interactive effects, sound/music, and unlockable locations. Deliverables: organized Construct 3 project file, export-ready HTML5 build, source assets, bug fixes, and concise documentation. Familiarity with event sheets, behaviors, optimization and clean maintainable code required.

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.

opportunity

Linkedin Content Strategist & Daily Engagement Partner

I’m the Retail Director at a UK-based freight forwarding company. I want to build a strong, authentic personal brand on LinkedIn in the freight, logistics and supply chain space — with a particular focus on retail sector challenges and solutions. My goals: • Become a recognised voice and thought leader • Grow my follower base with the right people (retailers, supply chain/procurement professionals, logistics peers, decision-makers) • Increase meaningful engagement and inbound opportunities • Stay super active and visible in a smart, sustainable way I already create my own posts and graphics. I’m looking for a strategic partner who will guide the “what” and “when”, while also handling the heavy lifting on daily engagement. What you’ll be responsible for: 1. Content Strategy & Storyboarding Develop clear content pillars tailored to a Retail Director in freight forwarding. Create weekly/bi-weekly content calendars with post ideas, recommended formats (carousels, text, polls, short video, documents, etc.), strong hooks, and calls-to-action. Provide outlines or suggested copy (I will write the final versions and create all graphics). 2. Posting Schedule & Activations Recommend the best days/times for a UK B2B audience in 2026. Advise on LinkedIn algorithm best practices, what “activations” actually move the needle (polls, carousels, series, commenting strategies, etc.), and how to maximise reach and engagement. 3. Daily Niche Engagement (core part of the role) Thoughtfully comment on 20–50 relevant LinkedIn posts per day in the freight, logistics, supply chain, retail, and import/export space. Comments must be high-quality, value-adding and non-spammy (sharing insights, asking smart questions, adding perspective). This is manual work only. The goal is visibility, relationship-building and algorithm love. You’ll report on activity and results. 4. Follower Growth & Overall Strategy Give ongoing advice on profile optimisation, networking, content repurposing, and how to best use my current Botdog automation tool alongside organic activity. Help me market myself effectively and accelerate follower growth in a compliant way. 5. Reporting & Collaboration Weekly or fortnightly check-ins (Zoom or async) to review LinkedIn analytics, discuss what’s working, refine the strategy, and plan ahead. Track progress against clear KPIs (follower growth, engagement, profile views, quality of comments, etc.). What I will handle: • Writing and publishing all final posts + creating graphics • Day-to-day posting on my profile • Giving you any sector-specific insights you need Ideal freelancer: • Proven experience helping B2B executives or professionals grow their LinkedIn presence through content strategy + daily engagement (please share real results or case studies). • Strong understanding of current LinkedIn best practices (2026 algorithm, personal branding, what actually works for B2B service/industry profiles). • Excellent at crafting professional yet conversational B2B content ideas — especially in freight, logistics, supply chain or retail (prior experience in these sectors is a big plus). • Reliable and disciplined with daily engagement work. You enjoy being active on LinkedIn and know how to comment in a way that builds genuine connections. • Comfortable working with or advising on tools like Botdog. • UK/EU timezone preferred (or very flexible). • 100% committed to staying within LinkedIn’s Terms of Service (manual, high-quality commenting only — no automation for comments). How we’ll work: This is an ongoing role. I’d like to start with a 4-week trial, then move to a monthly retainer if it’s a good fit. Please include in your proposal: • Why you’re the right person for this (and any relevant niche experience) • Your approach to daily commenting (include 2–3 examples of strong vs weak comments in a B2B context) • 3–5 suggested content pillar/theme ideas specifically for a Retail Director in freight forwarding • A sample 1-week content idea list (5–7 post concepts) • Your proposed weekly time commitment and rate (hourly or monthly package) • Links to relevant work, portfolio, or your own LinkedIn profile so I can see your style and results Indicative budget: £800 – £1,100 per month (depending on experience, hours and results). Quality and reliability are more important than the lowest price. Realistic proposals welcome. I’m looking for a long-term partner who is proactive, strategic, and excited about helping me become consistently visible and valuable on LinkedIn. Looking forward to your proposals

opportunity

I need a reels / tiktok / short form editor (monthly retainer)

Reels /TikTok Editor Women's Travel Brand (part-time, ongoing) Hi! I'm a founder and brand owner of a travel company and I am looking for someone to support me with Reels / Short form video editing on a monthly ongoing basis. The kind of content that I will need editing: > mini vlogs > voiceover > talking to the camera > quick cuts aesthetic style posts I am looking for around 25-30 edited pieces of content each month - all content will be provided to you! I would love to start on a trial maybe editing 3-5 videos first to see if I like the quality / style and then we can work ongoing long term on a retainer basis! There is room to grow into the role as well! I have a huge amount of content from the past that has been captured and content that is constantly being recorded so there is huge opportunity to work together here. You'll thrive here if you: Live and breathe Instagram Reels + CapCut + TikTok Are reliable and fast (daily cadence matters as I need to trust it gets done and sometimes content may need to be edited within 24-48 hours, sometimes time will be longer) Communicate clearly in English Have worked with travel brands / founders before Ideally, I am looking for a woman who understands a female audience and bonus if you're a traveller, as that is my ideal customer! Here is the type of style of content that I will need: REFERENCE 1 TALKING TO CAMERA - https://www.instagram.com/reel/DWJ_iTcCGO8/ REFERENCE 2 VLOG - https://www.instagram.com/reel/DZnvvd8ALex/ REFERENCE 3 AESTHETIC - https://www.instagram.com/reel/DZb9qJgJ36y/ REFERENCE 4 VOICEOVER - https://www.instagram.com/reel/DaLpNkPMVjy/ To apply: Send 2–3 short-form examples you've made that are aligned with the reference examples above, plus the word "pink sand" at the top so I know you read this.

Photoshop & AI Specialist for Realistic 3D Floor Plans

We're looking for a talented Photoshop and AI image editing specialist to join our team on an ongoing freelance basis. Your role will be to create realistic 3D top-down floor plans for luxury residential properties featured across our YouTube channels, including The Luxury Home Show, The New Build Show and The Interior Design Show. These floor plans are used within our professionally produced long-form property tours and must accurately reflect the layout, furniture, flooring and finishes shown in the original property. For each project, we'll provide: - The original architectural floor plan. - Video walkthroughs of the property. Using these materials, you'll recreate the property as a realistic 3D floor plan before producing a final AI-enhanced render ready for use in our videos. We're looking for someone who: - Has advanced Adobe Photoshop skills. - Has experience with AI image generation and editing tools (such as ChatGPT, Artlist AI or similar). - Has excellent attention to detail and can accurately recreate interiors from reference material. - Can communicate and collaborate during UK business hours (Monday–Friday, approximately 9:00 am–5:00 pm GMT/BST). - Is looking for an ongoing working relationship with regular projects. Please note: A PDF guide is attached outlining our current workflow. We expect applicants to familiarise themselves with this process, as it demonstrates the quality and consistency we're looking for. However, we're not prescriptive about the software or workflow used. If you know of a faster or more efficient method that produces the same (or better) results while maintaining our quality standards, we're happy for you to use your preferred approach. The final output is more important than the process used to achieve it. When applying, please include examples of any relevant work, particularly architectural visualisation, Photoshop compositing, AI image editing or realistic floor plan creation. Applicants with relevant portfolio examples will be prioritised. We look forward to finding someone who can become a long-term part of our creative team.

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.

Video Editor for 1st Birthday Photo Slideshow

I am looking for an experienced video editor to create a beautiful and emotional 1st birthday retrospective video for my daughter. The video will be a photo slideshow with a specific theme and layout requirements. Project Details: Theme: Under the Sea. Duration: Between 3 to 5 minutes. Format: Photo Slideshow. Total Photos: Approximately 150 photos to be included in the slideshow. Photo Layouts: The slideshow should be dynamic, displaying photos in different grid formats throughout the video. Specifically, I want scenes showing 1, 2, 4, and 8 photos at a time on the screen. Transitions & Effects: Open to the editor's creativity, but they should be smooth and match the "Under the Sea" theme (e.g., fluid movements, soft fades). Audio: I will provide 2 specific songs to be used as the background track. The editor must synchronize the photo transitions with the rhythm of the music. Visual Elements: I will provide a specific color palette and visual elements (such as corals, bubbles, fishes, etc.) to be incorporated into the video design/backgrounds once the job is awarded. Requirements: Proven experience in video editing and creating dynamic photo slideshows. Ability to work with specific color palettes and thematic elements. Good sense of rhythm to sync transitions with the provided music. Please include examples of similar slideshow or event videos you have created in your proposal. Deliverables: Final video in high quality (1080p or 4K, MP4 format). One round of revisions if necessary. I look forward to seeing your proposals and creating a magical memory for my daughter's first birthday!

B2B Business Development Assistant for Construction Company

Business Development / Lead Generation – Construction Industry We are a construction company working across London and are looking for a UK-based Business Development Executive to join our team. Please note: Applicants must be based in the UK. Applications from outside the UK will not be considered. Main responsibilities * Contact architectural practices and freelance architects by phone and email. * Introduce our company and build professional relationships. * Help our company secure invitations to tender for construction projects. * Build new relationships with architects and maintain existing ones. * Assist with communication throughout the tender process when required. Full training and all the information you need about our company and services will be provided. We are not looking for someone who simply makes a large number of calls. We are looking for someone who can build relationships, communicate professionally and achieve results. Ideal candidate * Previous experience in Business Development, Lead Generation or Sales. * Experience working with construction companies or within the construction sector in a business development, sales or client-facing role would be an advantage, but is not essential. * Confident speaking to people on the phone and communicating professionally by email. * Professional, organised and motivated by results. What we offer * Work starting from approximately 5 hours per week, with the opportunity to increase hours over time depending on workload, results and mutual agreement. * Your working schedule will be agreed in advance. Calls and emails should be carried out during normal business hours. * Hourly pay plus performance-based bonuses. * A long-term opportunity for the right person, with increasing responsibility and earning potential as we build a successful working relationship. The hourly rate shown is a starting point. The final rate will depend on your experience, knowledge and the value you can bring to our company. When applying, please tell us: 1. Have you worked in a Business Development, Sales or Lead Generation role before? 2. Have you worked with construction companies or within the construction sector in a business development or client-facing role? 3. Why do you think you would be a good fit for this role?

Social media set up plus canva & mailchimp with LinkedIn

Clear-Rec Ltd – Complete Digital Marketing & Social Media Setup Brief (Free Version) Objective Create a professional, consistent online presence for Clear-Rec Ltd that promotes our education recruitment services, generates candidate registrations and school enquiries, and allows all marketing channels to work together using free software wherever possible. ⸻ 1. Branding Use the same branding across every platform. Create: * Company logo * Profile picture * Cover/banner image * Brand colours * Brand fonts Create Canva templates for: * Job adverts * Candidate profiles * Client testimonials * Recruitment tips * School support information * Company updates * “We’re Hiring” graphics * Meet the Team * Candidate of the Week * School Vacancies * Success Stories Free software: * Canva Free ⸻ 2. Website Website: www.clear-rec.co.uk Check: * Contact forms * Mobile optimisation * SEO * Google Maps * Candidate registration * Employer enquiry form * CV upload * Privacy Policy * Cookie Policy Connect with: * Google Analytics * Google Search Console Free tools: * Google Analytics * Google Search Console ⸻ 3. Create & Optimise Social Media Create and fully optimise: * LinkedIn Company Page * Facebook Business Page * Instagram Business Account * TikTok Business Account * YouTube Channel * Google Business Profile Every account should include: * Company logo * Matching banner * Business description * Website: www.clear-rec.co.uk * Phone: 07920 480812 * Business email * Consistent branding * Call to Action * Keywords around Education Recruitment and School Support Recruitment ⸻ 4. Connect Everything Together Connect Facebook and Instagram through Meta Business Suite. Link: * Facebook ↔ Instagram * Instagram ↔ Threads (optional) * LinkedIn ↔ Website * TikTok ↔ Website * YouTube ↔ Website * Google Business ↔ Website ⸻ 5. Free Social Media Scheduling Use: Meta Business Suite (Free) Schedule: * Facebook * Instagram Use: LinkedIn Native Scheduler (Free) Schedule LinkedIn posts. Use: TikTok Scheduler (Free) Schedule TikTok videos. Use: YouTube Studio (Free) Schedule YouTube videos and Shorts. This means every platform can be scheduled for free without paying for Hootsuite or Buffer. ⸻ 6. Email Marketing Create: * Mailchimp Free Account Set up: * Candidate mailing list * School mailing list * Temporary staff list * Permanent recruitment list Create automated emails: * Welcome email * Candidate registration confirmation * School enquiry acknowledgement * Monthly newsletter * Job alerts ⸻ 7. Google Business Create a Google Business Profile. Include: * Services * Photos * Opening hours * Website * Phone number * Reviews * Regular updates ⸻ 8. Content Plan Create a monthly content calendar. Aim for: * 3–5 LinkedIn posts each week * 3 Facebook posts each week * 3 Instagram posts each week * 2 TikTok videos each week * 1 YouTube video or Short each week Content ideas: * Latest vacancies * Recruitment tips * School support roles * Candidate success stories * Testimonials * Interview advice * Compliance guidance * Behind the scenes * Meet the team * School business manager insights * Finance, HR and administration recruitment * Facilities, catering and cleaning recruitment * Education news ⸻ 9. Graphics Design branded templates for: * Drama vacancies * Teaching Assistant jobs * School Business Manager jobs * Finance vacancies * HR vacancies * Admin vacancies * Cleaning vacancies * Catering vacancies * Site Manager vacancies Use Canva Free. ⸻ 10. SEO Optimise your website for keywords such as: * Education Recruitment * School Support 13. Free Software to Use * Canva Free – graphics * Meta Business Suite – Facebook & Instagram scheduling * LinkedIn Scheduler – LinkedIn scheduling * TikTok Scheduler – TikTok scheduling * YouTube Studio – YouTube scheduling * Mailchimp Free – email marketing * Google Analytics – website analytics * Google Search Console – SEO monitoring * Google Business Profile – local visibility * Google Drive – document storage *

Premium Longevity supplement

Premium Shopify Website & Landing Page Designer Needed (Supplements / Longevity Brand) We’re looking for an experienced web designer/developer to build a premium Shopify website for our longevity supplement brand, Gevity Labs, along with a high-converting standalone landing page for paid advertising. The website should have a luxury, science-led aesthetic similar to brands such as AG1 and Timeline, while remaining unique to our brand. Requirements: * Premium Shopify website design and development * High-converting landing page for Meta, Google and TikTok traffic * Subscription functionality * Bundle builder / bundle offers * Upsells and cross-sells * Optimised checkout experience * Mobile-first responsive design * Fast loading speeds * Excellent UX/UI * SEO best practices implemented throughout * Structured to target both UK and US organic traffic * Keyword research and on-page SEO optimisation * Clean, scalable build that is easy for our team to manage Ideally you have experience working with health, wellness, supplement or premium e-commerce brands and understand conversion rate optimisation (CRO). When applying, please include: * Links to 3-5 Shopify websites you have personally designed and built (live examples only) * Examples of high-converting landing pages you’ve created * Any supplement, wellness, beauty or healthcare brands you’ve worked with * Your estimated timeline * Your proposed cost * A brief explanation of how you approach SEO and conversion optimisation Applications without previous website examples will not be considered. We’re looking for someone we can build a long-term relationship with as our brand continues to grow. Bonus if you have experience designing websites that achieve strong conversion rates (4%+) and have worked on subscription-based Shopify brands.

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.

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.

CONTRACT LAWYER — CONTRACTOR AGREEMENT (FEE & IP)

CONTRACT LAWYER — CTO CONTRACTOR AGREEMENT (FEE & IP) Role: Freelance solicitor/contract lawyer. Review and/or draft a contractor agreement. WHAT WE NEED We're hiring a CTO-track contractor for a pre-seed tech startup. He's building our product for 12–18 months on a fixed fee basis. We need a UK solicitor to review a draft and make necessary changes. Standard scope: fee structure, deliverables, IP ownership, contractor terms, confidentiality. THE DEAL (FOR CONTEXT) Fixed fee over 12–18 months Contractor status: Not an employee IP: Everything he builds belongs to the company Duration: 12–18 months Title: Architect (CTO title/equity is separate, not part of this agreement) WHAT THE AGREEMENT MUST COVER Fee structure — Payment schedule over 12–18 months (fixed, not hourly) Scope of work — what he's building, deliverables, acceptance criteria IP ownership — all work product belongs to the company Confidentiality & NDAs — standard founder protection Contractor status — clear that he's a contractor, not an employee Termination — notice periods, what happens on early exit Insurance & liability — basic contractor protections Term & renewal — how the 12–18 months works, any extension mechanics YOUR BACKGROUND (MUST HAVE) ✓ 5+ years contract law or commercial law experience ✓ UK contractor agreements (not employment, not M&A) ✓ IP assignment clauses — you know what actually protects the company ✓ Contractor vs. employee status — clear, defensible language ✓ Understanding pre-seed / pre-product start ups ✓ Comfortable with ad-hoc work (review or draft) Would be ask advantage to have experience with AI tech start ups.

Full-Stack Developer for Business Operations

Summary Project Overview We are a manufacturing company with our own delivery fleet, supplying our products to customers across the island. We are looking for an experienced developer (or small team) who can analyze our existing workflow and build a modern solution to automate and simplify our operations. Our Current Workflow 1. Customers place their orders via WhatsApp, usually one day before delivery. 2. A staff member manually copies every order from WhatsApp onto paper. 3. Orders are grouped by delivery region. 4. The processing department receives the handwritten orders and prepares the products for each region. 5. Once processing is completed, invoices are manually created. 6. All invoices are written and handed to the drivers before deliveries. 7. At the end of the day, drivers return with payments collected from customers. 8. Payments (cash, cheque, or bank transfer) are then manually reconciled. Product Pricing & Weight Calculation We deal primarily in fresh chicken products, and our pricing is based on net weight (kg). However, customers may place their orders either by pieces (pcs) or kilograms (kg), depending on their preference. Each customer may also have their own negotiated pricing, so the system must support customer-specific price lists. During processing, the products are packed into crates before dispatch. Each crate has a different tare weight (typically 1 kg, 1.9 kg, 2 kg, 3 kg, or 4 kg). For example, if a customer orders 50 pieces of chicken, the order may be packed into 6 or 7 crates with varying tare weights. The processing staff records the gross weight and the tare weight of the crates, and the system must automatically calculate the net product weight (Gross Weight − Total Tare Weight). The customer is then invoiced based on the net weight, using their agreed price per kilogram. Order Complexity We currently manufacture and sell approximately 50 different chicken products. The system must support customers ordering any combination of these products in a single order. As our business grows, the solution should efficiently handle large multi-line orders while ensuring accurate order processing, production planning, invoicing, and delivery. The application should remain fast, reliable, and easy to use even when processing complex orders with many different product lines. Delivery Adjustments & Exceptions As we deal with fresh chicken products, the invoiced quantities may occasionally need to be adjusted during delivery. Some customers choose to verify the weight of the products upon receipt. If the measured weight is lower than the invoiced net weight, the driver contacts the office and the invoice must be adjusted so that the customer is charged only for the weight actually received. If the delivered weight is higher than the invoiced weight, no adjustment is required. In addition, there are occasions where a driver may inadvertently leave one or more items at the factory. In such cases, the driver contacts the office from the customer's location, and the missing items must be removed from the invoice so that the customer is billed only for the products that were successfully delivered. The system should make these delivery-time adjustments simple, fully traceable, and synchronized with the final invoice and payment records. Our workflow involves many real-world operational exceptions that cannot always be anticipated. We are looking for a developer who can design a flexible system capable of handling these scenarios without requiring manual workarounds or software changes each time a new business rule arises. While this process works, it requires a significant amount of manual work, duplicate data entry, printed paperwork, and repetitive administrative tasks. What We Are Looking For We are looking for someone who can study our workflow, understand our business processes, and propose a modern, scalable solution. We are open to suggestions if there are better ways to improve our operations.

Next.js Developer Needed – Headless WordPress (Vercel Deploy)

Development: Full Stack / Frontend 1. Project Description We're looking for an experienced developer to build a modern, fast-loading website using a decoupled (headless) architecture. This is not a traditional WordPress theme build we want a custom-coded frontend that pulls content from WordPress as a backend CMS only. 2. Tech stack requirements: The frontend should be built in Next.js using the App Router, with server-side rendering for performance and SEO. Styling should use Tailwind CSS (utility-first, no separate handwritten stylesheets). Fonts should be optimized using Next.js's built-in font system (self-hosted Google Fonts, no external font requests). Images need to run through Next.js's built-in image optimization so files are automatically resized/compressed on delivery. The site should be deployed on Vercel. Error/performance monitoring should be set up via Sentry so we get visibility into production issues. On the content side, we want WordPress set up purely as a headless CMS on a separate subdomain used only to manage content (text, images, blog posts, pages, etc.) through the WordPress dashboard, with no public-facing WordPress theme or frontend. The Next.js app should fetch this content via the WordPress REST API or WPGraphQL. 3. What we need from you: Please share examples of past projects where you've built a Next.js frontend decoupled from a headless WordPress backend. Let us know your experience with Tailwind CSS, Vercel deployment, and Sentry integration. We'd also like to understand your typical process for structuring content models in WordPress so they map cleanly to a custom frontend. 4. Project scope: Build a CMS-managed marketing website from an existing Figma design a standard brochure/lead-gen site (WordPress or equivalent), fully editable by our team afterward. Pages/templates: Home (hero, packs preview, process steps, gallery preview, testimonials, Instagram feed, CTA); Pack template (reusable, CMS-addable, with pricing, specs, gallery, FAQ); About; Examples (portfolio gallery); Project template (reusable case-study CMS post type, with gallery and related projects); Terms template (reusable for legal pages); Contact (enquiry form + map); Send an Enquiry (consultation booking form + map); site-wide responsive navigation. Requirements: All content editable via CMS, no dev needed. Pack and Project templates must be repeatable CMS entries. Both forms submit to email/CRM. Fully responsive, matching Figma exactly. Out of scope: No custom API/booking integrations, no custom backend. 5. Deliverables Fully responsive site matching the above stack, deployed and live on Vercel, with WordPress CMS configured and documented for our team to manage content independently going forward. 6. Budget To be agreed --- ** We do not accept spam you must quote "I WANT THIS JOB" at the top of the application

urgent

KeyShot Specialist – Plastic Material & Lighting Setup Expert

PROJECT DESCRIPTION We are an established sports equipment brand looking for a KeyShot expert to help us move a set of product renders from a flat, CAD-preview look to true photographic realism, suitable for front-of-pack hero imagery. This is not a standard production render job. We are specifically looking for someone who can develop and dial in the right material, texture, and lighting settings on one or two sample models, then hand over the complete settings package so our existing rendering supplier can apply the same look across our full product range in their own copy of KeyShot. The product is a small, moulded plastic item with subtle translucency. Getting that material quality right is the crux of the brief. We should also mention that our full product range is already set up and organised within KeyShot. Ideally, whatever material presets and lighting rig are developed through this engagement could be applied across that existing setup without having to rebuild or re-import each product individually. If you have experience structuring KeyShot material libraries and scene rigs in a way that makes them portable and easy to apply at scale, please mention this in your response. We will share full project details, reference images, and the CAD model (STEP format) with the shortlisted candidate under a mutual NDA before work begins. WHAT WE NEED FROM YOU BEFORE WE SHORTLIST Rather than a standard cover letter, please answer the following five questions. Your answers will carry more weight than your portfolio in our decision. Honest, specific answers are far more useful to us than vague ones. 1. Which version of KeyShot do you work in, and how long have you been using it professionally? 2. When rendering a soft, slightly translucent plastic (such as a sports mouthguard, silicone grip, or similar), which material type or shader do you use in KeyShot, and what are the two or three settings you pay most attention to in order to get that quality right? 3. How do you approach lighting a small plastic product for a front-of-pack hero shot? Describe your typical setup, including how you use (or choose not to use) an HDRI environment. 4. Once a look is approved, how would you package your settings so that another KeyShot user on a different machine could replicate the result? What files would you provide, and how would you structure those settings so they could be applied across a pre-existing library of models in KeyShot, rather than being tied to a single scene file? 5. Please share one or two examples of previous work involving plastic, rubber, or similarly translucent materials. Links are fine. BUDGET AND TIMELINE Fixed price preferred. To be agreed once we have shortlisted. This is a focused, bounded piece of work rather than an ongoing contract.

opportunity

AI Video Artist Needed – Photorealistic Cinematic Sequences

Looking for an experienced AI video artist with strong experience using Google Veo, Kling AI, Runway, Pika and related cinematic AI tools to create approximately 12 photorealistic video sequences for a feature film. We're looking for an experienced AI video creator to collaborate on a feature film project. The role involves creating approximately 12 cinematic AI-generated video sequences, each between 30 and 350 seconds in length, using two live-action cast members as the basis for the scenes. This is not a typical social media or marketing project. The goal is to produce photorealistic, cinematic-quality footage suitable for integration into a professionally produced feature film. Experience with some or all of the following is preferred: Kling AI Google Veo Runway Pika Midjourney Nano Banana (or similar image-generation workflow) Topaz AI ComfyUI (advantageous) Adobe After Effects / DaVinci Resolve for compositing and finishing Ideally, you'll have experience creating: Photorealistic human performances Consistent characters across multiple shots Cinematic camera movement High-quality environment generation Professional compositing and integration Please send: Examples of your best AI video work The software and workflow you use Your estimated turnaround time Your day rate or project rate Any experience working on film or television projects This is potentially the first stage of a much larger collaboration, with additional sequences planned as the project develops. Please only apply if your work is genuinely cinematic and photorealistic. Please read before applying Please write your proposal yourself. Generic AI-generated responses or copy-and-paste applications make it difficult to identify suitable candidates and are unlikely to be considered. To help us shortlist applicants, please include the following in your response: 1. Which AI video tools do you use most? (e.g. Kling, Google Veo, Runway, Pika, ComfyUI, etc.) 2. Have you created photorealistic videos longer than 30 seconds with consistent characters? 3. Have you integrated AI-generated footage with live-action footage? 4. Please include links to your three strongest examples of cinematic AI work. 5. In a few sentences, explain why you think you're the right fit for this project. Applications that clearly demonstrate relevant experience and have been written personally will be prioritised. Budget to be confirmed.

opportunity

Adult Creator Lead Researcher for Direct Fan Messaging App

We are looking for a creator outreach / lead research specialist to help us find adult-friendly content creators for a new direct fan messaging app. The app is built for creators who want to communicate directly with their fans, monetize private conversations, and keep more control over their audience — without fans feeling like they are talking to an agency, bot, or fake operator. We are looking for creators from platforms and communities such as: * OnlyFans * Fansly * Fanvue * Webcam creator communities * Instagram * X/Twitter * TikTok * Reddit creator communities * Link-in-bio creator profiles * Adult-friendly influencer communities Your main task will be to find qualified creators and build a clear lead list. For each creator, we need: * Creator name / handle * Country or language if visible * Platform links * Main social profile * Contact method * Follower count if available * Creator type: OnlyFans, Fansly, webcam, Instagram, etc. * Notes on why they could be a good fit * Whether they seem suitable for direct fan messaging You may also help with outreach using our approved message, but the first priority is high-quality research and lead generation. Important rules: * Only 18+ creators. * No minors or questionable accounts. * No scraping private information. * No fake reviews. * No spam. * No misleading messages. * No pretending to be an independent user. * Respect the rules of every platform, subreddit, group, and community. Ideal candidate: * Experience with influencer research, creator outreach, adult creator recruitment, webcam creator research, or social media lead generation * Comfortable working around adult/NSFW creator communities * Good English * Able to work independently * Able to provide clean daily updates in a spreadsheet * Knowledge of OnlyFans, Fansly, webcam, Reddit, X/Twitter, Instagram, TikTok, Telegram, Discord, or Facebook creator groups is a plus First test milestone: Please quote your price for: * 100 qualified creator leads * 20 relevant communities, groups, forums, or subreddits where creators can be found or researched * 20 manually contacted creators using our approved outreach message * A short report explaining which markets look most promising and why When applying, please answer: 1. Have you done creator or influencer outreach before? 2. Have you worked with adult/NSFW creators before? 3. Which platforms would you use to find creators? 4. Which markets do you know best? USA/UK, Latin America, Romania/Eastern Europe, or other? 5. How many qualified creator leads can you find per day? 6. Can you contact creators manually and track everything in a spreadsheet? 7. Do you understand that we do not want spam, fake reviews, fake testimonials, or rule-breaking outreach? 8. What is your price for the first test milestone?