I need my zap to create two headers on a new worksheet it is creating. I’m using the “Headers” field in the “Create Worksheet” event to add them manually, as seen here:
However, when I attempt to test using this setup, I get this error as a response:
And the worksheet is created but without any headers:
Is this a bug, or am I just missing something?
Hi there
Colons (:) in spreadsheet and worksheet titles can sometimes cause this error in a Zap. Taking a closer look at your screenshot, it seems that the "Title" field uses the zap_meta_human_now, which includes colons due to the time format.
Could you please try adding a Date / Time Formatter - Format Date step to your Zap? This will help you convert the zap_meta_human_now to a format without the time, avoiding any potential issues with colons. Once you've done that, just map the output of the Formatter step to the "Title" field.
Please give that a try, and let me know how it goes. 
That worked, thank you
Hi
Awesome! I’m glad that worked!
If you have any other questions, please don’t hesitate to reach out to the Community. We’re always happy to help!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.