All geek questions in one place

Performing Google Apps Script functions from a mobile application

I am developing a user interface that uses a Google spreadsheet as its database. He is currently using the Google Sheet mobile app (Android and IO) to update his spreadsheet, and I just can't find a way to create an interface or even call a function in the mobile app. Does anyone know how I can call a function from a script that I created in the Google Sheets Mobile app? Thanks!

+6
source share
2 answers

Custom functions and onEdit work well with mobile versions of Google Sheets.

+2
source

You cannot perform Google App Script functions (gas functions) through the Google Sheets mobile app.

Alternative # 1 :

Create Android Add-in

Source: https://developers.google.com/apps-script/add-ons/mobile/

Android Android applications can use the Script application APIs to directly call functions in Script applications. This allows Android add-ins to receive and process data from a Google Doc or worksheet using standard Script applications. Android add-ons, like desktop add-ins, allow you to create user interfaces - but with the full range of Android platform features at your disposal.

Alternative # 2

Build a web application and use the Google Runtime API

Source: https://developers.google.com/apps-script/guides/rest/api

The Script Execution API application consists of one script resource, which has one method, starts, which calls calls to specific applications Script functions

+1
source

Source: https://habr.com/ru/post/1234621/

More articles:


All Articles