Data added to different columns in Google Sheet

Hello @darkdippy

Sorry for the trouble.

This should not happen, make sure you are not using any formulas or scripts in this sheet and also in above-filled entries you are not adding any rows manually.
This issue is might be because of some formatting glitch for sure.
You can check the demo sheet I have created and it’s filling perfectly. Let me know with a screenshot to troubleshoot further.

Thanks
Abdullah

I’m also weirdly having the same issue! It was working yesterday, now all of a sudden it seems to be formatting the new entries on the end of the last column. Any further help would be great,

Hello @wbdlc

Have you updated plugin from 4.0 to 4.4? or updated automatically?
Then please reauthenticate once with google to solve the issue.
make sure to go through all the common issues listed here and Also look at here

Feel free to let me know further.

Hi @westerndeal,

Thanks for the plugin!
I had the same problem (v4.4, just installed this).
After some digging around, I think I found the problem:
In the file : ./lib/google-sheets.php
line 166: $range_new = $worksheet_id;
Basically you append to the cell which has the tab-name.
So, in my case, my tab name “cf7” (I renamed it from “Sheet1”), it was adding data in cell “CF7”.
I hope this helps!

The quick workarround – rename your tab “A2” (and change the name in config in the form as well). This will add your data in the “columnn A”.

Keep up the good work!