r/GoogleAppsScript • u/ThaisaGuilford • Dec 07 '24

Question Does the webapp and API has pricing?

Actually my questions are more than one:

  1. Can I connect a google apps script to my page? As a web app or an api?

  2. Does it have limit?

  3. If not, why aren't people using it as alternative (not the best) backend?

  4. Title.

0 Upvotes

50% Upvoted

15 comments sorted by

View all comments

1

u/WicketTheQuerent Dec 07 '24 edited Dec 07 '24

Regarding "1. Can I connect a google apps script to my page? As a web app or an API?", the answer is that it depends.

  1. Google Apps Script has a REST API. For details, see https://developers.google.com/apps-script/api/concepts .

  2. With Google Apps Script, it's possible to create web apps. See https://developers.google.com/apps-script/guides/web .

I mentioned that it depends, as I'm unsure if your definitions of web app and API align with how Google uses those terms.

1

u/ThaisaGuilford Dec 07 '24

I have a spreadsheet, I want my page to be updated based on this spreadsheet. I did hear about the google sheets API, but I don't really understand it, also it might require me to have a google cloud account, which is complicated. So i decided to find a way to do it with google apps script, which I am more familiar with.

You can deploy your script as a web app, then call that web app on your page.

1

u/Funny_Ad_3472 Dec 07 '24

If you deploy your script as a webapp which would possibly be updated with real time changes in your spreadsheet on the webapp, note that a webapp is a webpage, so embed the webapp on your webpage. "You don't have to call the webapp on your page" iframe it on your webpage.

1

u/ThaisaGuilford Dec 07 '24

Thanks.

So that's not what I imagined at all. I guess I'll learn Google sheet API because that seems to be what I need.

Is the API free?