REALTIME DATA AT RUNTIME - IMPORT FROM GOOGLE SHEETS - UNREAL ENGINE - UE4 - UE5

[@RobFisherUK]

This is fantastic. I already have tooling that gets my data into CSV files but one of the things I thought might be hard is getting UE4 to read these files. The answer: a plugin. Fair enough! My other problem is going to be just getting the hang of UE4. I'm not entirely sold on the idea of programming visually, but if that's what the cool kids are doing these days I'm guessing trying to fight it is a fool's errand (presumably you can edit blueprints as text files but I need to just go with the tutorials rather than forge my own path if I want to get it working quickly). Anyway, these videos are really helping, so thanks!

[@MIKELENZTIPS]

Thanks Rob. I’m a blueprint fan. Just takes a while for things to click!

[@mohammadsayed8098]

thanks for the great tutorials, i would like to know if I can change one cell inside unreal using blueprints then save the csv file

[@ukkusu]

So theoretically you can create universal chat screen in ue which is translating your words instantly to any other languages via google sheets =GOOGLETRANSLATE formula! Thanks a lot!

[@MIKELENZTIPS]

Interesting - that formula news to me - so would be good to know if it works?

[@archiep9162]

How are you defining an array of strings in the Sheets?

[@MIKELENZTIPS]

The best way to understand formatting - is create a data table and export that as a .csv - then you’ll know how to format all you variable types

[@vivekpatel7403]

thank you...really useful... one question... in my app I just want to check serial no. while using the app, after few minutes it ask for serial no. when he enters the provided serial no he can use the app. can I store my serial nos online & check at runtime ? not sure how to do it?

[@MIKELENZTIPS]

yes absolutely - have your serial numbers in a column and search that column with a FOR EACH WITH BREAK (and then run through the rows) when it find the serial number - break the for each and set a bool / or trigger a 'welcome' event

[@WildChildStudios]

@@MIKELENZTIPS thank you so much...let me try

[@recsund]

Hi there , great channel, great work! / I know this vid 1 year old now but the 'Update Object or Struct Array From Public Google Sheets Or Local CSV" has gone! do you know what node replaced this in Runtime Data Table ? cheers

[@MIKELENZTIPS]

This is from a plug-in - not standard blueprint nodes

[@recsund]

@@MIKELENZTIPS Yes mate, I got it!, but must of been updated !?, your documentation the most I can find on it, I mean the documentation that came wth it is great but pictures would help

[@MIKELENZTIPS]

@@recsund ah yes I think so. But there should be documentation

[@aramlc]

is there a way to get separate nodes for every row of the csv? sorry I'm new to blueprints

[@playdarkion]

Really curious how would you go about linking a row with a static mesh to create an item with stats for example

[@MIKELENZTIPS]

Not sure I quite get what you are trying to achieve

[@playdarkion]

I wanted the google sheets information to be linked with items inside unreal engine so i can update their stats via the sheet. My solution was to add a row of directory paths that point to the location of specific items in my project. Commenting this for other people that might stumble the same problem :)

[@MIKELENZTIPS]

@@playdarkion give me some context. What items and what stats?

[@playdarkion]

For example an ingame shop displaying items and when you click on an item it displays the static mesh with a list of stats that are fetched from the google sheets My initial problem was how to link a specific mesh to a row of stats like damage, weight, cost etcetera

[@MIKELENZTIPS]

@@playdarkion why do you need it to be from a Google sheet vs an in engine data table?

[@luxjorge]

Can I use it for Unreal 5?

[@MIKELENZTIPS]

yes

[@VVLGANESHK]

Is there any plugin for fonts to import in runtime

[@MIKELENZTIPS]

A quick search of the marketplace reveals yes 👏 up to 4.26: www.unrealengine.com/marketplace/en-US/product/load-ttf-font-at-disk-with-runtime - ⚠️ although I THINK this is just from local disk rather than from a server - perhaps reach out to the developer and make a request? 🙏 What are you trying to achieve

[@VVLGANESHK]

@@MIKELENZTIPS wow . Thank you that's actually pretty helpful. I am working like paint and graffiti like thing

[@MIKELENZTIPS]

@@VVLGANESHK 👌

[@kunyan6633]

Great tutorial and thank you!! I've tried with it before and it works as a charm!! However due to recently version update, the code are very different now , have you try that?

[@MIKELENZTIPS]

No I haven’t. I need to on another project so will review. I know Jared also who wrote the plug-in

[@fouadelsadany4939]

how to make it work with UE5 ?

[@quarckstudio]

same for me :D i'm super new to unreal and it would be amazing to just see a step by step example of rotating a cube through the google spreadsheet. :D