In order to bring in data from Google Sheets the date has to be formatted in one of the accepted date formats.

To view the accepted formats click "Format"-->"Number"-->"More Formats"-->"More dates and time formats..."

Did this answer your question?