GSheets help needed

Hi,

I'm having trouble using ChronoForms to output to a Google Spreadsheet. Here's my settings, hope it's enough to help troubleshoot:

General tab
Form Name: 2015DBNSWRace4
Form Description: 2015 - 2016 DB Season, DBNSW Race 4

Designer tab
I have 4 fields here:
Field Name: GSheet[yesorno]
Field ID: yesorno
Field Name: GSheet[paddlername]
Field ID: paddlername
Field Name: GSheet[distancechoice]
Field ID: distancechoice
Field Name: GSheet[comments]
Field ID: comments

... and a submit and reset button
Field ID and Name: submitbutton
Field ID and Name: resetbutton


And as for the Setup tab, I've done as per the instructions, entering my Google username and password, and the name of the sheet. I've taken care to make the name with no space between the characters.

However, when I submit, I get the following:

Data Array

Array
(
[option] => com_chronoforms5
[chronoform] => 2015DBNSWRace4
[event] => submit
[GSheet] => Array
(
[yesorno] => Yes
[paddlername] => Help
[distancechoice] => short
[comments] => dd
)

[submitbutton] => Submit
)

Array
(
)

Errors

Array
(
)

Debug Info

Array
(
[2] => Array
(
[Google Spreadsheet Save] => Array
(
[Authentication] => Failed
)

)

)

It seems that it's somehow saving to an empty array and then failed... am I right?

I've also tried creating an app-specific password (after having to go through Google's annoying 2-factor authentication) but no luck.

Here's the form if you're interested in seeing the error output.

http://www.pacificdragons.com.au/pdstest/index.php?option=com_chronoforms5&chronoform=2015DBNSWRace4

If you can help me that would be great, thanks!

Hi albs,

Please see this FAQ - you probably need my beta version with the new authentication methods.

Bob

Hi Bob,

Thanks for your help. I've tried using the beta version, and if I use my account's email address, I got the below:

400 - Error refreshing the OAuth2 token, message: '{ "error" : "invalid_grant" }'

And if I use the service account's email address, account-1@pacific-dragons.iam.gserviceaccount.com, I get the below error message:

Error calling GET https://www.googleapis.com//drive/v2/files: (403) Access Not Configured. The API (Drive API) is not enabled for your project. Please use the Google Developers Console to update your configuration.

Any ideas? I've entered the client ID received from Google, and the sheet values are done correctly...

Hi albs,

There are a couple of suggestions here - this is a problem at the Google end so I don't have any real ideas. I just know that I got it to work OK.

Bob

Hi Bob,

I managed to get it working in the end. For the sake of future users, would you like me to make a quick user guide for the beta version process? I can make one with screenshots etc.

Albert

Hi Albert,

Yes please ;-) Thank you for offering.

Bob

Hi Bob,

No worries - it's how things stay accessible to us all I guess!

Regards,
Albert Au - Sydney Australia