All Questions
Tagged with google-apps-script urlfetch
597 questions
-1
votes
2
answers
95
views
Loop through each line [closed]
I have a table, it can have any number of rows.
Example table
I need to pass the value of each row to the server.
In Apps Script, I write code
function importObn() {
var list = SpreadsheetApp....
- 1
0
votes
0
answers
78
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,...
- 21
1
vote
0
answers
88
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 ...
- 21
0
votes
1
answer
76
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 ...
- 1,816
0
votes
1
answer
101
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
-1
votes
2
answers
110
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://...
- 11
1
vote
1
answer
65
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 ...
- 13
0
votes
1
answer
103
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 ...
- 3
0
votes
1
answer
180
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
123
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}/{...
- 211
0
votes
0
answers
61
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
137
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 ...
- 39
0
votes
0
answers
62
views
How do i resolve an error in Google App Script?
I am working on a simple Google AppScript, where the public API works on postman, however it gives an error Unauthorized when I call it from Script. Can someone please help. Below is the code
I tried ...
- 406
1
vote
0
answers
529
views
Error 403 while fetching data using Google Apps Script
I am trying to make a request using Urlfetchapp, this has been working fine for a month but now it starts giving an Error 403 message. The sample code is:
function fetchWithRetry() {
var url = '...
- 520
0
votes
1
answer
56
views
Why do I receive an Error code for my custom function?
I can't use add-ons, so I tried to write my own code to to use GPT with Google Sheets.
The error code that comes out is:
TypeError: Cannot read properties of undefined (reading '0') (line 30).
Line 30 ...
