• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

    🚀🚀Exclusive Discount Offer

    Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -
     

    🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) -  View offer 

    🔥 Pabbly Subscription Billing One Time Plan for $249 (🏆Lifetime Access) - View offer

Improper Matching In Google Sheet Problem

Hello guys,
I really need help with this workflow from "Elementor Forms" to "Google Sheets"
Each time the elementor form is filled, the data goes into Google Sheets, however, there is always a mismatch with a particular data for a column.
See the attached Images for the Google sheet and the elementor form mapping.

In the Google Sheets, column AE (5th Follow-Up) keeps collecting the "Form Name" data instead of it to be displayed in column AG (Lead Source) as mapped in the pabbly connect workflow.
Please any form of help to fix this would be appreciated. I would like to have the form name appear under the AG (Lead Source Column).
 

Attachments

  • Screenshot 2024-01-07 095230.png
    Screenshot 2024-01-07 095230.png
    95.1 KB · Views: 41
  • Screenshot 2024-01-07 095138.png
    Screenshot 2024-01-07 095138.png
    55.3 KB · Views: 46

ArshilAhmad

Moderator
Staff member
Hi @toplinedropship,

Could you please share the Workflow URL in which you have this concern? I would also suggest you try using 'Append Value' action step and see if this fixes the issue for you.
 

ArshilAhmad

Moderator
Staff member
Please try using the 'Google Sheets: Append Values' action event to add data to your Google Sheets spreadsheet. This action event is recommended when the spreadsheet contains large number of columns.
 

Supreme

Well-known member
Staff member
Hey @toplinedropship

If you want to exclude certain fields from your Google Sheets using the "Append Values" action, here's a helpful tip: skip those fields this way. When you're in the "Update" action step, choose "Update Row" or "Update Cell Value" and make sure to only include the "Row Index" field. This method will streamline the update process and avoid adding unnecessary information to your sheets.

2024-01-08_17h30_18.png
 

ArshilAhmad

Moderator
Staff member
Could you please record a short video making a form submission in Elementor, workflow executing and data not being added to Google Sheets spreadsheet? Additionally, kindly display the Task History to illustrate the workflow execution.
 
Top