Forums

Trying to save data in google spreadsheet using 'Google Spreadsheet Save' action.
1>Downloaded beta version of the action from DropBox
I hope, installing the action has replaced earlier action, as I get the same action button as earlier.

2> Changed input fields by adding into array 'GSheet' by adding custon code before the save action.
The fields are showing in array as shown in the screenshot of debugger attached.

3> Updated Google Spreadsheet Save action' into 'On Submit' event as
a>Check that it is enabled
b> Added Google Apps username and password
c> Added the Spreadsheet name
d> Left the Worksheet empty and the Data path as GSheet
4> Created the spreadsheet in google docs & gave field names in the first row (as attached picture)

But It is not getting uodated.
Please help

Hi santosh.karkhanis,

The beta action should be in a new [GH] Custom Actions group in the Setup tab.

Bob

Sorry I did not unzipped the file ChronoForms v5 action gsheet_save_gh UNZIP.zip before installing.
I will follow the instructions & try.

Did this work for you? I am using the GSheet save [GH] action and getting this error: 400 - Error refreshing the OAuth2 token, message: '{ "error" : "invalid_grant" }'. I followed this guide to set it up: http://www.chronoengine.com/faqs/70-cfv5/5233-how-do-i-use-the-google-spreadsheet-save-action.html. It almost worked, but it threw that error when I tried it. Any hints? Thanks!

Erik

Hi Luxhodge,

That is the same error as Albert had before he wrote his FAQ - you might contact him and see what his solution was. There are also some suggestions in this StackOverFlow page

Bob

Thanks for the reply Bob.

It was my error - of course! I uploaded the wrong .p12 sheet to the extras folder on the site. It works just fine now. Thank you for the response! Note: I did setup the credentials for the Google API exactly as the tutorial I referenced in the post so this is the correct way to go. Just make sure you use the correct p12 file. Doh!

Erik