Google Sheets integration makes it possible to automatically register the contents of bookings accepted by Jicoo in Google Spreadsheets.
This reduces the time and effort required to input guest information based on booking information in Jicoo, allowing you to build an efficient spreadsheet management flow.
*Google Spreadsheets are specified on an account-by-account basis.
Synchronize bookings with spreadsheets
Appointments made with Jicoo are registered in a Google Spreadsheet. Appointment information, name, and other information, as well as a link to the appointment details in Jicoo, allows you to go back and forth between the two at any time.
Google Sheets integration settings are saved on an account-by-account basis. If you want bookings hosted by other members to be written to the same spreadsheet, set setting sharing to “Share” on each booking page. See this help page for details.
Synchronization to Google Spreadsheet is performed when creating, changing, or canceling bookings.
The linked spreadsheet can be selected for each booking page.
You can select any spreadsheet to be synchronized with Jicoo. You can select the spreadsheet to be linked from the workspace according to the use of the booking page, such as by department or by client.
*It is possible to create a new sheet or select from an existing sheet to be specified. (Re-association may be required to display an existing sheet.)
Possible to select the properties of the linked spreadsheet for each item
You can select which columns of the spreadsheet will reflect Jicoo items.
The following items can be selected
Booking title
Email address
Company name
Message
Phone number
Booking Date and Time
Guest Name
Booking detail screen URL
Location
Booking creation date/time
Status
Contact Person
Additional items set in the reception form
Embed Title String
When "Booking Title" is selected from the items to be linked to the spreadsheet, you can specify a string for the booking title that will be reflected in the spreadsheet.
The following values are available for variables.
Host Name: The name of the booking host.
Contact Name: Name of the booking guest.
Event Name: Title of the booking page.
Event Date: Date and time when the booking occurred.
Event StartedAt: Date and time when the booking was made.
TimeZone: Time zone of the booking.
Sharing of settings
When another member is the booking host, you can specify whether or not to share the settings and collaborate.
The settings must be configured on a per booking page basis. Edit booking page > Integration > Google Spreadsheet
*This setting is required when linking when only another member is the host, or when another member is the host with automatic assignment of the person in charge, etc.
When the settings are shared, the integration works as long as the member who shares the settings has completed Google Sheets integration. Other members do not need to enable Google Sheets integration themselves. *If a member covered by the shared settings has enabled their own Google Sheets integration, that member's own settings will take priority for bookings they host, and some items (such as additional questions) may not be reflected in the spreadsheet.
About cases where the individual settings do not work even if you select "Share"
If you have set "Share" but bookings are not reflected in the spreadsheet, the member who hosted the booking may have saved their own Google Sheets setting for that booking page, and that setting is taking priority.
In this case, ask that member to open “Edit booking page > Integration > Google Spreadsheet” with their own account, set “Status” to “Disabled” and save. From then on, bookings hosted by that member use the shared setting, and items such as additional questions are also reflected in the spreadsheet.
*Please do not disconnect Google Sheets on the integration page. Disconnecting does not remove the setting saved for the booking page, so it keeps taking priority, and bookings hosted by that member will no longer be written to the spreadsheet. If it has already been disconnected, have that member connect Google Sheets again, and the setting will be used again.