Home Categories Code plugins GSheets Operator

GSheets Operator

Which plugin is right for me? Compare easyCSV, Runtime DataTable and GSheets Operator.

GSheets Operator or “GSO” is a plugin that will allow you to interface with the Google Sheets API via REST the same way you would send cURL commands but wrapped in a simple Blueprint or C++ Interface.

Create new sheets, rename existing ones, query specific cell contents, format cells, download and upload entire sheets to public or private spreadsheets. Convert between CSV and JSON and back again. Write with a light touch to specific cells or ranges. Duplicate sheets you need more of or delete sheets you no longer need.

Display your spreadsheet to your players and end users with an easy-to-use spreadsheet widget. Build and edit your own spreadsheets in-game and put them on Google Sheets.

All of this and more is possible with GSheets Operator.

Support Thread

Documentation

Example Project

Technical Details

Features:

Read specific ranges or download a CSV of your public or private Google Sheets.
Write to public or private Google Sheets in whole or in part. Append, Find & Replace or Delete values and edit formatting.
Edit properties of the spreadsheet or individual sheets such as time zone, locale, frozen dimensions and whether a sheet is hidden.
Dimensions (rows & columns) can be inserted at an index, deleted at an index, appended to the end, moved from one index to another, be set to hidden or be resized either manually or automatically based on the data the cells in the dimensions contain. You can also automatically delete all empty dimensions.
Duplicate, Retitle, Add or Delete sheets.
Display your spreadsheet to your players and end users with an easy-to-use spreadsheet widget. Build and edit your own spreadsheets in-game and put them on Google Sheets.

Code Modules:

GoogleSheetsOperator (Runtime)

Number of Blueprints Nodes: 117

Number of C++ Classes: 11

Network Replicated: N/A

Supported Development Platforms: Windows, Mac OS, Linux

Supported Target Build Platforms: Windows x64, Android, Mac OS, iOS, Linux

Important/Additional Notes: Requires a Google Service Account (free to set up and use, instructions included) to write to any sheets, public or private.

Jared Therriault

All Assets by Author

98.69 €

Select

Platforms	iOS, MacOS, Windows 64-bit, Android, Linux
UE Versions	4.27, 5.0 - 5.1
Tags	DATA TABLE, RUNTIME, DATATABLE, BLUEPRINTS, SPREADSHEET, DATA DRIVEN, WEB, CSV, TABLES, JSON, DATA PROCESSING, DATA, C
Release date	24.02.2022