Pages in Documentation
Settings
UI3 Overview
[old] Doors UE5
Quick Guide 2026
Quick Start
Swap Actor
Custom Assets
System Drawings
Guide 2022
Tips & FAQ
Guide 2024
Fix Bugs
FAQ
Cost Tracking
Modes
Other Features
Designer
Edit Scene
Var Actor
UI Layout
New in 2026
Multi-Unit-Prj
Google Sheets
Data Tables
Video Guides
Quick Videos
Designer
Cost Tracking
Widget Panels
Quick Guide
Scene Settings
Connect BP
VR projects
Version History
F. w. Preview
Fix Known Bugs
UI Settings
UI Layout
Gamemode
FAQ + TIPS
Quick Guide
V4 Functions 2
V4 Functions P1
V4 Quick Guide
Ver History
V3 Placements
V3 Mesh Def.
V3 Segments
V3 Quick Start
Books V2
Books V1
Customize
Quick Guide
Swap Actor
FAQ + TIPS
Doors UE4 (V1)
3.1 Bugs Fixes
Ver History
V2 Generic BP
V2 Examples
V1 Railings Fences
UI 1 - Part 1
UI 1
Ui 1 - Part 2
1 Overview
UI2 Features
UI2 Get Started
UI2 Info Map
UI2 BP Actors
UI2 User Manager
UI2 FAQ
UI2 Tutorials
UI3 Overview
Getting Started
3.1 Info Map
Variation Actor
Blueprints
Google Cloud And Sheets
Using Google Cloud and Google Sheets to store and receive data for multi-unit projects.
Useful for projects running on remote servers. Allows real-time updates from a spreadsheet in Google Sheets as well as export of user choices to a Google sheet
Third party plug-ins are required for this to work.
Content:
Google Cloud Project and Service Account
- Rename the existing filename.uasset to filename.old
- Rename the 2nd file filename.xxx to filename.uasset
The files that need to be renamed depend on the UI3 version:
UI3 Version 2026
| BFL_Custom_Report | This file enables the Blueprint File SDK plugin. |
| BFL_Custom_Sky | This file enables the Ultra Dynamic Sky. |
| UI3_MainMenu_GS | This widget enables the Runtime Datatable plugin. |
The new service account should show up in the list. Click on the three dot menu at the right side for Actions.
Choose Manage Permissions and create a Private Key with key type JSON.
Save the key somewhere you can find it as you won't be able to download the key again.
Private Key Data
The key comes as a JSON file and can be opened with Notepad, Visual Studio, or web developing software.
Used are only the
- Private Key - the long cryptic string.
- Client Email - the service account email.
Convert CSV files to Sheets
The files need to be converted to Google Sheets.
- Right click the file
- Choose Open With
- Choose Google Sheets
The file will open after a short while. The files should be ready to use but make sure that the Column Names are spelled correctly.
Google Data Sheets
The following 4 Google Sheets contain the data for the units and the users. UI3 only reads these files.
UI3 Server
- The Row Name or server ID is almost always S001 and doesn't need to be touched. It needs to be the same as set in the Info Map.
- The User ID needs to be set in the Google Sheet before a level is loaded. UI3 will pick the user data with the ID from the Users sheet.
User Choices Export Links
Copy the links for the Export Sheet file into the Row for the user in the Users sheet.
Link List
The Link List array should contain 4 array elements. The Name is just a hint. The link will be pulled by the array id. The Server Sheet link will always be pulled from ID [0], and so on.
Sheet Link
Copy the browser link (URL) from the Google Sheet. Do NOT create a link with the sharing feature.
Sheet ID
The GID can be found at the end of the browser URL. Copy the number or use 0 if there is no GID in the link.
Exporting Cost and Selection Data
The Cost Widget will automatically display a single Export Data button when the scene is set to use Google Sheets.
Clicking the button will export 3 reports to the Google Sheet for the current user.
- Costs contains the same data as displayed in the cost widget.
- Selections or user choices displays all choices the user has selected at that time of the walkthrough. This includes choices that do not have a price assigned. It also gives the default option for the choice to compare the price difference.
- Features or presets displays the last selected presets at the time of the button click. Some preset choices could have been modified by the user.
Top of page