[Feature/Addition] Add option for USER_ENTERED flag in Google Sheets #1123
Labels
enhancement
Impact - something should be added to or changed about Parsons that isn't causing a current breakage
When I was trying to write some date/datetime data to Google Sheets, the data gets entered as a string (e.g.
'2024-01-01
instead of2024-01-01
), which ran into a bit of trouble with some data not registering as a date for the spreadsheet.Possible Implementation
Gspread has a
USER_ENTERED
flag (https://stackoverflow.com/a/62359273) that we can use. Just add an optional argument to set this flag in the writing method (overwrite sheet, append to sheet, paste to sheet).Priority
I can work on this PR. I am able to work around this with Google sheets format coercion (setting the format as date/datetime) but I'd like to eliminate this step.
The text was updated successfully, but these errors were encountered: