How to Configure the Google Sheets Script?

---

Where can I find it? Company >>> Components/Integrations >>> Google Sheets.

---

In this article, we are going to show you how to optimize the use of the Google Sheets Integration by configuring our script. This tool will help you digest and group all the data from your bookings in different tabs with key information to better understand and manage your business.

---

Setting up the Script

Step 1: Open the Google Sheets file

Log in to your Google account (a Gmail account is required) and open the Google Sheets application.

At the top of the list, you should find and open the newly created document called "TuriTopBookingsData".

Step 2: Install the Script Code

In the toolbar, select Extensions >>> Apps Script:

A new tab will open and you will have to paste the code contained in this text file on the right side of the Code.gs section as shown in the image below:

The text (function myFunction { }) that appears by default must be erased.

The script file attached can be also downloaded at the end of the tutorial.

Then click the "Save project" icon to load the script:

Step 3: Add a Trigger

The next step will be to configure the triggers for this new project. To do this you must go to Triggers on your left panel:

Click on "Add trigger" or "...create a new trigger".

 

Modify the options just as seen below and click on "Save":

Step 4: Authorize the App

For security reasons, in order to register the changes, you will need to confirm which Google account you are using:

Then grant the project access to your Google Account:

If you get the message "Google hasn't verified this app", select "Advanced" and click on "Go to..."

Step 5: Run the Script

Finally, go back to the Editor section and select "Run".

When prompted, click on "Review permissions" and authorize the app.

You can confirm it was correctly deployed in the Execution log.

Step 6: Deploy the Script 

Go back to the "TuriTopBookingsData" document and refresh the page. You will see a new tab called "TuriTop" within your document options panel, click on it and select "Sync Events & Bookings".

 

All ready! Once the script is deployed, you will see in the lower bar of the document new different tabs have been created: Resources, Bookings, Events, Payments, CustomMapping, HistoryAllocation, Tickets, and TicketType. Each tab processes the data separately (statistics, sales summaries, ticket types, etc.) for better management of the synchronized information from the "TURITOP-DATA" tab: 

You can hide the "TURITOP-DATA" tab since you will be working with the others, but never erase it as they depend on it.

 

---

Tabs available and their characteristics

Resources: Allows you to create the different resources that can be later manually assigned to the events in the document.

Bookings: Displays all bookings synchronized with TuriTop in a more efficient format, generating one row per booking.

Events: Gives you an overview of all of your events, showcasing one per row along with the bookings associated and total revenue, among other details.

Payments:  Gives you an overview of all of the payments associated with your bookings, organizing them, once again, one per row.

CustomMapping: Here you have the possibility of doing custom mappings on the events.

HistoryAllocation: Historical record of the manual allocation of resources.

Tickets: This tab adds a row by ticket type, allowing you to see individually the number of tickets selected on each booking.

Ticket Type: In this tab, we must map each ticket ID to its corresponding ticket name to ensure they are correctly identified in the other tabs. 

 

---

Ticket Mapping

In order to map and identify correctly each ticket, we must go to the TicketType sheet and enter the name associated with that ticket ID in the "Ticket Name" column.

Once they are identified here, make a new sync (Turitop >>> Sync Events & Bookings) so they are correctly named in the other tabs. For example:

We will offer soon an automatic way to obtain this data. Meanwhile, please contact our support team at help@turitop.com and provide them with the list of ticket IDs so they can give you back their associated ticket names.

Every time new tickets are created, you will need to update the information on this tab.

---

Manual Resource Management 

This feature will help you assign the resources post-booking. It does not take into account the availability nor is meant to control it.

Creating the resources

Start in the Resources tab by creating the resources you will later assign to your bookings.

To add a new resource type the:

• Resource ID
• Resource_Type
• Resource Name

For example:

Once you add the resources and sync the data (Turitop >>> Sync Events & Bookings), you will notice new columns corresponding to them will appear in the Events and the Bookings tabs.

Linking the resources (Simple and Custom Mapping)

In order to link the resources you need to go to the Events tab and assign the resource/s you have created to each event.

Simple Event Mapping

If you are going to assign the same resources for all the bookings of a specific event, you can leave the "Event_Mapping_" default value, "Simple".

Then just assign the corresponding resource on each resource type column:

To ensure this is synced in all tabs, click on Turitop >>> Simple Sync.

Custom Event Mapping

If you are going to assign different resources to the bookings of a specific event, change the value of the "Event_Mapping_" to "Custom". Upon doing it, you will need to confirm the action:

You will notice the resources row will be grayed out, so to assign them in this scenario, you will need to move to the Custom Mapping tab. 

Here you will locate the events related by the color yellow and will be able to assign the resource/s per booking.

To ensure this is synced in all tabs, click on Turitop >>> Custom Sync.

---

Further customizations

Keep in mind that you can further enhance this script to adapt it to your specific needs (creating a tailored group list for your guides/transport routes, grouping the data according to different parameters, etc.). If you are interested in this but don't count on a team member who can take over this task, we can put you in contact with one of our external collaborators. Get in touch with our support team at help@turitop.com!