01
One row per booking
Each booking lands as a row with date, time, service, teammate, customer, phone, price, status and your custom question answers. Choose which columns you want and in what order.
Your bookings in Google Sheets, kept up to date
Connect a spreadsheet and every new booking appears as a row within seconds. Reschedules and cancellations update the same row, so the sheet always matches your calendar.
DatePick bookings
auto-updating| Date | Time | Service | Customer |
|---|---|---|---|
| Oct 8 | 09:00 | Facial | Maya Chen |
| Oct 8 | 10:30 | Massage | Noah Kim |
| Oct 8 | 13:00 | Brows | Lea Martin |
| Oct 8 | 15:00 | Facial | Omar H. |
- Category
- Reporting
- Setup
- About 2 minutes
- Updates
- Within seconds
- Plans
- Every DatePick plan
What you get
What DatePick and Google Sheets do together
02
Rows that stay true
A booking ID column links each row to its booking. When a customer reschedules or cancels, DatePick updates the row instead of adding a duplicate.
03
Share without sharing the admin
Give a guide, driver or accountant access to the sheet without giving them access to your Shopify store.
04
Formulas, charts and pivots
Build commission formulas, busy-hour charts or a weekly pivot on top of the raw rows. New bookings flow into your formulas on their own.
Set up
Connect Google Sheets in 3 steps
- 1
Connect Google
Open Settings › Integrations › Google Sheets and sign in with your Google account.
- 2
Pick a spreadsheet
Choose an existing sheet or let DatePick create one, then pick your columns.
- 3
Watch it fill
New and changed bookings appear automatically. Past bookings can be backfilled once.
Made for
How shops that sell time use it
Tour operators
Share a live passenger manifest with your guides, sorted by departure, with each guest's phone number and pickup point.
Salons paying commission
Pull each stylist's completed bookings and prices into a payroll sheet that works out commission automatically.
Equipment rental shops
Keep an equipment-out log with pickup and return dates that the warehouse team can check on a tablet.
Under the hood
The details
Exactly what moves between DatePick and Google Sheets, which way it goes and when. Included on every plan, Free too.
- Direction
- DatePick to Google Sheets; edits in the sheet don't change bookings
- Updates
- New rows for new bookings; rescheduled and canceled bookings update their existing row
- Columns
- Booking ID, date, time, service, teammate, location, customer, email, phone, price, status, custom answers
- Backfill
- Optionally copy existing bookings when you connect
- Account
- Any Google account with access to the spreadsheet
FAQ
Google Sheets questions
Can I export bookings to Google Sheets automatically?
Yes. Once connected, every new booking is added as a row within seconds, with no CSV exports or Zaps needed.
Will cancellations update the sheet?
Yes. Each row carries a booking ID, so cancellations and reschedules update that row instead of adding a new one.
If I edit a row, does the booking change?
No. The sync goes one way, from DatePick to Sheets. Change bookings in DatePick and the sheet follows.
+Connect Google Sheets today
Install DatePick for free. The Google Sheets integration is included.