0

I have created a Google Sheet to process a Sales and send mail from it. But I have found a limitation, it works only on PC and cannot be used on an android phone using the Sheets app. Is there a way to convert my code to a web app, use Sheets as my database and use the interface from my phone?

Improve this question
1
  • 1
    If you are only looking for a way to run your emailer code in the mobile app, use Insert > Checkbox and an installable "on edit" trigger that detects that the checkbox has been clicked. See the checkboxButtons_ script for sample code. Commented Jun 17, 2022 at 14:06

2 Answers 2

Reset to default
2

Create a deployment of the project as a web-app. you'll probably want to use the Test Deployment for developing and you will need the doGet(e) function to get the page up and running.

function doGet(e) { var html = HtmlService.createHtmlOutputFromFile("your_HTML_file_here"); return html; }

The function above creates the webpage but the rest of the code will end up in the html file that contains the web page.

To interact with google and its services you can use

google.script.run

This allows the user to run google script code from an html page.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

1

Not sure what you mean by "convert". You can publish your project as web app (for that you need doGet() function and some kind of UI) and then access it on mobile via URL.

Improve this answer

2 Comments

"for that you need doGet() function and some kind of UI)" is there someplace where I can learn this ?
sure check out Google documentation on that

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.