Google Calendar and Sheets integration for Campsite

Connect Google Calendar and Google Sheets for rota sync.

Written By Campsite

Last updated About 1 month ago

Google Calendar

Connect Google Calendar and Google Sheets for rota sync.

This guide is the detailed Campsite help article for this topic. It is written for UK employers and people teams using a branded organisation workspace such as {org}.camp-site.co.uk.

What the integration covers

Feature Direction Who sets it up Calendar push Campsite → Google Calendar Admin enables workspace connection; staff connect personal accounts Google Sheets rota import Google Sheets → Campsite Admin

Admin setup

Before any staff member can connect their Google account, you need to enable the Google integration at the workspace level. Navigate to Admin → Integrations ( /admin/integrations ). Find the Google Calendar integration and select Configure. Complete the Google OAuth authorisation flow to grant Campsite the necessary permissions. Once connected, the integration is active and staff can begin linking their own accounts.

Staff connection

Each staff member must individually connect their own Google account to enable calendar push for themselves. Connecting the workspace-level integration does not automatically sync events to every staff member's calendar. Staff connect their Google account from Settings → Integrations in their personal settings. They will be prompted to sign in to Google and grant Campsite permission to create and update calendar events on their behalf. Once connected, their Campsite shifts and events will appear in their Google Calendar automatically.

How calendar push works

When Campsite creates or updates a shift or calendar event - whether from the rota, a manual calendar entry, or a scheduled broadcast with a date - the event is automatically pushed to every connected staff member's Google Calendar. This is a one-way sync. Changes made directly in Google Calendar (editing, deleting, or moving an event) do not reflect back in Campsite. The source of truth for all shifts and events remains your Campsite workspace.

Google Sheets rota import

If your organisation manages rotas in Google Sheets, you can import that data directly into Campsite rather than re-entering it manually. To run a rota import: Go to Admin → Rota Import ( /admin/rota-import ). Upload your Google Sheet file or connect it via Google Drive. Map the columns in your sheet to the corresponding Campsite rota fields. Review the preview and confirm the import. Rota imports bring data into Campsite at the point of import - they do not create an ongoing live sync between your Google Sheet and Campsite. For ongoing rota management, use the Campsite rota grid directly after the initial import.

Troubleshooting

If a staff member's Google Calendar stops receiving events, ask them to visit Settings → Integrations and reconnect their Google account. Token expiry or a change to their Google account permissions can interrupt the sync, and reconnecting resolves this in most cases.

Before you contact support

  1. Confirm you are signed in on the correct organisation URL ({org}.camp-site.co.uk).
  2. Refresh after a recent role or permission change.
  3. Check whether a colleague with the same role can see the same controls.
  4. Capture the page URL and any error text if you still need help.