Can you check your /wp-content/plugins/ns-google-sheets-connector/logs directory and see if there is any info in a log.txt file? Or you can just click the link on the settings page to download the debug log. Is there anything in that?
When do you have to update the auth code? Every time you visit the settings page? Once it’s set up and working you shouldn’t have to do that again. Or do you mean something else?
Because the date is making it through, the connection is at least working. But it sounds like your column names might not be identical to your field names. Did you follow the screenshot:
https://ww.wp.xz.cn/plugins/ns-google-sheets-connector/screenshots/
It’s critical that the column names in your google sheet match exactly to the field names in your contact form 7 form. Please double check that and let us know.
Thank you for your answer
– error log is empty
-auth code problem i think is solved
field names are the same.. also case sensitive
but form still sending only first row.
i have a question:
is order rows important?
i.e.
form:
Your-name
Your-email
Your-message
google sheet:
date|Your-email|Your-name|Your-message
thank you for your patience
Hi, i solved…
name of rows (and fields) MUST be ALL lowercase
if you use uppercase or mixed it doesn’t work.
thank you
Yes, the fields must be lowercase – we’ll be sure to make this more apparent in future versions. Thank you for bringing that to our attention. If you have any more issues, please let us know :).
