node-google-spreadsheet
node-google-spreadsheet copied to clipboard
Insert Datetime value with timezone
I have several users from different time zones.
Currently, my server script is sending: date.toUTCString()
to the spreadsheet but it will add a cell with the timezone of my server.
Is there a way to directly send the Date so that it will be formatted with the spreadsheet viewer timezone?
I'm really not sure, but I don't think google sheets has great support for this. If you can figure out how to handle this in the raw google sheets api, then I'm sure we can add support if something is missing on this end.
combining into #630