Table Of Content
Quick Guide
Video Guides
Getting Started
UI Settings
UI Layout
Widget Panels
F. w. Preview
Designer
Variation Actor
Cost Tracking
Data Tables
CSV Export
Scene Settings
Blueprints
Gamemode
VR projects
Connect BP
FAQ + TIPS
Fix Known Bugs
Version History
CSV Export To Sheet
Steps to connect and update a google sheet from within the UI3.
Content:
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:- user_FEATURES SHEET - with all features with preview presets
- user_SELECTIONS SHEET - with all selected choices
- user id and name
- unit selected and base cost
- links to the google sheets
Allow editing for the sheets
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
Main Menu Event Graph
Add a Custom Event to the Event Graph of the main menu called Write To Selection Sheet.Set the nodes up as shown in the image. This requires the Run Time Data Table Plugin.
The spreadsheet link is stored in a variable in the Info Map.
The event Write CSV to Sheet can only be in an Event Graph to function proper.
There should be no red text in the output log if the widget button is clicked. Otherwise read what the problem is.
Data Sheet Actions
Open the function Data Sheet Actions in the Main Menu and add the Custom Event Write to Selection Sheet that you just created.NOTE the two sheets need to be exported in sequence. First the Features and then after the result is back the Selections.
Access Key Data
Open the JSON file you'll get after creating the security key on Google. It should look like the image.Copy Paste the Private Key into the private key variable into the Info Map Data and Reports section.
Copy the Client Email Adress below the key into the email variable
NOTE: the wrong sheet ID may be extracted from the plugin node. I'm still investigating. You can try to manually put the ID into the node.
Top of page