Google AppsScript

In the same vein as codepen, iCodeThis, scrimba editor, stackblitz, etc https://script.google.com/home has been really helpful for when you need a quick pseudo-server, quick webhook, esp if you need to connect to any Google Workspace products. Also can create a frontend interface. Im finding it like a Google Cloud Projects Lite (GCP is too complex for my experience level with backend; but can also be connected Apps Script x GCP if desired). Ive used it for quick webhooks (although i did spend 2 days learning that my POST request redirected and was converted to a GET request, the platform is was using couldnt follow redirects. So "quick" is relative 😆). Can connect to Cloud SQL, Firebase, or if you dont need a proper db , you can connect it to a Google Sheet to act as your table. I just used it to add a menu item to the sheet that runs my function to sync data or in another sheet, launches a form to add a new row to the sheet and validation for some columns. Ive also used an AppsScript web app webhook to store all my form submissions from my website in one sheet (tab for each form).
Just wanted to share this versatile tool that can be used for demos that need a pseudo server or developing a midrange web app or for extending your use for Google Sheet. Im surprised ive nevrr heard about it in demoland.
Google for Developers
Apps Script  |  Google for Developers
Develop high-quality, cloud-based solutions with ease.
0 Replies
No replies yetBe the first to reply to this messageJoin

Did you find this page helpful?