• 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

Data is in wrong columns in google sheets

P

Pabblymember11

Guest
Hey @niels.przybilla

Can you please reconnect the Google Sheets action step and then try again?

1690367554147.png
 
Hi. Yes I did.
I think the issue ... somehow the order ... Pabbly does not show the same order like in my google sheet.
But it is adding the fileds in the same order like in the google sheet.
thats why it puts Fbclid data on third columen even if it is another column
Monosnap Pabbly Connect 2023-07-26 18-16-28.jpg
 
P

Pabblymember11

Guest
It appears that you might have done some changes in your Google Sheets after configuring the action step.

So, we recommend you if you make any changes in the Google Sheets then kindly reconnect the action step and reconfigure it to avoid such discrepancy.
 
P

Pabblymember11

Guest
Kindly remove the Google Sheets action step once and then configure it.
 
@Supreme I reserached more. It seems to be related to the field naming
1. I created a new google sheet and copied the column names. Same wrong results
2. Now i renamed the columns from 1 - 45 ... and now in pabbly it shows the right order
3. Now i renamed back ... and again it is wrong.

I figured out the problem. The first 6 columsn had the same title. That seem,s to confuse pabbyl as it seems to refrence on the title and not the static column Like A, B, C ,...


Monosnap Pabbly Connect 2023-07-28 05-54-50.jpg
 
P

Pabblymember11

Guest
If you do not want to change the column name then you can try using the "Append Value" action step.

1690531818444.png


 
Top