GSheets Operator

Jared Therriault - Code Plugins - Feb 24, 2022
2
5 out of 5 stars(2 ratings)
  • 100%
  • 0%
  • 0%
  • 0%
  • 0%
See 2 written reviews
2 reviews written
19 of 19 questions answered

Interface with private Google Sheets, import and export to and from Google Sheets, edit in-game spreadsheets and more!

$99.99Sign in to Buy
  • Supported Platforms
  • Supported Engine Versions
    4.27, 5.0 - 5.3
  • Download Type
    Engine Plugin
    This product contains a code plugin, complete with pre-built binaries and all its source code that integrates with Unreal Engine, which can be installed to an engine version of your choice then enabled on a per-project basis.

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.

Tags

DATA TABLERUNTIMEDATATABLEBLUEPRINTSSPREADSHEETDATA DRIVENWEBCSVTABLESJSONDATA PROCESSINGDATAC

Related Content