Databases Projects

E-commerce Review count for Fabric Care Products (Germany)

We are looking for someone to help identify the number of online consumer reviews for selected fabric care products (e.g. fabric softeners, detergents,) across major German e-commerce websites We would expect you to deliver an Excel file with 4 columns: Product Name, Source (website), Number of Reviews for this product on this website, link to product on website. Fabric care products are household products specifically designed to clean, soften, scent, protect, or enhance textiles (clothing, linens, fabrics) during washing, drying, or post-wash treatment. For the purpose of this project, we include the following categories: : - Fabric conditioners / softeners (e.g. Comfort, Lenor) - Laundry detergents (liquid, powder, pods/capsules) - Dryer sheets / dryer fragrances Sources to include: start with major German e-commerce and retail websites such as Amazon.de, Galaxus.de, OTTO, and Kaufland (marketplace version). Then investigate key drugstore retailer such as dm-drogerie markt, Rossmann) and Müller; Finally have a look at price comparison websites like Idealo, and maybe (but rare) some retailers like REWE and Edeka. Having done this before it usually takes 2 days to complete for 1 country.

Google Drive to Google Sheets Automation

Project overview We are looking for a freelancer with experience in Google Sheets and Google Apps Script to help automate a data matching process. We currently manage a large real estate dataset (5,000+ entries), where each entry must be linked to a corresponding PDF file stored in Google Drive. The PDFs are already downloaded and named using a structured convention (based on property lot numbers). The goal of this project is to automate the linking process between the dataset and the PDF files. 3. Scope of work The freelancer will be required to: Access a Google Drive folder containing thousands of PDF files Extract: file names corresponding file URLs Generate a structured mapping table: Lot number → Google Drive link Integrate this mapping with an existing Google Sheets dataset Implement a solution to automatically match: dataset lot numbers PDF file links Ensure the solution is: scalable reusable for future datasets Optional (bonus): Directly inject links into the main dataset (without manual formulas) 4. Deliverables A working Google Apps Script solution A clean mapping table (Lot → Link) Automated or semi-automated matching system Clear instructions on how to reuse the solution 5. Tools / sources Google Sheets Google Drive Google Apps Script 6. Quality requirements Clean and efficient code No duplicate or incorrect mappings Accurate matching (lot number = file name) Solution must handle large datasets (5,000+ files) Easy to reuse for future cities/projects 7. Timeline Start: immediately Estimated duration: 1–2 days Fast delivery preferred 8. Budget Fixed price (to be proposed) Open to proposals based on experience 9. How to apply Please include: Your experience with Google Apps Script or similar automation Examples of similar work (if available) A brief explanation of how you would approach this task Estimated delivery time

opportunity

Dental Software Data Export – Digora X-ray

We currently use Digora for Windows (DwF 2.9), which stores patient radiographs in a proprietary database format. We are migrating to a new system and require all patient images to be exported and structured for future use. Scope of Work: Access the Digora software on our system (remotely) Export all patient records and associated X-rays Ensure each patient’s images are grouped correctly Convert/export images into standard formats (JPEG, PNG, or TIFF) Organise files into a clear folder structure: Example: Patient Name / ID X-ray 1 X-ray 2 Maintain data integrity (correct patient-image matching is critical) Requirements: Experience with medical/dental imaging software (Digora, CliniView, DICOM systems or similar) Strong understanding of file structures and data organisation Ability to handle large datasets carefully and securely Experience with legacy systems or database extraction is a plus Important Notes: The system does not support bulk export natively, so we are looking for someone who can: Either automate the export process Or implement an efficient semi-automated workflow Data confidentiality is essential (GDPR compliance) Deliverables: Complete export of all patient X-rays Structured folders organised per patient Images in a standard, accessible format Please include in your proposal: Relevant experience with similar projects Your proposed approach (manual, automated, or hybrid) Estimated timeframe

Custom Excel Rota and Job Allocation Tracker

Hi, I’m looking for someone to help me build a custom Excel rota and job tracker for our night shift cleaning team. We have around 36 colleagues and work on a weekly rota from Sunday to Saturday. I update the shifts manually every week. The rota changes every week as well, with everyone moving down one turn each week and the last person moving back to the top. We also use RDW shifts (overtime), which should still count as working shifts in the tracker. What I need is something simple, reliable and easy to use long term. The tracker should: * Allow me to update weekly shifts manually * Automatically calculate how many days each colleague is working each week, excluding OFF, A/L and Sick days * Automatically assign daily cleaning jobs only to colleagues who are working * Use a cleaning job list, which I can provide separately * Rotate jobs fairly across colleagues and not always start from the same job * Work day by day (Sunday, Monday, etc.), not just one single job column * Allow me to add or change jobs in the future and have the tracker update correctly * Include some kind of archive/history section so previous weeks can be kept saved * Be something that can continue to work long term over multiple years without needing to be rebuilt I would like the Excel file to stay simple and easy to use. Please let me know if this is something you can build, along with an estimated price and timeframe. Many thanks,

opportunity

Add grouping to a microsoft access report

I have a very simple Microsoft Access Report that I want to create It has one linked Excel table that I will update weekly I have created a MS Query Weekly Crew Sheet Query And then created a report to run off the Weekly Crew Sheet Query But when I add groupings it doesn't report any data I would like it to group the calls By Date By Operator and then sort each day by route order I currently have a version that looks like this but I want to simplfy the system Can you help and what do you recommend

opportunity

I need a comprehensive business dashboard

We are a HR, Health & Safety & Data Consultancy. We are growing, and I am sick of having a million processes and sheets, so we have moved over to google work space & I now want to bring everything together. We need the dashboard, but also the sheets behind it. I need to be able to put some of the sheets in folders for the team to access/complete, we need to pull billing data from within client folders, and the rest needs to be designed. I'll need hand-holding to use it too, so I need patient tech support here please :-) These are just my thoughts - if you have done this for other businesses and there are areas I haven't thought of please feel free to help me out with your thoughts. I'd like the look to reflect our brand and personality. Me and most of the team have raging adhd lol so I need someone with flair who can please make this bright, easy to use, dopamine hits with completed tasks/goals etc would be brilliant. Everything we do is

Ecommerce Data Entry Assistant Needed

I am looking for a reliable person to help with data entry for my project. The role involves entering product details, uploading images, and ensuring accuracy. Attention to detail and Ai skills required

Design an Excel Dashboard / Pivot Table

We have a profit sheet we use for each month for our Alloy Wheel Refurbishment and Trim Repair company- I would like a dashboard / Pivot Table to bring all these together to show our yearly income and expenditure all broken down.

opportunity

I need an Airtable Expert to set up bases and forms

I am looking for an Airtable freelancer to help build out an Airtable system for my business. I already have an Excel spreadsheet prepared which sets out the table names, column headings, and notes on the field types and relationships. Based on that, I need someone to build the structure properly in Airtable and make sure it is clean, practical, and easy to use. The scope is broadly as follows: *Create around 20 Airtable tables *Set up the fields for each table based on my Excel specification *Use the correct field types where relevant, including linked records, single select, multi select, free text, long text, dates, checkboxes and similar *Import information into some tables where required *Leave some tables blank where specified *Create 8 to 9 Airtable FORMs linked to selected tables so I can quickly submit or update information without going directly into the base each time *Create around 5 email alerts / automations triggered by specific changes, such as a new record being added or a status being changed (I will specify) Create 3 or 4 dashboards within Airtable so I can view and work with selected data across multiple tables I will provide: *The Excel file showing the table structure and field headings *Notes on which fields should be linked, free text, select fields etc. *Details of which Workspace, Base and Table each item belongs in *Details of which tables need data added and which should remain blank *Guidance on the forms, alerts and dashboards I want What I need from you: *Build the setup directly in Airtable *Keep naming clear and consistent *Make sensible recommendations if anything in the structure could be improved *Test the setup before handover so the linked fields, forms, automations and dashboards all work properly *Provide a short handover note or quick walkthrough video so I can manage it afterwards *Include minor revisions after initial delivery if needed *Provide the direct URLs for each form created *Provide the direct Airtable URLs for each relevant table / view so I can access them easily afterwards Please reply with: *Your Airtable experience *Examples of similar Airtable work you have done, especially bases with linked tables, forms, automations and dashboards/interfaces *Your estimated turnaround time *Your proposed fixed fee Note that I will need to send an NDA to the select consultant in order to cover provision of sensitive data.

Data scraping

I require an experienced data researcher / scraping specialist to extract high-quality, niche-specific data from multiple UK sources and deliver it in a clean, structured format. This is not a bulk scraping job — accuracy and relevance are critical. Scope of Work: 1. Target Data (Initial Focus) I am looking to build lists for the following niches: • Property investors (Buy-to-Let, HMO, developers) • Company directors in property-related businesses • Business owners suitable for commercial finance ⸻ 2. Data Sources You may use a combination of: • Companies House (via SIC codes & director data) • Property-related platforms (where legally accessible) • Public directories • LinkedIn (Sales Navigator filtering – manual research, not scraping if restricted) • Other compliant UK data sources ⸻ 3. Required Data Fields Each record should include (where available): • Full Name • Company Name • Role (Director / Owner) • Email Address (verified where possible) • Phone Number (if available) • Location (UK-based) • Industry / SIC Code • Notes (if relevant, e.g. property investor / developer) ⸻ 4. Data Quality Requirements • UK-based contacts only • No duplicate entries • No generic or irrelevant businesses • Data must be accurate and up-to-date • Avoid scraped junk or low-quality lists ⸻ 5. Compliance (VERY IMPORTANT) • All data must be sourced from publicly available or compliant sources • Must comply with UK GDPR guidelines • No illegal scraping or data extraction methods • No use of prohibited LinkedIn automation tools ⸻ 6. Output Format • Excel / Google Sheets • Clearly structured columns • Clean, ready for outreach use ⸻ 7. Initial Volume • Phase 1: 4000-5000 high-quality leads • Potential for ongoing weekly/monthly work ⸻ Ideal Candidate: • Experience with UK data sourcing (Companies House, etc.) • Strong data cleaning and validation skills • Familiar with B2B lead generation • Understanding of property / finance sector is a plus • Able to suggest better data sources (not just follow instructions) ⸻ Budget & Timeline: • Open to proposals based on quality • Looking to start immediately • Ongoing work available for the right person ⸻ To apply, please include: • Examples of similar data projects • Tools you use for sourcing and verification • Your approach to ensuring data accuracy ⸻ Start your proposal with: “Quality over quantity — understood” ⸻ Additional Notes: This project is focused on building a long-term data pipeline for targeted outreach campaigns. I am looking for someone reliable who can consistently deliver high-quality results.

One-Hour Clay Setup to Enrich Company Contacts

I am looking for a freelancer with strong hands-on Clay experience to set up a Clay table within my own Clay login. If you're experiened using Clay then you'll know this is a 1 hour job max. The goal is to take a list of companies and company URLs that I provide, upload them into Clay, and then enrich those companies with the following contact-level information: Person full name Job title LinkedIn URL I will also provide a list of target job titles that Clay should search for against the companies and URLs supplied. Important requirement: The output must not remain as multiple contacts trapped inside a single Clay cell or nested result. I need the workflow set up so that each matched person becomes its own row. The final output should be in this structure: Company Name | URL | Person Full Name | Job Title | LinkedIn URL So, for example, if Clay finds 20 matching contacts for one company, I do not want "20 contacts found" sitting in one row or one cell. I need those 20 contacts expanded into 20 separate rows. Scope of work: *Set up the Clay table in my account *Upload the company names and URLs I provide *Configure the search/enrichment using the job titles I provide *Ensure the workflow expands contact matches into separate rows *Test the setup first on around 10 records only, so we do not waste Clay credits *Once the test is confirmed working, run the full process *Record your screen showing the exact process you used in Clay Screen recording requirement: Once completed, I would like a clear screen recording showing the exact workflow you used in Clay. This can either be: *a full example search from start to finish, including turning found contacts into separate rows, or *the actual working process used on my table The video should be clear enough that I can repeat the process myself later.

Greek-Speaking Looker Studio Expert

Project Title: Development of a Live Dashboard in Looker Studio (Sales & Targets Tracking) Mandatory Requirement: We are looking for a collaborator who is a fluent Greek speaker. Project Description: We are seeking an expert to provide full visualization of data sourced from Google Sheets into Looker Studio. The goal is to create a comprehensive dashboard that allows for automated data aggregation and real-time analysis based on: Sales Agent (Agent) & Product Category: Grouping performance by individual team members and specific product types. Row Status: Filtering and displaying data based on the specific "Status" column in the Google Sheet. Dynamic Time Periods: Implementation of interactive filters for daily, weekly, and monthly views. Key Deliverable: The core requirement is a comparative analysis of Actual Performance vs. Monthly Targets (Actual vs. Target) per category and per agent. Technical Requirements: The dashboard must be fully interactive. Use of Scorecards for high-level KPIs. Use of Trendlines to visualize real-time progress throughout the month. Ensuring seamless, live data synchronization between Google Sheets and Looker Studio. Application Requirements: Please provide a cost and time estimate for this project. Additionally, kindly share a relevant portfolio of similar dashboards you have developed.

opportunity

Shift planning / Rota management

I need to create a spreadsheet / database which we put all of our staff onto, we need to see which staff are available (depending on what they want to work) who is confirmed booked for a shift and who is proposed for one. Many thanks,

Data Engineer(Salesforce CRM)

We are looking for an experienced Data Engineer to help clean, standardize, and structure large volumes of real estate and regulatory compliance data. This role focuses on transforming messy, inconsistent datasets into a reliable and scalable data foundation that supports reporting, compliance tracking, and future automation. You will work closely with our business and technical teams to understand data logic, resolve inconsistencies, and design a clean, structured data environment. Responsibilities -Review and analyze existing datasets (leases, units, tenants, occupancy, rent, compliance) -Identify inconsistencies, duplicates, and missing or conflicting records -Standardize naming conventions, unique IDs, and relationships -Clean and transform data from spreadsheets, CSVs, and system exports -Build master datasets for properties, units, tenants, and leases -Develop repeatable data-cleaning workflows or pipelines -Implement data validation and quality checks -Create documentation (data dictionary, mappings, business rules) -Generate exception reports for data issues requiring review Required Skills -Strong experience with SQL and Python -Experience with ETL / data transformation workflows -Solid understanding of data modeling and relational databases -Experience cleaning messy, multi-source datasets -Strong knowledge of data validation and data quality practices -Ability to work independently and communicate clearly

Sharepoint setup for medical device startup

I’m working for a very small medical device startup (2 employees). I have recently set up our Microsoft 365 business platform and have been struggling with sharepoint and power suromateyfor the last couple of days to set up a strong document review and approval Workflow for our quality management system. Gratful for a call back to dicuss how we might be a belt I work together, Thanks in advance, Basil