Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

Incorrect event duration and missing dealer name in Google Calendar Zap

A

My team and I are trying to create a Google Calendar event that is triggered by when an install is scheduled in a deal on HubSpot.

 

We have figured out how to get the event to show on the right day and to show the name of the deal, but the duration (start and end time) is wrong, also the name of dealer does not show.

 

If anyone’s had issues like this and has figured out how to get around it, please inform us!

 

Thank you!

Best answer by Troy TessaloneBest answer by Troy Tessalone

@Amr Ghamian

Try these tips:

  • The UNIX timestamp is in milliseconds, so essentially you are providing 2 times in 1 field.
  • You would need to perform data transformations to get just the date from the UNIX timestamp
  • Formatter > Date & Time > Format
    • Format TO: YYYY-MM-DD
  • Remove the time zone (cst)
  • Remove “at”

 

 

 

 

View original
Did this topic help you find an answer to your question?

5 replies

Troy Tessalone
Forum|alt.badge.img+14

Hi @Amr Ghamian 

We would need to see screenshots with how your Zap steps are outlined and configured to have context, thanks.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
A
1 person likes this
  • A
    Amr Ghamian
A
  • Amr GhamianBeginner
  • Author
  • Beginner
  • 4 replies
  • February 16, 2024

@Troy Tessalone 

 

Thank you for your response, I have attached the relevant screenshots to help you understand how we went about it. We also did figure out how to add the dealer’s name into the calendar event, now the main problem will be the duration.

Thank you

Troy Tessalone
Forum|alt.badge.img+14
  • Troy TessaloneZapier Expert
  • Zapier Expert
  • 30942 replies
  • Answer
  • February 16, 2024

@Amr Ghamian

Try these tips:

  • The UNIX timestamp is in milliseconds, so essentially you are providing 2 times in 1 field.
  • You would need to perform data transformations to get just the date from the UNIX timestamp
  • Formatter > Date & Time > Format
    • Format TO: YYYY-MM-DD
  • Remove the time zone (cst)
  • Remove “at”

 

 

 

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
ken.a
A
2 people like this
  • ken.a
    ken.a
  • A
    Amr Ghamian
A
  • Amr GhamianBeginner
  • Author
  • Beginner
  • 4 replies
  • February 16, 2024

@Troy Tessalone Thank you so much brother, we got it figured out even though we struggled a bit with the formatter tool. We had to play around with the inputs and look at videos alongside it, but solved at last!

 

Troy Tessalone
ken.a
2 people like this
  • Troy Tessalone
    Troy Tessalone
  • ken.a
    ken.a
ken.a
Forum|alt.badge.img+6
  • ken.aZapier Staff
  • Zapier Staff
  • 6380 replies
  • February 16, 2024

That’s an amazing news @Amr Ghamian! A huge thanks to Troy for pointing you in the right direction!

Happy Zapping! ⚡️

A
1 person likes this
  • A
    Amr Ghamian

Reply


Terms & Conditions