Closed Facing Error to send Correct Data To Google Sheet

[sdanishuddin94]

Hi mate i hope you all are fine. i need your help i am trying to automate my google leads form to google sheet but the issue i face not sending proper phone number some time it send date on phone columb some time it send example answer

 

[Preeti Paryani]

Hi @sdanishuddin94,

Thank you for sharing the details.

This issue usually occurs when the data coming from the trigger source is not structured consistently or the fields are getting shuffled, due to which the values are mapped incorrectly in Google Sheets (e.g., phone number appearing under the date column).

To investigate this further, we will need access to your workflow.

Kindly share your workflow URL, so we can review the mapping and assist you in resolving the issue accurately.

Looking forward to your response.

 

[sdanishuddin94]

here is my workflow URL

Pabbly Connect

connect.pabbly.com

 

[Preeti Paryani]

Hi @sdanishuddin94,

Thank you for sharing the workflow.

We have added a Code (JavaScript) step to help you standardize the form response and avoid field shuffling issues.

Please follow these steps:

1. Go to the trigger step (Google Ads).
2. Change the Response Format to Advanced.
3. Click on Re-Capture Webhook Response to fetch the data in array format.
4. You will now receive user data as an array.
   
   
   

Next:

1. In the Code step, map this array in place of the placeholder (“map the array here”).
2. Save and send a test request.
   
   
   

This will return structured key-value data (e.g., PHONE_NUMBER, EMAIL, etc.), which you can directly map in the Google Sheets step.

This ensures that data is always added to the correct columns and prevents any shuffling issues going forward.

Please test this setup and let us know if you need further assistance.

 

[sdanishuddin94]

I try Both i am facing error

 

[sdanishuddin94]

Also done this

 

[Preeti Paryani]

Hi @sdanishuddin94,

It appears that the user column data was not mapped correctly in the Code step, which caused the issue.

We have now corrected this on your behalf and also mapped the Code step response properly in the Google Sheets “Add New Row” action. The workflow should work as expected now.

Kindly add a test lead and monitor the workflow for upcoming entries. Please let us know if you face any further issues.

 

[sdanishuddin94]

This is also not coming in a proper format

 

[Preeti Paryani]

Hi @sdanishuddin94,

The issue is occurring because you have selected the Email Content Type as HTML, but the content you’ve provided is in plain text format.

To resolve this, you can choose either of the following options:

1. Switch the content type to Plain Text and test again.
2. Or, format your content properly in HTML (using tags like <br>, <p>, etc.).

Alternatively, if you prefer to keep it simple, you can use \n for line breaks in plain text format.

You may also refer to the help link provided in the action step to structure your email content in HTML correctly.

Please try this and let us know how it goes.

 

[sdanishuddin94]

Thank you so much Preeti for your support, I really appreciate it.

Now I’m waiting for my next lead. I hope this time I will get a proper response. If not, I’ll reach out here again and message you.

Thanks again!

 

[Preeti Paryani]

Sure, please let us know how it goes.

 

[sdanishuddin94]

Sure, please let us know how it goes.

Sure

 

[sdanishuddin94]

Thank you Preeti now it's Work perfect thankyou so much.

 

[Preeti Paryani]

Hi @sdanishuddin94,

Glad to hear everything is working smoothly now!

Since your concern has been resolved, we’d really appreciate your feedback:

• https://forms.gle/GAjS4wdPYKuhnEYV9
• Google Review

PS: We are closing this thread as the issue is resolved. Please feel free to reach out to us if you face any issues in the future.