Hi
Getting Google Sheets to use the right format can be tricky. The first thing I would recommend is to change the format in the Sheet. To do that:
Highlight the column
Click ‘Format’ in the menu and select the date format that you’d like:
If you’d like to change the format of the information before it’s passed to Google Sheets, you can use Formatter by Zapier to do that. You need to add a Formatter step before the Google Sheets step and select the ‘Data/time’ option. Then select the option to convert the date and choose the format to which you’d like to change the date from Gmail. When you test the Formatter step, you’ll see that it’s changed the date to the format that you need. From there, use the output of the Formatter step in the Google Sheets step and you should be good to go!
Let us know if you have any questions!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.