
Closed
Posted
Paid on delivery
I need a solution that automatically combines child booking data from Pebble, Eequ, and Bright Horizons into a single master roster on Google Sheets in real-time. Pebble is our booking platform. Eequ is a secure website hosted by Surrey County Council recording HAF places. Bright Horizons is a website where childcare voucher bookings are made. The master roster should include: - Child's name and age - Booking dates and times (inc early and late) - Parent's contact details - Hot Food booking - Dietary requirements Will need to use confimation emails and web hooks to gather the data. The integrated sheet should be user-friendly and accessible with admin access for different users. It should also be used to produce a daily register to sign the children in and out and dietry information for a chef. Ideal skills and experience: - Proficiency with Google Sheets - Experience in setting up real-time data integration - Familiarity with Pebble, Eequ, and Bright Horizons platforms - Strong automation skills, possibly using tools like Zapier or Integromat
Project ID: 40664628
182 proposals
Remote project
Active 11 hours ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
182 freelancers are bidding on average £445 GBP for this job

Combining Pebble, Eequ, and Bright Horizons into one live roster is really a data-normalization problem, not just a Google Sheets task. The important part is making sure names, dates/times, dietary notes, hot food selections, and parent details arrive in a consistent format even if each source sends them differently by email or webhook. I’d set this up so the master sheet updates automatically, while also creating clean views for the daily register and chef use so staff are not working from raw booking data. I’ve handled Google Sheets-based automations and multi-source workflow setups where the main challenge was reliability and field mapping rather than the sheet itself. Do all three systems already provide predictable confirmation emails/webhook payloads, and should the daily register be grouped by date only or also by session/time slot?
£390 GBP in 7 days
9.4
9.4

I specialize in integrating child booking data from Pebble, Eequ, and Bright Horizons into a master roster on Google Sheets. Using web hooks and confirmation emails, I will automate the process to keep the roster up-to-date in real-time. The system will include essential fields like child's details, parent contacts, dietary requirements, and hot food bookings, accessible through a user-friendly interface. With expertise in Google Sheets and data integration, I will create a scalable solution using automation tools like Zapier or Integromat. I am committed to delivering a streamlined process and exceeding your expectations for a long-term partnership.
£675 GBP in 5 days
8.8
8.8

Hi there, I understand you need real-time data integration from three different sources - Pebble, Eequ, and Bright Horizons - into a unified Google Sheets roster. This is a complex automation challenge requiring robust API connections and data synchronization. My approach involves building a custom middleware solution using PHP and JavaScript that will: - Connect to each platform's API endpoints - Extract and transform booking data consistently - Handle authentication and rate limiting properly - Create automated triggers through Zapier or custom webhooks - Implement error handling and logging for data consistency - Ensure real-time updates with proper conflict resolution The solution will maintain data integrity while providing a single source of truth in Google Sheets. I'll establish secure connections to all three platforms and build a scalable architecture that can handle varying data formats and volumes. Best Regards, Khorshed Alam, RS Software
£515 GBP in 6 days
9.5
9.5

Hello, We are CnEL India, an experienced automation and Google Sheets integration team. We can build a reliable centralized roster that automatically collects booking information from the three platforms and keeps your master Google Sheet updated. Our methodology: Audit the available integration options for Pebble, Eequ and Bright Horizons, including emails, webhooks and APIs. Define a common data structure for child, parent, booking, food and dietary information. Build an automation layer to capture and normalize incoming booking data. Add duplicate detection, updates/cancellations and error handling to keep the roster accurate. Connect the processed data to Google Sheets with appropriate admin/user access. Create a daily register view for child sign-in/out and a clear dietary/food view for the chef. Add logging and monitoring so failed or incomplete imports can be identified quickly. Test with real sample bookings and validate the data against each source. Provide documentation for managing the automation and Google Sheet. We will prioritize data accuracy, security, maintainability and real-time updates. Best Regards, CnEL India
£500 GBP in 15 days
9.0
9.0

Hi — Elias here from Miami. I see you're looking to automate the integration of child booking data from multiple platforms. This is a crucial step in enhancing operational efficiency and ensuring seamless data flow. What usually matters most here is ensuring that data from Pebble, Eequ, and Bright Horizons is reliably merged. A common issue in systems like this is managing different data structures and ensuring stable integrations as your needs evolve. The tricky part is establishing robust automation logic to handle discrepancies in source systems. My approach would involve creating a centralized integration solution that utilizes APIs to fetch and synchronize data while maintaining integrity. I would prioritize building this with scalability and future expansion in mind, allowing the system to adapt as your needs grow. I've worked on similar data integration projects that required careful handling of APIs and automation tools, giving me insight into potential pitfalls and best practices. A few questions to better understand the scope: Q1 – What user roles will need access to this integrated data? Q2 – Are there specific workflows for how this data will be utilized? Q3 – How do you envision handling updates or changes to the source data? Happy to discuss the details and suggest the best technical approach. Looking forward to hearing from you.
£500 GBP in 3 days
8.7
8.7

Hi, Do Pebble, Eequ, and Bright Horizons already send structured confirmation emails for every booking/change? I will build the roster around one normalized Google Sheet structure, then feed Pebble, Eequ, and Bright Horizons into it through webhooks where available and confirmation-email parsing where direct APIs are limited. I’ll add duplicate protection, source tracking, and clear booking statuses so the same child is not added twice. I’ve built workflow automations, webhook integrations, CRM/data syncs, scheduled processing, and Google Sheets-style operational systems.
£500 GBP in 2 days
7.8
7.8

Hi, I can help you with "Automated Child Booking Data Integration" as per your given project description. We can discuss more in detail during a chat conversation when you are available. I've worked on many PHP projects in recent times. So I am confident on achieving your expected Goals. Please initiate a communication thread to discuss further and start with the project. ⭐ 5.0/5 from a recent client: "A more professional version: “Excellent work! The job was completed within the committed timeline. Great quality, professionalism, and timely delivery. Highly appreciated and recommended.”" Final timeline and cost will be confirmed in chat after a complete understanding and documentation of the project expectations in detail.
£450 GBP in 12 days
7.7
7.7

The tricky part here is not collecting the bookings — it is merging three different booking streams into one roster without duplicates, missing dietary info, or messy date/session formatting. I would build the workflow around email parsing/webhook capture first, then map everything into a structured Google Sheet with separate admin-friendly outputs for attendance sign-in/out and kitchen use. That way your team gets one reliable source of truth instead of checking Pebble, Eequ, and Bright Horizons separately. I’ve worked on spreadsheet automation and live data sync setups where operational teams needed something practical and easy to maintain, not just technically connected. Are you expecting historical bookings to be imported too, or only new incoming bookings from the point the automation goes live? And do different admins need edit access to different tabs, or just general shared admin access?
£370 GBP in 7 days
7.7
7.7

Hi, I can streamline your booking synchronization using Make to build a central dashboard. I will automate your data capture from these platforms to generate automated daily registers for your staff. Let's discuss!
£500 GBP in 7 days
7.4
7.4

Hello!, I am a Florida-based senior software engineer(frontend, backend, ecommerce, etc) with 15+ years of experience building reliable API integrations, automation flows, and data systems. I read your project carefully, and the goal is clear: automatically combine child booking data from Pebble, Eequ, and Bright Horizons into one clean, usable flow without manual work. I’ve done similar integration work using PHP, JavaScript, APIs, Google Sheets, Zapier, and custom data pipelines, so I can build this in a way that is practical, maintainable, and easy for you to run day to day. My approach would be: 1. Review each platform’s API/webhook/export options 2. Map and standardize the booking data 3. Build the sync/merge logic with validation and duplicate handling 4. Push the final data into Google Sheets or your preferred destination 5. Test thoroughly and document everything clearly Could you please clarify the following questions to help me better understand the project? 1. Do Pebble, Eequ, and Bright Horizons all provide API access, or should I plan for exports/webhooks where needed? 2. What should the final output be, Google Sheets only, or also a dashboard/database/report? 3. Which booking fields matter most, such as child name, session date, attendance, payment status, or location? I’ve built similar automation tools for booking and data workflows, and I’m confident I can make this one clean and dependable too. -James
£650 GBP in 3 days
7.4
7.4

Hi, I can build a real-time Google Sheets master roster that automatically combines Pebble, Eequ and Bright Horizons bookings, including session times, parent details, hot-food bookings and dietary requirements. It will also generate a clean daily register for staff and a separate chef-ready dietary list. The system will include: - Child name and age - Parent/guardian contact details - Booking dates, core sessions, early drop-off and late collection - Hot-food bookings and dietary/allergy requirements - Source and booking-reference tracking - Duplicate prevention and amendment/cancellation handling - Exception alerts for incomplete or unrecognised booking data - Daily register with sign-in/sign-out columns - Chef view showing daily attendance, hot-food totals and dietary needs - Protected administrator access and separate staff-facing views - Error log, audit history and clear maintenance instructions I have completed a 5-star Zapier automation project: https://www.freelancer.com/projects/WPForms-Dropbox-Automation-fix/reviews I will test the workflow with real samples from Pebble, Eequ and Bright Horizons before launch, including new bookings, amendments and cancellations, then provide a short handover so your team can manage users and review alerts confidently. Do confirmations, changes and cancellations from all three platforms arrive in one Gmail inbox? Regards, Raj
£450 GBP in 8 days
7.6
7.6

Hi, I’ve read your workflow carefully, and I can build a reliable real-time master roster that pulls booking data from Pebble, Eequ, and Bright Horizons into Google Sheets with clean admin access and daily register output. I have strong experience with PHP-based automation, webhook handling, Google Sheets integrations, and Zapier-style workflows. I can use confirmation emails and web hooks to capture child details, booking times, dietary information, and parent contacts, then structure the sheet so it remains user-friendly for admin users while also generating practical sign-in/sign-out and chef-ready dietary views. I can start immediately and deliver the integration in about 7 days, including testing and refinement for edge cases like early/late sessions. Do Pebble, Eequ, and Bright Horizons each provide accessible webhook/API outputs, or should the automation rely primarily on email parsing? Best regards, KANIKA
£450 GBP in 7 days
7.0
7.0

One master roster must reconcile Pebble, Eequ, and Bright Horizons without duplicate children or missed booking changes. Webhook data can update Google Sheets immediately, while confirmation emails need structured parsing and duplicate checks using booking references. I’d first confirm what each platform exposes, then map names, ages, sessions, parent contacts, hot food, and dietary needs into one consistent record. Google Apps Script can process webhooks and emails, validate required fields, log errors, and protect sensitive columns with role-based access. The same data can generate a clear daily sign-in/out register and a chef view containing only relevant dietary information. The main risk is matching amended or cancelled bookings across three sources. I’d handle this with stable booking IDs and an audit log. Could you share one redacted confirmation email from each platform so I can verify the safest data flow?
£500 GBP in 5 days
7.0
7.0

Hi There, I have strong experience with Google Sheets automation, Zapier/Make/n8n-style integrations, webhooks, email parsing, and building real-time operational dashboards. I can create a master roster that consolidates bookings from Pebble, Eequ, and Bright Horizons using available webhooks and confirmation emails, then automatically structure child details, booking times, parent contacts, hot food, and dietary requirements in Google Sheets. I can also set up admin access, a daily sign-in/out register, and a chef-friendly dietary view. I’m ready to review the available emails/API/webhook options for each platform and recommend the most reliable setup.
£250 GBP in 1 day
7.2
7.2

Hello, AUTOMATED CHILD BOOKING DATA INTEGRATION DEVELOPER {{{ I HAVE CREATED SIMILAR BEFORE AND I CAN SHOW YOU }}} I have carefully reviewed your requirements for automatically combining child booking data from Pebble, Eequ, and Bright Horizons into a centralized Google Sheets master roster. I have 11+ years of software and automation development experience and can build the solution using Google Sheets, Apps Script, webhooks, APIs, email parsing, and automation workflows where direct integrations are available. I can automate the collection and synchronization of child names, ages, booking dates and times, parent contact details, hot food bookings, and dietary requirements into one structured master roster. I will also create the daily register for child sign-in/sign-out and clear dietary information for the kitchen team. I will make sure the system is reliable, user-friendly, secure, and easy to maintain, with automated updates, validation, error handling, duplicate prevention, admin access, and clear data structures. Where APIs or webhooks are unavailable, I can use confirmation-email processing or other appropriate integration methods. I WILL PROVIDE 2 YEARS FREE ONGOING SUPPORT AND COMPLETE SOURCE CODE. I have created similar Google Sheets, data integration, API, webhook, and automation systems before and can show you relevant examples of my previous work. Thanks, Christina
£450 GBP in 10 days
7.5
7.5

Understanding the need for a seamless integration of child booking data, our team can develop a solution that combines information from Pebble, Eequ, and Bright Horizons into a real-time master roster on Google Sheets. This will ensure accurate and efficient management of booking details and dietary requirements. We will leverage confirmation emails and webhooks to gather data effectively, ensuring that all necessary details like names, booking times, and dietary needs are included. Additionally, we'll focus on creating an intuitive user interface for easy access and daily register production. Our expertise in Google Sheets and automation tools like Zapier allows us to implement a robust system that meets your requirements. Also, communication, quality, and on-time delivery are priorities. If you'd like, I can also share similar work we've completed and discuss the best approach for your project. You pay for quality. We deliver it. Regards, JP
£400 GBP in 7 days
6.8
6.8

Manual data consolidation across disparate booking systems causes duplicate records, missed allergy alerts, and operational chaos during morning drop-offs. When confirmation emails and webhooks from platforms like Pebble, Eequ, and Bright Horizons are not parsed with strict schema validation and deduplication, the daily sign-in register and kitchen dietary sheets become error-prone and unreliable. I will build an automated real-time integration pipeline using Make (Integromat) or Zapier paired with Google Apps Script to synchronize all three sources directly into a master Google Sheet. The system will catch webhooks where available and parse structured incoming confirmation emails, mapping child details, times, hot food options, and medical/dietary notes seamlessly. The master sheet will automatically generate real-time, dynamic daily sign-in/out registers and formatted allergen/diet summaries specifically tailored for your chef. Do you already have access to webhook endpoints or API keys for Pebble, or will we rely primarily on email parsing triggers for all three providers?
£500 GBP in 5 days
6.8
6.8

Hi! My name is Marjan and I'm here to offer you my services as a skilled applicant with over a decade of experience working on Freelancer.com. I believe I am the best fit candidate for this project due to my extensive experience; I would like to have a discussion to get to know that we both are on the same page. Once the scope will be locked, I will start working on it right away.
£250 GBP in 7 days
6.7
6.7

Hello, We would be glad to assist you with this project. Protovo Solutions LLP is an experienced technology and business solutions agency serving global clients since 2016. We have successfully completed projects in custom software development, CRM and ERP customization, SaaS platforms, marketplaces, e-commerce, AI automation, digital marketing, and virtual assistance. Our team has hands-on expertise in Laravel, CodeIgniter, PHP, Node.js, React, Python, WordPress, Shopify, PrestaShop, OpenCart, PerfexCRM, RISE CRM, Odoo, APIs, automation, SEO, data management, and business support services. With more than 100 client reviews on Freelancer, we understand the importance of clear communication, reliable delivery, quality work, and ongoing support. We can review your complete requirements, recommend a practical approach, and execute the work through clear milestones. Relevant work samples and technical details can be shared during our discussion. Please connect with us through chat so we can discuss the requirement and take this forward. Kind regards, Protovo Solutions LLP
£750 GBP in 7 days
6.9
6.9

A reliable automated system can bring booking data from Pebble, Eequ, and Bright Horizons into one Google Sheets master roster with near real-time updates. The integration can use available webhooks, APIs, and confirmation emails to capture child details, ages, booking dates and times, parent contact information, hot food bookings, and dietary requirements. The system can also generate daily sign-in/out registers and a clear dietary list for the chef. The workflow will remain simple and easy for staff to manage, with appropriate user access, duplicate prevention, automatic updates, and error handling. A few sample confirmation emails and details of the available integration options would be helpful to confirm the best approach before development.
£300 GBP in 7 days
6.4
6.4

Hanwell, United Kingdom
Member since Aug 22, 2026
₹750-1250 INR / hour
₹600-1500 INR
₹12500-37500 INR
$250-750 USD
$10-30 USD
₹1500-12500 INR
$250-750 USD
₹100-400 INR / hour
₹12500-37500 INR
₹1500-12500 INR
$2-8 USD / hour
₹600-1500 INR
$250-750 USD
₹1500-12500 INR
₹1500-12500 INR
₹12500-37500 INR
$2-8 USD / hour
₹12500-37500 INR
$30-250 USD
$15-25 CAD / hour