881 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
-1
votes
1
answer
54
views
How to loop an Apps Script / Cheerio web scraper over multiple urls? [closed]
I have this Apps Script / Cheerio function that successfully scrapes the data I want from the url. The site only displays 25 entries at this url. I can find additional entries on subsequent pages (by ...
-1
votes
1
answer
65
views
Google Workspace Add-on rejected with generic 'Add-on error' when calling external API (UrlFetchApp) [closed]
I have developed a Google Workspace Add-on (published from a standalone Apps Script project) that relies on making an external API call for verification and event logging. The app works perfectly when ...
0
votes
1
answer
100
views
Valid Zoom API endpoint not recognized
I'm trying to write a Google Apps Script (using the Oauth2 library) to upload content to a Zoom Room display playlist. I have a Zoom app created with the proper scopes authorized, and content is ...
1
vote
1
answer
150
views
How do I get the HTTP status code from UrlFetchApp.fetch() when it throws an error?
I am using Google Apps Script to fetch data from an external URL. When the request is successful, I can get the HTTP status code with HTTPResponse.getResponseCode. However, if the request fails with a ...
0
votes
0
answers
93
views
Error getting data with fetch in web worker
I'm trying to get data in the order of bybit -> cloudflare worker -> google scripts. I got the value from bybit to the worker via API, but when I get the value from the worker via google scripts,...
1
vote
0
answers
144
views
DNS error when using URLfetchapp for a URL with "=" string / URL with potential Redirect issue
UPDATE
I discovered that the entire domain "https://www.mots.go.th" appears to give DNS error when using urlfetchapp, not just this specific page. Perhaps this is some sort of protection ...
0
votes
1
answer
122
views
Submit Google Form via Google Apps Script giving 401
I try to submit Google Form using Google Apps Script. I found this tutorial and follow the instructions properly. Below is the code with a sample of public link I've generated from the Google Form ...
0
votes
1
answer
208
views
cURL API call in Google App Script with Header & Body data
I'm a bit of a novice with Google App Script and looking for a bit of help making an API call. The data in my call is working fine when used in Postman.
Postman shows me the cURL call is as follows:
...
-1
votes
2
answers
127
views
Download file and paste col E3:F to sheet
I'm using this script to create new sheet every week
function getFile(fileURL) {
// see https://developers.google.com/apps-script/class_urlfetchapp
var response = UrlFetchApp.fetch("https://...
1
vote
1
answer
83
views
Copy certain cells over to another sheet when the script is running
I have the below script. It works perfectly.
This script runs a sales agreement for the sale of something.
When the sales advisor clicks the email icon and sends this to the customer. I would like ...
0
votes
1
answer
120
views
A CoinMarketCap App-Script modification to read multiple tickers in google sheets
So, I have this script from CoinMarketCap to lookup crypto prices. I want to modify this script where I can apply it to a cell and then drag and drop it down the column to read the ticker symbol in ...
0
votes
1
answer
283
views
How to fetch google form response with required email in Google App Script
As the title, I got some problem when trying to automate response google forms type collect submitter data but I am not the form's owner
Here is the form:
Sample Form
Below is my scratch code in GAS:
...
1
vote
0
answers
170
views
How to fetch JSON of files from OneDrive public folder using Google Apps Script
I have a public folder stored in my personal OneDrive account, which contains several files. The link to this folder is in the form: https://1drv.ms/f/c/{driveId}/{...
0
votes
0
answers
83
views
Google Apps Script unexpected error in UrlFetchApp.fetch method for HEIC image
I'm getting a strange error while trying to download an image from an URL through Google Apps Script.
The script is a simple GET of an image to download it. It works perfectly for .jpg and .png images,...
-1
votes
1
answer
158
views
How to make Google Apps Script SEND URL?
Using Google Apps Script, I created a system that creates a Google document and a PDF document from the data entered in a Google table. I need to make it so that after the PDF document is created, it ...