I run a restaurant and need someone to create an automatic connection between our staff schedule spreadsheet and team calendar. I have other projects going on so I can’t tackle this myself right now.
What I have:
A spreadsheet containing front of house and back of house employee schedules plus special events. The data is mostly organized but could use some cleanup.
What needs to be built:
Create automated synchronization between the spreadsheet and calendar system.
Requirements for the calendar:
Updates automatically when spreadsheet data changes
Staff can only view, managers can edit
Shows special events that happen during work shifts
Different colors for front of house, back of house, and events
Should work for 12 months
Technology preferences:
Google Apps Script would be best
Could use Zapier or similar tools if they stay within free limits
Important: This needs to be truly automated, not something requiring manual updates each time.
Payment: $40 total via PayPal or Venmo
Looking for someone who:
Has done calendar integration projects before
Knows Google Sheets, Calendar, and automation tools well
Can finish this quickly and professionally
There might be more work available later including social media projects. Hope to find someone reliable to work with going forward. Thanks for reading!
Just finished a similar project for a small chain last month so this hits close to home. Your $40 budget is workable but make sure whoever you hire tests the automation thoroughly with sample data first. Restaurant schedules change constantly and the last thing you want is phantom shifts showing up on the calendar or events disappearing. I’d recommend having them build in some basic logging so you can track when syncs happen and catch any failures early. Also worth mentioning that Google Apps Script has execution time limits so if your staff roster is large they might need to batch the updates. The multi-month requirement shouldn’t be an issue since Google Calendar handles recurring events well.
hey dancingbird, done similar stuff before with google apps script for a catering biz. your budget is tight but doable if the spreadsheet isnt too messy. main thing is making sure the script handles timezone issues and doesnt break when someone accidentally deletes a cell. can probably knock this out in a weekend if you’re intrested.
I’ve built several restaurant scheduling automations using Google Apps Script and your requirements are definitely achievable within that budget. The key challenge will be setting up proper error handling so the sync doesn’t break when staff data gets modified unexpectedly. You’ll want to make sure whoever takes this on creates separate calendar layers for FOH, BOH, and events since Google Calendar handles color coding well that way. The permission structure you described is straightforward to implement through Google Workspace sharing settings. One suggestion would be to ask for a simple admin dashboard within the spreadsheet so managers can trigger manual syncs if needed as a backup option.