Managing your business with anyPiece/WYSIWYG Web editor/Web designer or programmer/Work with google spreadsheet

Prerequisite Please make sure your form have following field configure into your form Field Name Type Explanation spreadsheet_name hidden The spreadsheet that we will use. It must be created up front. sheet_name hidden Use to check on the sheet that we will use to insert the data Please configure the extrouter web.config as per below To get this client id and client secret, please visit [Google oAuth] Please configure the refresh token Refresh token would be the key token that will enable the system to upload data to your spreadsheet without your user name and password To get refresh token, type http://yourwebsite.com/google_spreadsheet. You will be ask to login under your google mail account Since we have updated one of the component (newton), please update the web.config to below Make sure that you have created the spreadsheet into your google drive with the same name as spreadsheet_name Setup guide on the form Create all the three hidden field as per stated in the Prerequisite Put the form action to "google_spreadsheet" and method to "post" Please make sure all the form have the field which will be sent over from the form to google docs. If there is a missing field, you will get an error like below. Please make sure all the fields below is listed in the spreadsheet -> Field: spreadsheet_name -> Field: sheet_name -> Field: success_return -> Field: productname -> Field: productqty -> Field: name -> Field: email -> Field: mobile -> Field: address If you are doing correctly, the system will push the screen to success_url which you have configure in the hidden field