This plugin works very well with a first CF7 form connected to a Google sheet, but when I add a second form connected to a second sheet, after clicking “Submit” it keeps working. an email confirmation is sent but there is no add to the sheet. What could be wrong…?
Thanks a lot for your support!
The page I need help with: [log in to see the link]
Thanks for your answer! Yes, I have done that for each form, also because I need different tags for different forms.
The Google API and the “Current service account email” are the same for all forms, aren’t them?
Yep, actually I don’t see necessary to support multiple google service accounts on one website.
Try to go through this checklist:
1) Make sure Spreadsheet URL and ID is correct.
2) Make sure your service account email added to spreadsheet “edit” access group.
3) Go to console developers dashboard and check if there are any errors (and total amount of requests is correct?)
I checked you list and everthing seems ok… The email keeps arriving but the submit process doesn’t rach the confirmation message and the data are not written on the sheet.
could it be something connects to the two CF7 forms, that are very similiar, with the same tags, but in 2 different languages?
Let me know if there is any capture images I could send you to undestand better, thanks!
I have deleted the edit on the form and create it again, but the situation is the same…:
What can it be? On the other similar form it works so fine…
Thanks for your kind help!
- This reply was modified 2 years, 1 month ago by stefanando.
Try to make your spreadsheet public for a minute and send form when it’s public.
If form arrives correctly – you have issues with permissions.
W8 for your response.
I tried but also with a public form the situation is the same…
I have shared with the current service account email the Google Drive folder containing my sheets and now (I don’t know why, but I accept life mysteries…:-)) it works fine!
Thank for your kind support, I really appreciated that!
Just a last question: the time written on the sheet is 2 hours back compared by our Italian time of form submitting. There is any way to fix it?
Thanks again, I have left a review and will be happy to make a small donation, but I didn’t find a way to do that.
About time – our plugin it’s just a middleware between CF7 and google sheets. It don’t control data, generated by CF7 (in email should be the same date).
I looked into CF7 docs, but unfortunately I haven’t found any tips about timezones.
BTW: I have bitcoin wallet for donations, I’ll configure donation link as other developers do (in left column of plugin page) in future releases.
I glad that you found solution!
- The topic ‘Not working with a second form/spreadsheet’ is closed to new replies.