Freelance Jobs

Google Apps Script to check Google Sheet for cell colour

Hi, I have a client working in food preparation who stores dry food and frozen food to make meals. The expiry dates of the food is important and they need to avoid waste. I need a Google Apps Script to check a Google Sheet for the background colour of cells in two columns that turn red (using conditional formatting) when the expiry date of the product is soon. This tells the client which ingredients to use first when making meals. I would like the script to send an email if one or more of the product lines has a red background colour (indicating its imminent expiry). An example sheet (read-only) is available below: https://docs.google.com/spreadsheets/d/1BtdLG63l8nB2ppYcbLMknYN8PqdHmspIv9J6gPN3HB8/edit?usp=sharing Ideally, the email will show the following: Email subject example (taken from Cell E2): "Restaurant Food Stores" Expiry Dates Email body example in html table format: Section Item Name Batch Serial No. Exp. Date Dry 7 Flour 12345 11-02-26 Dry 7 pasta 1 asdfg 16-01-26 Dry 7 milk powder 12345 11-02-26 I look forward to hearing from you, Kindest regards Nick

opportunity

Graphic Charter

Brand Guidelines Development Brief The Landlord About The Landlord The Landlord is a high-end hospitality brand rooted in a refined lifestyle and a strong attention to detail. The brand operates at the intersection of hospitality, service excellence, and contemporary living. We are now entering a new phase of expansion through a franchise model, which makes visual consistency and brand clarity critical across all markets. Each franchise operates locally while carrying the same brand promise. To support this growth, we are looking to develop a complete, structured, and replicable brand guideline that can be deployed consistently across all physical and digital touchpoints. Objective of the assignment The objective is to create a comprehensive and operational brand guideline that will serve as a reference document for all current and future franchisees. This guideline must allow each The Landlord entity to express the brand with coherence, elegance, and precision, while preserving the emotional and aesthetic codes that define our brand DNA. The guideline should be practical, clear, and easy to use, enabling independent teams to apply it correctly without external supervision. Scope of work The selected agency will be responsible for designing and delivering a complete brand guideline, covering the following areas: Visual identity system Define clear rules for logo usage and placement across all supports, including: Brand extensions (TLL Franchises, TLL Manager, TLL Loyalty Program, TLL Platinum) Bedding and linen (pillowcases, sheets, duvets) Bath towels and spa linen Staff uniforms (shirts, aprons, jackets) Stationery (business cards, menus, envelopes, letterheads) Signage (storefronts, plaques, pictograms, vehicle branding) Packaging (bags, labels, boxes) Color palette Definition of primary and secondary colors Authorized shades and variations Color references (Pantone, CMYK, RGB) Recommended color combinations and contrasts Typography Primary and secondary typefaces Typographic hierarchy (titles, subtitles, body text, captions) Practical usage examples across print and digital formats Iconography and illustrations Definition of a consistent illustration style (minimal, linear, pictogram-based) Creation of an icon system covering hospitality services (reception, breakfast, spa, amenities, services) Guidelines for image and illustration treatment (line weight, spacing, visual tone) Photography direction Artistic direction (lighting, mood, subjects, composition) Storytelling approach aligned with a luxury hospitality universe Visual moodboard Image treatment recommendations (retouching, filters, grain, saturation) Examples of visuals adapted for social media, website, and printed materials Tone of voice and brand language Definition of the brand tone (warm, refined, intimate, elegant) Key vocabulary and preferred lexical fields Do’s and don’ts for brand expression Message examples for social media, email signatures, and printed materials Digital applications Design templates for: Instagram feed and stories Facebook publications LinkedIn posts and banners Layout grids and composition rules Logo, typography, and color integration guidelines Examples of carousels, stories, and short-form videos Printed materials and physical applications Complete stationery system (business cards, menus, envelopes, notebooks, labels) Uniform design guidelines and logo placement Linen and bedding specifications (materials, embroidery, positioning) Branded objects and promotional items Deliverables A complete brand guideline document (digital format) Fully structured, clear, and ready for franchise deployment Visual examples and practical use cases for each section Expected timeline and proposal We kindly ask interested agencies to provide: A detailed proposal outlining their methodology and approach A production timeline with milestones A cost estimate for the full scope of work Relevant references, ideally within hospitality, luxury, or franchise networks

Data scraping needed

I have several directories I need to obtain contact information from... Can anyone help me? I will have all the sites for the person who will help!

NLP Chunking Tokenisation Vectors and Queries

I am looking for an end to end solution using NLP and learning engine for 2 entity matches based on text and specific elements in the text. Any ideas, Mark

Virtual Assistant (Marketing Admin) — Remote | Healthcare Tech

We’re a growing healthcare tech company looking for a highly reliable, detail-oriented Virtual Assistant / Marketing Admin to support our marketing operations and client coordination. This is a remote, long-term freelance opportunity with consistent weekly hours for the right person. • Minimum: 10 hours/week (guaranteed for the right candidate) • Potential: up to 40 hours/week as you ramp up and prove performance • Rate review: after 2 months, with an increase based on performance Who this is for You’ll be a great fit if you’re a full-time freelancer (or have meaningful weekday availability) who can operate in UK working hours (9am–6pm GMT) and help on-demand when needed. Requirements (must-have) • Native English speaker with clear, concise, professional business writing • Able to adapt to UK working hours (9am–6pm GMT) with some on-demand availability • If you’re already working full-time for other clients during the day, this likely won’t be the right fit • Highly reliable, punctual, trustworthy, and consistently meets deadlines • Previous experience as a VA / project assistant / marketing assistant • Excellent attention to detail Key responsibilities Your regular work may include: • Research-oriented tasks (market, competitors, prospects, content, tools) • Sending outbound messages via LinkedIn Sales Navigator and/or email • Coordinating with team members across design, development, and marketing • Creating marketing banners/videos using Canva and/or Figma • Communicating requirements between clients and our internal team • Organising schedules, deadlines, meetings, and follow-ups • Uploading/scheduling daily content (social media + YouTube) • Copywriting (short-form + longer-form as needed) • Editing video transcripts • Editing blog posts and checking for SEO guideline compliance • Finding relevant images to support content • Writing weekly marketing emails • Extracting data for monthly marketing reports • Liaising with content creators and external collaborators • Bonus: experience with Asana or Trello Hiring process We’ll shortlist several candidates and run a paid test project. If you pass, this can become a strong long-term partnership with increasing hours and responsibilities. How to apply Please include the following in your application: 1. Full name 2. Where you are based (city + confirm you can adapt to UK timezone) 3. Relevant tasks/projects you’ve worked on + your current availability (hours/week + typical working hours) 4. Your favourite non-work activities 5. One work-related problem you solved that you’re proud of (briefly explain the situation + outcome) 6. Links or examples of previous relevant work (if applicable) 7. A 1-minute selfie video introducing yourself and sharing a bit more about you

3D product explainer video

I am looking at creating a similar video to this for my outdoor furniture cover, and looking more a more photo realistic finish (this example looks very animated). Could you please provide a quote for 1 minute and 30 seconds video, using the example below as a base: https://www.youtube.com/watch?v=FtUvHzanQ-U I may be able to provide the 3D model file of the furniture itself, but please quote twice (one with creating the 3D file, and one with me supplying it). Please provide examples of photo and hyper-realistic videos, outside setting would be beneficial to being awarded the project. Many thanks

TILE DESIGN FOR ONGOING COMPETITIONS - CANVA TEMPLATE

Good morning, I'm looking for someone to create me a 1:1 and portrait (for reels) template for our competitions. I need the format to be exactly the same and something I can have built in canva that I can easily edit dates and so on. The footer will be our logo, website and tag line, but I need a high quality template that is much better than I have currently. It will need to be in the style of our exising website and something I can lay text onto and imagery and background. It is a relatively small project, but I'm looking for someone to assist with ongoing updates to artwork

Localization QA & UX Tester for KYC (German & Spanish)

We are looking for two experienced QA Specialists—one native German speaker and one native Spanish speaker—to conduct an immediate audit of our mobile app's registration and KYC (Know Your Customer) process.

opportunity

Looking for a Framer expert

Hi I am looking for a Framer expert to take a Framer template, make some very minor changes and publish the site for me on my domain. Please message me with any questions. *place holder price

Google Maps Optimization Expert Needed (GMB/Local SEO)

We’re looking for an experienced Google Maps / Google Business Profile (GBP) Optimization specialist to improve our local ranking, visibility, and lead generation through Google Maps. The goal is to optimize our Google Business Profile fully, fix any current issues, and implement a strong strategy to help us rank higher in local searches. Objectives / Expected Outcome Improve ranking in Google Maps Pack (Top 3 results) Increase profile visibility, calls, direction requests, and website clicks Optimize GBP for targeted local keywords and service areas Ensure the profile follows Google guidelines (safe + sustainable strategy)

Flutter app - repost 2 due to christmas

ENGAGEMENT TYPE Hourly (Time & Materials) Estimated effort: 22–26 hours total Start: Immediate Level required: Senior / Very Senior Flutter Developer ONLY WHAT THIS JOB IS (READ CAREFULLY) This is a small, precise repair task in an existing Flutter app. There is no greenfield work involved. There will be: No new features No refactors No architecture changes No redesigns No experiments No “suggested improvements” No “I found another bug” unless it can be reproduced locally You are fixing known, clearly scoped issues only. IMPORTANT BACKEND & API CONTEXT (NON-NEGOTIABLE) All APIs and server-side code have been working as late as December 2025. A full Postman collection exists and can be executed at any time to verify API functionality. The backend is Magento 2.4. No backend work is required. No Magento developer work is required. Stripe APIs are live and working. This task is Flutter-only. Any attempt to reframe this as a backend, API, or Magento issue is incorrect. REQUIRED SKILL LEVEL (MANDATORY) You must be: A Senior or Very Senior Flutter developer Comfortable fixing Stripe and Apple Pay issues in production apps Able to read existing code and fix it without rewriting it Able to work independently without supervision If you are not senior, do not apply. NON-NEGOTIABLE ENGINEERING RULE Never update Flutter, packages, or plugins before the existing code is confirmed working. This is a basic rule, yet one that many so-called “senior” developers still get wrong. IMPORTANT CONTEXT (PLEASE READ) The app already compiles. A previous developer requested payment before automated tests were run. That is not acceptable under PPH standards. Testing comes first. Payment comes after. For this reason, the previous contract was terminated. This is shared for clarity so expectations are fully aligned. APPLICATION FILTERS (STRICT) If you present web pages as Flutter references, you are not of interest. If you have no verifiable references, you are not of interest. If you describe yourself as a “full-stack developer”, you are not of interest. If you over-explain, bloat, or try to over-engineer, you are not of interest. I am looking for a specialist, not someone who knows a little about everything. This is a razor-sharp task. Change existing code. Nothing more.

Creating a new business

Looking for someone who is creative with experience who can generate own content as well as use content I have to create an Instagram page to target businesses who might want to rent arcade machines , fitness equipment or coffee machines for there business. Looking for someone who can start a new account and spend up to 8 hours a week creating an account and gaining follows

Guest Posting Platform

We are looking for an experienced guest posting professional to help source articles to be posted on our platform. The articles must be relevant to the platform niches of Digital Marketing, Digital Media & Digital News. Host Domain Information ============================================= ✔ Domain Rating (DR): 39 ✔ Trust Flow (TF): 31 ✔ Domain Age: 18 years Article Information ============================================= - The articles must be original - The articles must be of high quality - The articles must meet our content guidelines - The articles must be in English - The articles/posts will be permanent - Do-Follow links can be included in the article Fees & Other Information ============================================= * Fees will be agreed and paid per article * Any outside fees must be managed externally Other Information ============================================= ** NO link insertions ** NO links to Gambling, Betting, Casino, Gambling, Poker, Slot, lottery, Cannabis, Tobacco, Vaping, Guns/weapons, Pills, drugs, Supplements, Negative/defamatory contents, copyrighted contents and images, and adult-related contents or links.

INTERIOR DESIGN PROJECT Scalable coworking space within a hotel

INTERIOR DESIGN PROJECT SUMMARY (Anonymous | Scalable coworking space within a hotel) Project Type Interior fit-out of a coworking hub integrated into an existing hotel. No structural changes. Focus on furniture, lighting, acoustics, and zoning. Design Intent Create clear work zones using furnishings, lighting, soft finishes, and layout, not walls. The space should feel like a private members’ club, separate from the hotel atmosphere. ⸻ ZONE OVERVIEW (DESIGN-LED) ZONE 1: Deep Work Suite Use: Silent work area Design Focus: • Desk layout and spacing • Acoustic control • Task lighting • Minimal visual noise Key Elements: • 16 dedicated desks • Desk dividers / acoustic panels • Warm task lamps • Neutral, calm palette ⸻ ZONE 2: Social Atrium Use: Open work, calls, meetings Design Focus: • Flow and circulation • Noise control without solid walls • Clean, modern fitted pods Key Elements: • 16 hot desks • 2 phone booths (modern, integrated look) • 2 meeting rooms (glass, sound-treated) • Plants and soft finishes to break up space ⸻ ZONE 3: Member’s Club Kitchen (Former lounge) Use: Social hub, informal work, dining Design Focus: • Warm, residential feel • Kitchen as a design feature • Micro gym • Flexible seating Key Elements: • Central small solid oak table • Retrofitted existing counter into pantry • Integrated appliances (fridge, dishwasher, coffee machine, microwave, air fryer, ice machine) • Minimal lounge seating • Floor lamps and low coffee table Capacity: • 10 mixed seats • 8 gym core equipmemt ⸻ ZONE 6: Creator Studio / Silent Work Hall Use: High-density silent workspace Design Focus: • Acoustics • Lighting discipline • Uniform desk layout Key Elements: • 30 dedicated desks • Full acoustic treatment • Controlled lighting • No social or lounge furniture ⸻ DESIGN NOTES FOR ALL ZONES • No heavy construction • Use sound insulating flooring covers, lighting, plants, furniture, and acoustics to define zones • Hotel finishes to be softened, not removed • Scalable and repeatable design approach

opportunity

I need to build Tron Energy Rental Platform

I am launching an online platform where users can rent TRON energy exclusively as buyers. The core of the job is to design and build a web-based dApp that allows a visitor to: • See the current platform-set price for energy • Pay in cryptocurrency (TRX or other TRC-20 tokens) • Complete a purchase that automatically credits the energy to the wallet address provided • Review a personal purchase-history page • Set an optional “automatic purchase” rule that checks their wallet balance and tops it up when the threshold I define is met • And other features would be added as the project go on I already have the business logic and pricing model drafted; what I need is the full technical implementation—back-end, and a clean, responsive front-end that can be easily re-skinned. Familiarity with the TRON toolchain (TronWeb, TronLink wallet integration) will be benefitial. Deliverables will be: 1. Front-end dApp with wallet connection, purchase history table, and auto-buy settings panel and etc 2. Brief deployment guide and hand-over call If you have built on TRON before and can demonstrate secure coding, let’s discuss the milestones and look at your past work.

opportunity

Mobile App Development for IOS

The project has been developed at this stage, and I need to test and distribute the application internally. I need to get around 2-300 employees and customers to use the application. Note: Internal distribution specifies that only people with a secure link from me are allowed to download and install my application. Professional help is needed, and I cannot provide the developer enterprise program account required for distribution at present. Looking for an experienced developer and you need to have an apple enterprise account to work with for a long term project of at least 12 months. I need a long term internal distribution certificate for private distribution of my ios app

WEbsite design for my towbar business

I am seeking a skilled web developer to create an engaging and user-friendly website for my towbar business. The project entails designing a four-page WordPress site that effectively showcases our products and services. The ideal candidate should possess expertise in responsive design, ensuring seamless functionality across all devices. Key pages will include Home, About Us, Products, and Contact. Aesthetically pleasing visuals, intuitive navigation, and SEO optimization are essential components of this project. Please submit your proposals detailing your experience and approach to website development.

Remote Access Setup

I need help setting up remote access to my office server so I can access it from my laptop anytime, anywhere. Scope of work - Set up remote access to office server - Configure access settings for laptop connectivity - Ensure secure, reliable connection for server access Additional information I'm looking for someone who can guide me through the setup process smoothly.

Figma Design for MVP-0

I need to connect with a seasoned Figma designer who can craft beautiful web page designs efficiently. To ensure the best fit, I’d appreciate seeing a thoughtful proposal that outlines your approach. Looking forward to finding the right match for this project! See attached PDF for the detailed requirement.

I need some one that can make luxury safari content for 30 days.

1. PROJECT GOAL (VERY IMPORTANT) The goal of this project is to create high-end, editorial Instagram content for a luxury travel brand. This is not mass-market travel content. This brand represents curated, aspirational, refined luxury travel experiences. The content should: Inspire Build desire Feel calm, exclusive, and timeless Drive clicks to the blog via Linktree Think luxury travel magazine, not a travel agency or influencer page. 2. WHAT “HIGH-QUALITY CONTENT” MEANS What we DO want Cinematic video edits (slow motion, gentle pans, sunrise/sunset) Calm pacing (no fast cuts) Natural light, golden hour tones Clean, intentional compositions High-resolution visuals only Emotion-driven storytelling (moments, not lists) ❌ What we DO NOT want No flashy transitions No loud fonts or stickers No emojis in visuals No over-saturated colors No “cheap stock” feeling No sales banners or promotional graphics 3. VISUAL STYLE & AESTHETIC Overall look: Luxury Calm Minimal Editorial Color palette: White, black, sand, beige, muted greens No bright or neon colors Composition: Clean lines Balanced framing Space, depth, and atmosphere Nature-focused imagery 4. CONTENT TYPES — EXPECTATIONS REELS 7–15 seconds (maximum 20 seconds) Cinematic, slow, atmospheric Original or royalty-free audio Soft instrumental or natural sounds Vertical format (9:16 — 1080x1920) CAROUSELS 4–6 slides Combination of: Landscapes Detail shots Lifestyle moments First slide must stop the scroll STATIC POSTS Minimal Single strong image or subtle quote No clutter Text overlays only if extremely subtle 5. CAPTIONS — TONE OF VOICE Elegant Short Calm Aspirational Never sales-driven Examples: “Some journeys stay with you forever.” “Luxury is found in silence.” “Designed for unforgettable moments.” CTA should always be subtle: “Link in bio” “Save for later” 6. GEOGRAPHY & CONTENT ACCURACY Content must follow this structure strictly: Tanzania: Luxury safari & beach escapes Botswana: Honeymoon safari collection South Africa: Private safari lodges, Family-friendly luxury safaris Kenya: Hot air balloon safari escapes Do not mix destinations incorrectly. 7. VISUAL SOURCING Allowed: Premium editorial stock footage/images AI-generated visuals (only if ultra-realistic and high-end) Licensed content Not allowed: Low-quality stock Overused stock imagery Visible AI artifacts or unrealistic visuals 8. DELIVERABLES 30 Instagram posts (Reels, Carousels, Static) Captions included Ready-to-post formats Consistent luxury aesthetic across all content 9. SUCCESS CRITERIA The content is successful if: It feels like a luxury travel magazine feed It builds aspiration and trust It encourages clicks without hard selling 10. CREATIVE FREEDOM (WITHIN GUIDELINES) You are encouraged to: Suggest creative improvements Enhance storytelling Elevate visual quality As long as the luxury, calm, editorial direction is respected. FINAL NOTE (IMPORTANT — INCLUDE THIS) If the content does not feel premium, calm, and aspirational, it is not suitable for this brand.