Which of these are possible with Google Apps Script?

[Levan Khomeriki]

Hey,

I've been working on my habit building app for some time now and I got a sudden opportunity, to have it tested by several hundred people and since I don't have an app ready yet, I decided to build a rudimentary prototype with Google Sheets.

At it's core, this app is supposed to pair two people with the similar goal and for the next 21 days they'll become each-others accountability partners - starting the day by writing their goal, ticking off the check-box, once they've completed their goal and encouraging the other party to complete theirs.

So, basically, a two-player to-do list.

I've built a simple Google Spreadsheet for that and now I need to ship it to 400 users (so, 200 individual instances of this doc, with 2 unique users per instance) and come up with the way for them to be able to 'nudge' their partner and ideally, to be able to have a chat.

What I've managed to discover so far, is that AppSheet can do all of these stuff, but with it's pricing model, it's not an option for me.. 

But I'm pretty confident, that all those functions are achievable with Apps Script:

- Automatically sending email, or even SMS once the specific box is ticked off

- Using Google Chat interface to communicate

So, my question is - is it possible, to build a simple web app, which will have these functionalities and which will not require users to install any third-party extensions, apps, etc?

And maybe you could point me to the right direction?

Thanks in advance.

[Nerio Villalobos]

Yes, it is definitely possible to build a simple web app with the functionalities you mentioned using Google Apps Script.

Here are the steps you can follow to create a web app:

Create a new Google Spreadsheet and set up the layout to match your prototype. You can add the necessary columns for goals, checkboxes, and user information.

In the same Google Spreadsheet, go to the "Tools" menu and select "Script editor" to open a new script project in Google Apps Script.

Write the necessary functions to send emails or SMS messages and communicate through Google Chat. You can use the GmailApp or MailApp service in Google Apps Script to send emails, and Twilio or another SMS gateway service to send SMS messages.

Create a new HTML file in the Google Apps Script project, which will contain the UI for your web app. You can use HTML and CSS to create the layout and style of the web app.

In the HTML file, create forms for users to enter their information and for them to update their progress. You can use Javascript to make the forms interactive and update the spreadsheet.

Publish your web app by going to the "Publish" menu and selecting "Deploy as web app". Choose to deploy the latest code and select "Anyone, even anonymous" for the "Who has access to the app" option.

Once you've published your web app, share the link with your users, and they will be able to access the app without needing to install any third-party extensions or apps.

It's important to note that you will need to write code to ensure the privacy and security of the user's information, and it's recommended to thoroughly test the app before sharing it with your users.

Overall, Google Apps Script is a powerful tool that can help you build simple web apps with minimal coding, and the best part is that it's completely free to use.

Regards,

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/a128ea39-ba3d-439e-ab8c-cb1b1c12e85cn%40googlegroups.com.

--

__________________________

Nerio Enrique Villalobos Morillo

+54 9 11 68851063 

Buenos Aires, Argentina

[Levan Khomeriki]

Nerio,
thank you so much for such an extensive response!

It was the inspiration I needed to start tinkering with Apps Script and all the functions you've mentioned before.

The only thing I'm concerned from this perspective, is whether it can be built in a way, that each clone would be shared only among specific two (or several) users and no-one else?..  

And as a side note, would you consider a short-term role of advisor for this project?

Thank you once again,

Levan

On Monday, April 17, 2023 at 8:07:10 AM UTC+4 Nerio Villalobos wrote:

Yes, it is definitely possible to build a simple web app with the functionalities you mentioned using Google Apps Script.

Here are the steps you can follow to create a web app...

El dom, 16 abr 2023 a la(s) 09:23, escribió:

Hey,

I've been working on my habit building app...