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
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
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.
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
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
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
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
This topic is locked and no more replies can be posted.
