Do you intend to add Web app functionality too via app script in this project? Thanks for this great project!

[enuchi]

Do you intend to add Web app functionality too via app script in this project? Thanks for this great project!

[tino-brst]

Just wanted to add another Thanks for this great project!, super useful resource! 🙌 💯

[enuchi]

Yes, this repo already should support web apps, with little change.

You need to add the doGet function and return the html file:

// src/server/ui.js
...
export const doGet = () => HtmlService.createHtmlOutputFromFile('dialog-demo-bootstrap');

Expose that function as a public function in the server entrypoint:

// src/server/index.js
...
global.doGet = publicUiFunctions.doGet;

Assuming you have everything else running properly, deploy the code (npm run deploy).

Publish the web app from the script editor (instructions here https://developers.google.com/apps-script/guides/web#deploying_a_script_as_a_web_app) and open the web app.

Local development with hot reloading works too.

[enuchi]

Hi @soql101 , have you tried updating here? Although not sure why you would need this.

React-Google-Apps-Script/src/server/sheets.js

Line 29 in e73e51e

SpreadsheetApp.getActive()

[enuchi]

@kk-ssc curious what you or others use web apps for.

[kk-ssc]

That helped. Thank you, I am planning on creating a personal to do list project :)

[soql101]

@enuchi Hi , I followed step as above but I am getting error 'ScriptError: Exception: Please select an active sheet first.' i am not able to set activate sheet for web app till now I come up with SpreadsheetApp.openById('1mDmI_iPp0RYXG5Os7F.......').setActiveSheet('Sheet1');
also wondering in which function I need to add this . Your help really appreciated

[soql101]

@enuchi thanks for your input.

If someone land on same question while working with Web App, here is fix

In sheets.js
Replace all SpreadsheetApp.getActive() with SpreadsheetApp.openById('<sheetId>')

Example
const getSheets = () => SpreadsheetApp.getActive().getSheets();
replace with

const getSheets = () =>SpreadsheetApp.openById('<sheetId>').getSheets();

Heads up : setActiveSheet arrow function will not work in web app
why ?

In order for something to be active, it must be open in the browser.
The code:
SpreadsheetApp.getActive().
Gets a Google Sheet that is already open in the browser.
But
SpreadsheetApp.openById(SHEET_ID)
Doesn't open up a Sheet in the browser.
You can't activate something that isn't open in the browser.
The activate() method will never work with SpreadsheetApp.openById(SHEET_ID)

React-Google-Apps-Script/src/server/sheets.js

Line 28 in e73e51e

export const setActiveSheet = sheetName => {