wordpress - How to create a web based interactive Spreadsheet (Dashboard) using Google Sheets and Google Web Apps -

wordpress - How to create a web based interactive Spreadsheet (Dashboard) using Google Sheets and Google Web Apps -

i looking solution on how build google web app using google sheet , publish in wordpress.

i have created google sheet based spreadsheet business logic (formulas) in it. create sheet available public users of wordpress website (the users should not required login google apps). should able alter values in sheet , watch interactively how charts associated sheet adjust.

my questions i have build google sheet did not find way on how utilize sheet web app. possible publish spreadsheet interactive web app? is possible run web app in wordpress? additional info

this link google sheet have built: google sheet.

i encounter next issues when publishing web:

the user asked google drive login, sheet cannot displayed non-logged in user. the sheet "static": user cannot alter values update chart. what do:

enable user work sheet "interactively" changing values, similar sample chart dashboard app provided google (tutorial , source code here) allows user filter info ranges.

i looking advice on build similar dashboard app based on google spreadsheet. dashboard app should accessible web users without need log in , embeddable in wordpress web site.

wordpress google-apps-script google-spreadsheet google-sites