Not working with a second form/spreadsheet

Hello @stefanando
Have you clicked “Save” button on third tab of plugin? (“output”)

It should be clicked to initialize post_meta. It should be clicked one time for each form in selectbox.

• This reply was modified 4 years, 8 months ago by moshensky.

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!

@stefanando
I’ve just looked to your form and found, that it hasn’t permissions to write to google sheet.
Please, make sure you granted “edit” access to your spreadsheet by service account email.

View post on imgur.com

I have deleted the edit on the form and create it again, but the situation is the same…:
https://drive.google.com/open?id=1rXREA1WKW1onN-SF-dneoURIn61AVOMx
https://drive.google.com/open?id=1jEfD1nFqGmeR1p-HgZaYEfgcGw-J1il5
https://drive.google.com/open?id=1ElMN2rQ1-4GWPlsDaFilklZeddneopS8
What can it be? On the other similar form it works so fine…
Thanks for your kind help!

• This reply was modified 4 years, 8 months 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.
https://contactform7.com/special-mail-tags/

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!