I resolved issue #4 because I discovered the missing piece in the code was that we were not awaiting the range in the readCell method.
I also resolved issue #3 because I discovered that the value for valueInputOption has been updated to "USER_ENTERED" on the official google documentation.
I resolved issue #4 because I discovered the missing piece in the code was that we were not awaiting the range in the readCell method.
I also resolved issue #3 because I discovered that the value for valueInputOption has been updated to "USER_ENTERED" on the official google documentation.