Goki PINs import file


Goki Reservation Import (Large Reservation Numbers)

Step 1: Generate Unique pmsNumber and pmsMeta.id

  • In the pmsNumber column, enter the formula to create a unique number:

    =ARRAYFORMULA(CONCATENATE(
    CHAR(RANDBETWEEN(65,90)), RANDBETWEEN(0,9),
    CHAR(RANDBETWEEN(97,122)), RANDBETWEEN(0,9),
    CHAR(RANDBETWEEN(65,90))
    ))

  • This ensures each reservation has a different ID and won’t overwrite existing ones.

Step 2: Format fromDate and toDate


  • On this format
    2025-08-26

Step 3: Find parentSpaceId

  • Use the VLOOKUP formula to get the room ID from your lookup table:

    =VLOOKUP(Q14, 'Timothy Room parentID'!A:B, 2, FALSE)

  • Replace Q14 with the cell containing the room #.

  • After applying, copy this column and paste as values only to remove the formula.

Step 4: Finalize Data and Save

  • Select all cells with formulas and copy + paste as values to avoid errors during import.

  • Save your file as CSV format.

Step 5: Import into Goki

  • Go to the Goki reservation system and import the CSV file you just saved.


Step 6: Double-check check Goki reservations page to see whether all is imported or not


Otherwise to create one by one;

Create the reservation manually, and make sure the confirmation code is created.


PIN Creation Timing

  • Timothy: PIN is created at 9:00 AM, one day before arrival.
  • Carey: PIN is created at 12:00 PM on the day of arrival.

If you need to change the automation time:

  • Update the Check-in Time (currently Timothy is set at 9:00 AM).
  • Update the Access Generation Automation (currently Timothy is set to generate 1 day prior).