[HELP] Can read from Google Sheet but cannot write to Google Sheet

Development Pipeline & Plugins
, , , , ,
1

I am using Runtime Data Table plugin to read and write data to Google Sheets.
I am able to read information the text from a Google Sheet as seen in this screen shot

read google sheet unreal engine
read google sheet unreal engine1140×57 5.86 KB

However, when I tried writing that information to another Google Sheet I got this error
ue5 error

I have checked my Google Service Account data and private key file and everything matches and is in the correct format so I do not know why is this even happening.

Before anyone says this, I have tried to contact the plugin developer but he appears to be busy at the moment so I am resorting to this for help.

2

Could it be that you copied / pasted the private key information with a trailing space and or wrong encoded end of line symbol throwing off the authentication?

3

There was no need for me to do that since the plugin has a node that just automatically reads information from the JSON and gets the key from there.

I even tried it on the plugins provided demo and it worked fine. I even copied/rebuilt the nodes on the demo into my project node for node to be exactly the same and still I am unable to make it work