Calendly To Google Sheet Contact Number Error Showing.

Status: Closed · Asked by MUBIN PATEL on Nov 30, 2023 · 0 views

mubinpatel — Question · Nov 30, 2023

I am attempting to automate the process of transferring my Calendly information to a Google Sheet, but I am facing an issue where the contact number is not displaying correctly; instead, an error is showing. Please help me.

Arshil Ahmad — Reply · Nov 30, 2023

Hi @mubinpatel,

Could you please share the Workflow URL in which you have this concern?

mubinpatel — Reply · Nov 30, 2023

https://connect.pabbly.com/workflow/share/XBRXZVQDVzReFFc9UgFWcV9LBAAGX1QxVUwGFFFeUSkEXgRvURBdNwlFBScFRgBhVRwHbQVZAToMGFJWA1VUJ1BJAxEBAlIoAE1TYARNDzxcAld_VDU#

Arshil Ahmad — Reply · Nov 30, 2023

The issue appears to be related to Google Sheets treating the + prefix in your phone number as a formula. I have added a Text Formatter to your workflow to remove the + sign. You can map this number to your 'Add New Row' action step, which should fix the issue you are encountering.

mubinpatel — Reply · Dec 1, 2023

Thank you, brother, and I learned a lot from this. Once again, thanks.

Back to all forum threads · Log in to reply