Google Sheets Zapier - Date Column

Was wondering if anyone can tell me if it is possible to update the date column in monday using a google sheet. I have been able to get standard things like numbers and text to work properly but keep running into a wall with the date column. Maybe it is not possible but unfortunately cant use a text column in Monday because we want to utilize the reporting and dashboard functions

1 Like

Hey there @Tyler_S :wave:

I’m sorry this has been somewhat complicated to set up and I appreciate you reaching out to us - I hope the community will be able to help you find a solution.

As far as I understand, this should be possible to set up via Zapier. Have you had a chance to look at the Zapier JSON formatting examples here?

# Zapier JSON Formatting Examples

The date information will have to be formatted a specific way when passing it to Monday.com:

  • Date Column with No Time - {“date”: “2020-12-03”}
  • Date Column with Time - {“date”: “2020-12-03”, “time”: “13:25:00”}

As far as I understand, Google Sheets have multiple formatting options, so perhaps it might make sense to try and align the two together. Here’s what I could find as far as formatting examples go for Google Sheets:

https://developers.google.com/sheets/api/guides/formats

I hope this helps :slight_smile:

-Alex