Google Apps Script Developer Needed - Airbnb ICS Calendar Synchronisation

Overview I require a Google Apps Script developer to build a robust synchronisation system between two Airbnb ICS calendars and my Google Sheets booking spreadsheet. This is intended to be a long-term, reliable solution that runs automatically every hour with minimal maintenance. The script should be clean, well-commented and written so that an additional Airbnb property can easily be added in a few weeks. Current Setup Google Sheet contains two tabs: Booking Schedule Airbnb Import (optional if needed) Current Airbnb properties: • Riverview • Tiny Home A third property (Highview) will be added in the near future. Spreadsheet Columns (A) A Status B Property C Check In D Check Out E Guest F Pax G Pets (manual) H Nights (automatic) I Arrive (manual) J Depart (manual) K Notes (manual) L Welcome Message (manual) M Booking ID (automatic) Requirements The script must: Read Airbnb ICS feeds directly. Run automatically every hour using Apps Script triggers. Add new bookings. Update changed bookings. Remove cancelled bookings. Remove bookings that no longer exist in the Airbnb calendar. Automatically remove completed bookings after checkout (or alternatively archive them if that is a better design). Never create duplicate bookings. Automatically calculate nights. Sort bookings by Check In date. Generate a unique Booking ID for each booking. Booking ID should remain stable between synchronisations. Preserve Manual Columns The following columns must NEVER be overwritten: Pets Arrive Depart Notes Welcome Message These values are manually entered after bookings arrive. If Airbnb booking information changes, these manual fields must remain attached to the correct booking. Status Column A (Status) will NOT be managed by Apps Script. Status will be handled using a spreadsheet formula. The Apps Script should leave Column A blank. Performance Script should comfortably run every hour. Should avoid unnecessary API calls. Should be written cleanly and efficiently. Future Expansion It should be easy to add additional Airbnb properties by simply adding another ICS URL to a configuration section. No code rewrite should be required. Deliverables Complete Google Apps Script. Installation instructions. Configuration section for Airbnb ICS URLs. Instructions for hourly trigger. Code should be fully commented. Preferred Skills Google Apps Script JavaScript Google Sheets Automation ICS / iCalendar parsing Experience with Airbnb calendar integrations What I am looking for I am NOT looking for a quick proof-of-concept. I want a reliable production-quality solution that I can leave running unattended. Code quality and maintainability are more important than simply making it work once. "Please do not apply if your solution depends on Google Calendar as an intermediary. The script must read the Airbnb ICS feeds directly."