Back to Google Sheets

How to Set Up Google Sheets with Reeserved

Keep your spreadsheet and Reeserved in sync. 5 minutes, no tech skills needed.

Before you start

  • A Reeserved account on the Pro plan or higher (trial works too).
  • A Google account that can access your booking spreadsheet.
  • You must be an Admin or Owner on your Reeserved team.
  • Your spreadsheet should have column headers in the first row (e.g. "Name", "Date", "Court").

Step-by-step setup

Follow these steps to connect Google Sheets to your Reeserved account.

  1. 1

    Go to Settings

    Log in to Reeserved. Click "Settings" in the left sidebar, then click "Integrations" at the top.

  2. 2

    Find Google Sheets and click Connect

    Scroll down to the "Google Sheets" card. Click "Connect Google Sheets". A Google sign-in window will pop up. Pick the Google account that has access to your booking spreadsheet and click Allow.

  3. 3

    Paste your spreadsheet link

    Open your booking spreadsheet in Google Sheets. Copy the full URL from your browser's address bar (it looks like https://docs.google.com/spreadsheets/d/...). Go back to Reeserved and paste it into the box. Click "Load Sheet". If you have multiple tabs, pick the one with your bookings.

  4. 4

    Match your columns

    Reeserved will read the column headers from your sheet. For each row, pick which of your columns matches: Resource (court, room, or space name), Date, Time, Customer Phone (required), Customer Name, Status, Price, Notes. For the "Reeserved ID" column, pick an empty column at the end of your sheet (or add a new one called "Booking ID"). Reeserved uses this column to keep track of which rows have been synced.

  5. 5

    Match your resources

    Reeserved will show the unique names it found in your resource column (e.g. "Court 1", "Room A"). Match each one to the correct resource in Reeserved using the dropdown. If a name does not match any resource, leave it as "Skip" and those rows will be ignored.

  6. 6

    Choose your sync settings and turn it on

    Pick how you want the sync to work. "Both ways" is recommended: new rows in your sheet create bookings in Reeserved, and new bookings in Reeserved add rows to your sheet. For slot strategy, "Create slot automatically" is the easiest option as it creates time slots on the fly. Click "Enable Sync" and you are done. Reeserved will sync every 10 minutes automatically.

Troubleshooting

Do I need to change my spreadsheet format?

No. Reeserved reads whatever format you already use. You just tell it which column is which during setup.

What happens if someone edits the same booking in both places?

Reeserved detects the conflict and flags it for you to review. No data is lost.

Can multiple people use the spreadsheet while others use Reeserved?

Yes, that is exactly what this feature is for. Some team members can keep using the familiar spreadsheet while others use Reeserved. Both stay in sync.

Will this slow down my spreadsheet?

No. Reeserved reads and writes a few cells at a time. You will not notice any difference.

What is the 'Reeserved ID' column for?

It is a hidden tracking column. Reeserved writes a unique ID into each row after syncing it. This prevents duplicate bookings if you run the sync again. You can hide this column in your sheet if you want.

Can I stop the sync later?

Yes. Go back to Settings, scroll to Google Sheets, and click "Disconnect". Your spreadsheet data stays as is.

Tips

  • You can click "Sync Now" at any time to sync immediately instead of waiting for the next automatic cycle.
  • If you add new columns to your spreadsheet later, disconnect and reconnect to remap them.
  • Your existing data in the spreadsheet is never deleted. Reeserved only reads and adds to it.
  • The sync works even if different people use the sheet and Reeserved at the same time.

Try Google Sheets with Reeserved. Free for 7 days

No credit card required. Set up in 2 minutes.

Start your free trial