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
0
votes
1 answer

404 requested entity was not found error in appscript deployment api

Hello i am trying to deploy an appscript project using the rest api for appscript, it gives me a 404 error in response, my code looks like this The google appscript api is enabled on my account and i am using a gcp standard project in my…
sudip-modi
  • 86
  • 1
  • 6
0
votes
1 answer

Copy Image Google Apps Script

I built a script that copies the contents of document A and pastes it into a new document, document X. Document B,C,D etc are also copied into document X. All the contents copy over great and everything works wonderfully. However, I recently added…
Wesleyb2013
  • 21
  • 3
0
votes
1 answer

how to get a row number in a column if a cell in another column has some data using google apps script?

i have a sheet that have 5 columns (date , id , name , number ,row number) and i want the fifth column(row number) to be auto filled with the row number when i insert any data in the second column(id) i tried the manual way from the sheet itself not…
Ahmed Zaqout
  • 91
  • 1
  • 11
0
votes
2 answers

How to schedule a BigQuery run through Apps Script

I have a connected sheet that has results of a bigquery query(extract sheet). I created a preview of the results sheet. How do i write an appscript fuction to refresh the results in the extract and preview sheets? Please help. I tried to use this…
user17243359
  • 55
  • 6
0
votes
1 answer

Dynamically changing URL's in an HTML File - Google Apps Scripts / Google Sheets

I have written a script that creates a new "Report" every time it is ran. This is done by generating a new Google Spreadsheet, which then displays a filtered set of values based off inputs in the original spreadsheet it is tied to. Below is the…
MonleyP
  • 3
  • 1
0
votes
1 answer

Querying from a combined bigQuery table in google sheets

On my Google Sheet I have a code that I use to: Pull an employees information from a BigQuery table Add it to a 'Notes' tab on the sheets file Then another part of the code adds an import range formula at the last row of the 'notes' tab to pull…
Danne Paredes
  • 1
0
votes
1 answer

How to call Google Apps Script API by a service account

I'd like to use a service account to access Google Spreadsheet via Google Apps Script API. But now the Apps Script API doesn't seem to work with service accounts according to the following…
Kono
  • 11
0
votes
1 answer

Add filter view hyperlinks and rearrange the column values

I have Sheet1 with existing filter view hyperlinks. I want to find any names that dont have filterviews, then create filterviews with hyperlinks to these names and add them in alphabetical order to the list that already has hyperlinks. Example: In…
user17243359
  • 55
  • 6
0
votes
1 answer

Google App Script pageToken to save attachments to Google Drive

basically what I'm trying to do is to get all the attachments within the received emails to a folder in google Drive (there are many, mostly .PDF). But it says I can't go beyond 500 attached files with search function and that I have to use…
Gabriel Belt
  • 1
0
votes
1 answer

How to Properly Configure GAS Web App (as another user) to Execute GAS API Executable (as me) using OAuth2?

Problem After days of reading and attempting trial-and-error, I am trying to make a call from a GAS Web App (executed as any Google User) to a GAS API Executable (executed as Me), but consistently receive an error message after Reviewing/Granting…
Brandon
  • 3,572
  • 2
  • 12
  • 27
0
votes
0 answers

Google Apps Script - Linear scale in google form

Dears I have a survey form with 13 questions, there is a condition which says: in case the user inserted all answers with the same value for examples all answers was 1 from 5 or all 5 from 5 don't submit the form and give the error to the user with…
mahnaz hussien
  • 1
0
votes
2 answers

Batch Update Bigquery results into google sheets(about 50k results)

I am trying to use Script editor(Apps script) to stream BigQuery results into google sheets. I'm following these [document][1] . The issue I have, the data doesn't load fully, it hangs. I have a large number of rows(more than 12 rows). I think I…
user17243359
  • 55
  • 6
0
votes
0 answers

unable to execute Apps Script API Executable from another Apps Script as another user

I created Apps script and deployed it as an API Executable with the follow settings: Web App Execute as: ME Who has Access: Anyone within the domain API Executable Who has Access: Anyone within the domain Once deployed, I get 2 URLs, one for the…
miturbe
  • 715
  • 4
  • 17
0
votes
1 answer

Creating Thumbnail of only the first Slide of a Google Presentation using Google Apps Script

I have been using a script so far to make png thumbnails of my Google Slides Presentations with Google Apps Script. However, I wonder how I can limit it to only be the first slide and not for each slide? I tried various ways but always failed …
Henry2004
  • 33
  • 4
0
votes
0 answers

Google app script timeout ~ 5 minutes - DocX to Docs

I want to run the script until I finish reading the files, there are 2000 files and it's only doing 100, what do I need to add to finish the script? enter code here var srcfolderId = "XXXXXXX" var dstfolderId = srcfolderId; var files =…
Web Conteúdo
  • 1
1 2 3
…
14 15