Quick Summary
Amelia’s booking plugin for WordPress can be enhanced by syncing appointment data to Google Sheets using Pushrow, allowing teams and clients to access live booking information effortlessly. The integration automatically updates with key details like booking status, customer information, and total price, eliminating manual data entry. The setup process is straightforward, involving Google OAuth, creating a sync job, and mapping fields to specific columns in your chosen Google Sheet. This solution is ideal for service businesses, consultants, and multi-employee operations, facilitating better management and oversight of appointments.
Amelia is a powerful WordPress booking plugin used by service businesses, wellness studios, consultants, and any business that takes appointments through their website. But managing bookings inside the Amelia dashboard works fine for one person — when you need your front desk, team, or clients to see appointment data, Google Sheets is a much better fit.
Pushrow for Google Sheets syncs every new Amelia booking to Google Sheets automatically the moment it’s confirmed. No manual exports. No copy-pasting. Just live appointment data in your spreadsheet.
What Gets Synced
The Amelia integration syncs booking data organized by service and employee. Here’s what’s available for field mapping:
- Booking ID
- Booking Date and Time
- Service Name
- Employee Name
- Customer Name
- Customer Email
- Customer Phone
- Booking Status (approved, pending, cancelled, rejected)
- Booking Notes
- Total Price
- Payment Status
Setup Guide
Step 1 — Connect Pushrow to Google
Install Pushrow for Google Sheets and activate it. Go to Pushrow → Settings and complete the Google OAuth setup using the instructions in the Google Cloud Setup Guide.
Step 2 — Create a New Sync Job
Go to Pushrow → Add New Sync and select Amelia Bookings from the Bookings section.
Step 3 — Choose Your Sheet and Tab
Select the Google Sheet where Amelia bookings should be recorded. You can organize bookings by service using separate tabs — for example, a ‘Consultations’ tab and a ‘Workshops’ tab within the same Sheet.
Step 4 — Map Fields
Map the Amelia booking fields to your Sheet columns. A typical setup includes booking date/time, service, employee, customer name, email, phone, status, and price.
Step 5 — Activate
Save and activate the sync job. Test it by creating a test booking in Amelia. It should appear in your Google Sheet immediately.
Use Cases
Service Businesses
A salon, spa, or wellness studio can have all bookings flowing into a shared Sheet that reception staff monitor throughout the day — showing client name, service, staff member, and appointment time.
Consultants and Coaches
Keep a running log of all client sessions in Google Sheets. Combine with other data (notes, follow-ups, invoices) in the same spreadsheet to build a lightweight CRM.
Multi-Employee Operations
Since Amelia tracks which employee a booking is assigned to, your Google Sheet can serve as a daily schedule overview for managers — filtered by employee or service type.
Client Reporting
For agencies managing booking sites for clients, share a live Google Sheet with the client showing all their bookings. The client gets real-time appointment visibility without needing WordPress access.
Tracking Cancellations and Status Changes
Pushrow can update existing rows when an Amelia booking status changes — so if a booking is cancelled or rescheduled, that change is reflected in your Google Sheet automatically.
This keeps your Sheet accurate as a live record of bookings rather than a static snapshot.
Pushrow for Google Sheets is included in the PluginStack bundle — 6 premium plugins for a one-time payment of $99 (Solo) or $179 (Agency). Lifetime updates included. No recurring fees.
→ Get PluginStack at pluginstack.dev/pricing
Frequently Asked Questions
What are the benefits of syncing Amelia bookings to Google Sheets?
Syncing Amelia bookings to Google Sheets allows for real-time visibility of appointment data for teams and clients, eliminating the need for manual exports. It enhances collaboration by providing a centralized platform where multiple users can access and manage booking information.
What booking data can I expect to sync with Google Sheets?
You can sync various types of booking data, including booking ID, date and time, service name, employee name, customer details, booking status, and payment status. This comprehensive data mapping helps in better organization and management of appointments.
How do I set up Pushrow to work with Amelia?
To set up Pushrow, first install and activate it on your WordPress site. Then, follow the steps to complete the Google OAuth setup, create a new sync job for Amelia bookings, select your desired Google Sheet, map the necessary fields, and activate the sync.
Can I organize my Google Sheet by different services?
Yes, you can organize your Google Sheet by creating separate tabs for different services, such as ‘Consultations’ and ‘Workshops’. This makes it easier to manage and view bookings based on specific services.
What should I do if my test booking does not appear in Google Sheets?
If your test booking does not appear in Google Sheets, first check that you have correctly activated the sync job and mapped the fields properly. You may also want to verify your Google OAuth setup and ensure that there are no connectivity issues.