I integrated podio and google sheets through Zapier. I wanted to have timestamp on the google sheets once there is a new form submitted on podio. However, the timestamp shown is in GMT, but my actual timezone is actually GMT +8. I have already changed all the timezone to GMT +8 in the settings (Podio, Google Sheets, Zapier), but the timestamp still showed up as GMT timezone.
May I know how do I solve this? Thank you.