Hi,
After triggering a zap from Bubble.io (live database), I received in my Google Sheet a date with the following format: 2023-09-23T03:00:00.000+00:00, which is not recognized as a date format by Google Sheet. I need the new data to be recognized as a date by Google Sheet for pivot table updating.
When I tested the action (create spreadsheet row to Google Sheets) within Zapier, Zapier used a date from Bubble development database and created a new row in the Google Sheet with the date being formated correctly: 2021-05-01 13:00:00
What can I do to have the 2021-05-01 13:00:00 formating in the live environment?
Thanks.
Question
Date format issue exporting from Bubble to Google Sheets with Zapier plugin
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.