Google Doc to Data Table UE5 plugin

General information

UE5 Editor plugin that provides a convinient way for importing data from google spreadsheet into UE5 data table. Forked from https://github.com/riperjack/ue4_googledoc2datatable

Clone the repository
Unzip and copy GoogleDoc2DataTable folder into "your_ue5_project_folder/Plugins/". If Plugins folder does not exist in your project, just create it.
Open your project in UE5
Go to Edit -> Plugins -> Other. Enable GoogleDoc2DataTable

This version of plugin needs an engine modification to store google docs url per data table asset, so we won't have to enter URL each time editor is restarted, or working with more than one data table.
Add FString SourceURL variable into UDataTable class header in engine source. Make it blueprint EditAnywhere.
Add SourceURL = SourceTable->SourceURL; call into UDataTable::CopyImportOptions function to be able to copy SourceURL data while fetching data from google docs and recreating the data table.

Right click in a content browser, select: Blueprints -> Structure
Create a structure that matches data in your spreadsheet. Keep in mind that UE5 treats the first column as a lookup and handles it automatically so you don't need to create it in the Structure. More information on that here: https://docs.unrealengine.com/en-US/Gameplay/DataDriven/index.html
Create a datatable ( right click in content browser: Miscellaneous -> DataTable ) and select structure you created in previous step
Right click on the datatable. In the context menu you should see and option "Load from Google doc" ( 4th row from top ).
A new window will appear. Enter your spreadsheet id into the input field. What is spreadsheet id ?

then spreadsheet id is this part: 1YjC78QtDrHQzsyz7vNAWWetlKUNEgID3gjA1S0svFys

Important: Your spreadsheet needs to have public sharing turned on. Otherwise it will not work.

Works only with public spreadsheets ( link sharing has to be turned on ). Authorization was not implemented yet.