Hi,

I’ve set up an automation to trigger from a row inserted into google sheets.

In this sheet I have a column that is today’s date.

It is formatted as a date column.

I’m attempting to set a date field in Airtable based on this and it’s telling me it cannot insert a string into a date field.

How do I set a date field to today’s date when creating a new row through automation please?