Stack Overflow
Stack Overflow

Questions tagged [google-apps-script-api]

DO NOT USE THIS TAG ALONE. Use for questions regarding programmatic manipulation of Google Apps Scripts through the REST-Google Apps Script API. Use in addition to the language tag (like [python], [java], [c#]) and the google-api library tag(like [google-api-java-client]) that is used to do the said manipulation.

The Apps Script API offers programmatic control of Google Apps Script projects to 3rd party applications via a REST API. It is an extension of the previous "Execution API," now enabling client applications to perform actions that were previously only available inside the Apps Script editor, such as create projects or manage deployments.

221 questions
1
vote
1 answer

Use Google Apps Script Execution API with API keys and Javascript

I want to create a web application for my client and use Google drive to store information. Since it's impossibe to integrate a web application from google apps script in my own website I try to use Google Apps Script Execution API and Javascript to…
Edouard Delga
  • 95
  • 7
1
vote
2 answers

Google Apps Script Error while creating document using execution API PHP Client

I tried fetching the list of folder and it got successfully fetched by php client. But when i tried creating a document using app script, the document gets created if i run app script code using Run icon in app script editor. But when I am using…
James Nicholas
  • 21
  • 3
1
vote
2 answers

Programmatic access to restricted Google app script web app

I need to access to my Web App using HTTP GET and POST requests in my console application, but unfortunately I can't use anonymous access option in "Who has access to the web app". Is there any chance to do it using any approaches (OAuth2 client Id,…
no_
  • 11
  • 1
1
vote
1 answer

How to programmatically create a list of Google Apps Script projects owned by me?

Google Apps Scripts projects could be standalone, bounded to Google apps (Docs, Sheets), Web Apps or Google Sites gadgets. How could I find all the projects owned by me from a single point? The Class File, Class Document, Class Spreadsheet, Class…
Rubén
  • 34,714
  • 9
  • 70
  • 166
0
votes
0 answers

Getting 401 response when trying to access apps script from flutter application

I am building an organisation level flutter application in which user can enroll for the particular google calendar event. This calendar events are created by admin account of organisation. So, to access/modify events I have created an AppsScript on…
Suyash Sawant
  • 1
0
votes
0 answers

Google Selector API Fails When Logged in with More Than 1 Google Accounts in Apps Script

I am using the The Google Picker API in an Apps Script project and it works well. However, when I am logged in with more than 2 Google accounts, the The Google Picker API fails. I think this is because it confuses the sessions of one account with…
MAKE OUT HILL 666
  • 1
0
votes
1 answer

Personal Gmail Google Doc Apps Script Will Not Allow Authorizing - This app is blocked

I can't seem to authorize a Google Doc Apps Script to run. When adding permissions Google keeps returning: "This app is blocked This app tried to access sensitive info in your Google Account. To keep your account safe, Google blocked this…
user10583271
  • 3
  • 1
0
votes
2 answers

onEditHandler works but onSelectionChange fails with Exception: You do not have permission to call UrlFetchApp.fetch. Required permissions:

I want that when the button is clicked (which is just an image within the cell), the function to translate the text is fired: When using onSelectionChange, the following error is output: Exception: You do not have permission to call…
chelder
  • 3,819
  • 6
  • 56
  • 90
0
votes
0 answers

How to work around with App Script API with Service account

I want to call Apps Script API in my app, it works fine with web user authentication but has a 403 error when I change to using a service account. I discovered that the reason is that the Apps Script API does not work with service accounts according…
Khuyen Ho
  • 1
  • 2
0
votes
0 answers

Where can I find a list of Google print parameters

I am trying to write scripts to automate creating a PDF from a range of cells in Google Sheets. I can't find a list of the print parameters for Google Print. Where can I find these? I've found the following parameters: 'size': // paper size.…
Elder Moore
  • 1
  • 1
0
votes
1 answer

Google App Script - Set trigger when data is added to a specific column via a function

I have a table in which column I gets updated programmatically via an Array Formula. And when that happens, i.e a new row of data is added in column I, I want to run the fillTemplateAndDuplicate function. I've tried many times but even if…
offdutyventures
  • 1
0
votes
1 answer

TypeError: Cannot read properties of null (reading 'setTabColor')

I have minimal knowledge about coding or javascript but I tried to generate a code with ChatGPT but when I try to run it in google apps script it gives me an error saying: TypeError: Cannot read properties of null (reading 'setTabColor') The script…
Eppu Niemi
  • 1
0
votes
0 answers

How to make Google oauth work in Python Quickstart

I am trying to run a Python script that accesses Google apps using Google's Python Quickstart on Python 3.10 on Windows 11 (originally installed as W10). The early steps are: enable the API, Create OAuth client ID, install the Google Client Library…
WesR
  • 1,292
  • 1
  • 18
  • 30
0
votes
1 answer

Google Apps Script: appendRow() getting values like [Ljava.lang.Object;@66e6c522

function doGet(e){ var p = e.parameters; try { if ("username" in p) { // user info get let id = p.ID; let username = p.username; let time = p.time; let email = p.email; let roles = p.roles; let value =…
shenkwen
  • 3,536
  • 5
  • 45
  • 85
0
votes
1 answer

Unable to call DocumentApp.openById. with onEdit() in GooglApps Script and Sheets

I'm still very new to Javascript and Apps script in particular so sorry if this is dumb. I'm currently trying to create a mail merge tool. The Idea is that each field in a spreadsheet is manually filled with data, and once complete, the user ticks a…
Phil Tomlinson
  • 3
  • 1
1 2 3
…
14 15