Pages in Documentation

../images/architecture/2024/door-settings/thumbs/03.jpg
Settings
../images/architecture/2023/ui32/thumbs/01.jpg
UI3 Overview
../images/architecture/2022/doorsv2/thumbs/01.jpg
[old] Doors UE5
../images/architecture/0040/quick/thumbs/01.jpg
Quick Start
../images/architecture/0040/swap/thumbs/01.jpg
Swap Actor
../images/architecture/0040/custom/thumbs/04.jpg
Custom Assets
../images/architecture/0040/system/thumbs/01.jpg
System Drawings
../images/architecture/0040/steps/thumbs/12.jpg
Step by Step
../images/architecture/0040/faq/thumbs/01.jpg
Tips & FAQ
../images/architecture/0040/settings/thumbs/03.jpg
Settings
../images/architecture/0033/csv_export/thumbs/03.jpg
CSV Export
../images/architecture/0033/data/thumbs/04.jpg
Data Tables
../images/architecture/0033/videos/thumbs/01.jpg
Video Guides
../images/architecture/0033/videos/thumbs/01.jpg
Quick Videos
../images/architecture/0033/designer/thumbs/02.jpg
Designer
../images/architecture/0033/cost/thumbs/02.jpg
Cost Tracking
../images/architecture/0033/features/thumbs/08.jpg
Widget Panels
../images/architecture/0033/quick/thumbs/01.jpg
Quick Guide
../images/architecture/0033/settings/thumbs/16d.jpg
Scene Settings
../images/architecture/0033/connect/thumbs/02.jpg
Connect BP
../images/architecture/0033/vr/thumbs/03.jpg
VR projects
../images/architecture/0033/history/thumbs/01.jpg
Version History
../images/architecture/0033/preview/thumbs/01.jpg
F. w. Preview
../images/architecture/0033/bugs/thumbs/01m.jpg
Fix Known Bugs
../images/architecture/0033/design/thumbs/01t.jpg
UI Settings
../images/architecture/0033/layout/thumbs/02.jpg
UI Layout
../images/architecture/0033/game/thumbs/07.jpg
Gamemode
../images/architecture/0033/faq/thumbs/08.jpg
FAQ + TIPS
../images/architecture/0023/v4-functions2/thumbs/05.jpg
V4 Functions 2
../images/architecture/0023/v4-functions/thumbs/01.jpg
V4 Functions P1
../images/architecture/0023/v4-quick/thumbs/01.jpg
V4 Quick Guide
../images/architecture/0023/history/thumbs/02.jpg
Ver History
../images/architecture/0023/v3-placements/thumbs/02.jpg
V3 Placements
../images/architecture/0023/v3-mesh/thumbs/02.jpg
V3 Mesh Def.
../images/architecture/0023/v3-segments/thumbs/03.jpg
V3 Segments
../images/architecture/0023/v3-quick/thumbs/01.jpg
V3 Quick Start
../images/architecture/0021/v2/thumbs/01.jpg
Books V2
../images/architecture/0021/v1/thumbs/01.jpg
Books V1
../images/architecture/0019/custom/thumbs/01h.jpg
Customize
../images/architecture/0019/overview/thumbs/00b.jpg
Quick Guide
../images/architecture/0019/swap/thumbs/01.jpg
Swap Actor
../images/architecture/0019/faq/thumbs/01.jpg
FAQ + TIPS
../images/architecture/0019/v2/thumbs/01.jpg
Doors UE4 (V1)
../images/architecture/2021/ui3-bugs/thumbs/02.jpg
3.1 Bugs Fixes
../images/architecture/0040/history/thumbs/02.jpg
Ver History
../images/architecture/0023/v2-generic/thumbs/01.jpg
V2 Generic BP
../images/architecture/0023/v2-examples/thumbs/01.jpg
V2 Examples
../images/architecture/0023/v1/thumbs/01.jpg
V1 Railings Fences
../images/architecture/2019/guide1/thumbs/01.jpg
UI 1 - Part 1
../images/architecture/2018/03/thumbs/06.jpg
UI 1
../images/architecture/2019/guide2/thumbs/01.jpg
Ui 1 - Part 2
../images/architecture/2019/ui2/thumbs/01.jpg
1 Overview
../images/architecture/0013/features/thumbs/04.jpg
UI2 Features
../images/architecture/0013/start/thumbs/01.jpg
UI2 Get Started
../images/architecture/0013/infomap/thumbs/06.jpg
UI2 Info Map
../images/architecture/0013/actors/thumbs/01.jpg
UI2 BP Actors
../images/architecture/0013/users/thumbs/01.jpg
UI2 User Manager
../images/architecture/0013/faq/thumbs/03.jpg
UI2 FAQ
../images/architecture/0013/tutorials/thumbs/06.jpg
UI2 Tutorials
../images/architecture/2021/ui3/thumbs/01.jpg
UI3 Overview
../images/architecture/0033/start/thumbs/02.jpg
Getting Started
../images/architecture/2021/ui3-infomap/thumbs/02.jpg
3.1 Info Map
../images/architecture/0033/variation/thumbs/01.jpg
Variation Actor
../images/architecture/0033/other/thumbs/02.jpg
Blueprints

CSV Export To Sheet

Steps to connect and update a google sheet from within the UI3.

Content:

CSV Sheets

Create a Google Service Account

Data Sheet Actions

Main Menu Event Graph

Access Key Data

CSV Sheets

Create the following Google sheets in Drive. Use the Export function in the Data Table and Sheets widget to create local CSV files and import them to Sheets as a start:

image
Create a Users Sheet that holds
  • user id and name
  • unit selected and base cost
  • links to the google sheets

Allow editing for the sheets

image

Create a Google Service Account

You'll need a Service Account for the Google Cloud.

Follow the steps in the link to create one.

Create an API key as explained.

Enable the API to work

Runtime DataTable Plugin Documentation

image

image
Connect this part to the pin Call On Complete. It just sends a message to the screen but is required to function.

There should be no red text in the output log if the widget button is clicked. Otherwise read what the problem is.

image
You can get the Sheet ID from the URL or use the node provided in the plugin.

image

image

image

image
Top of page