All Questions
121 questions
-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
49
views
How to properly escape payloads sent with URLFetchApp when the payload contains double quotes
I am trying to POST a payload to a CMS using URLFetchApp. The payload has quotes in the text. I am using URLFetchApp because the code is executing inside a Google Apps Script, which from what I ...
- 1,319
0
votes
0
answers
188
views
Can't get ElevenLabs API in Google AppScript To Return Valid Response
I'm using a Google AppScript to integrate Eleven Labs' API into a Sheet.
Trying to get past this step so that I can do something with a returned file but I can't get past this response code 422. I'm ...
- 1,163
0
votes
1
answer
156
views
Returning value from apps script (doPost) to client, after calling an external API
I am trying to invoke an apps script deployed web app (doPost method) and get a response back to the client app (this could be HTTP client like Postman/Bruno or simple javascript app).
The deployed ...
- 13
0
votes
1
answer
47
views
GAS Errror :"Script function not found: doPost" [duplicate]
I have two GAS scripts, send.gs and respond.gs.
send.gs: Just sends POST request to respond.gs
respond.gs: Deployed and published as WebApp and just responds hello,world
When send.gs sends POST ...
- 817
0
votes
1
answer
164
views
Google App Script : 403 when running UrlFetchApp in GAS
I am creating an API to record Google Form responses.
I have implemented the following code in GAS and am using UrlFetchApp in GAS to run Endpoint when submitting Google Forms.
When executing ...
- 17
1
vote
1
answer
2k
views
How to use Google App Script to send a file using POST request
I want to use Google Apps Script to integrate a Google Sheets with an API
This is the documentation from the API service:
curl --location --request POST 'https://apinew.socialhub.pro/api/sendMessage' \...
- 1,143
2
votes
1
answer
203
views
UrlFetchApp Method does not work and gives 405 error in retrieving data from an API?
I am trying to get the Clockify detailed time report into Google Sheets. When I try to use the URL fetch method, it gives me an error:
Exception: Request failed for https://reports.api.clockify.me ...
- 405
0
votes
1
answer
49
views
Error when trying to post data to rest API using an appscript
I am struggling to write an appscript to post data to sage accounting API
I am trying to save a new customer to sage accounting software through the API. When I use postman it works. I cant get the ...
1
vote
1
answer
434
views
Accessing Googles Palm api from Apps Script
There are currently a few QuickStart's for Palm API text.
PaLM API: Text Quickstart
The examples show how to do this in Python, but I have not found any way of getting it to work with Google Apps ...
0
votes
1
answer
159
views
POST JSON file for UrlFetch payload
I'm trying to POST JSON data from my Google Drive JSON file using Google Apps Script and UrlFetchApp.
When I pass in the file's JSON string directly as a variable in the script, it works. I am ...
2
votes
1
answer
182
views
Permission problems with Google Sheet Script for ai SEO website audit
I am trying to implement a code snippet from an article to help with some home / hobby SEO projects. The script should pull a website, run an audit, and make suggestions.
I run into a permission issue ...
- 47
0
votes
1
answer
436
views
How to loop through multiple API calls in Google Apps Script?
I'm putting together a spreadsheet that pulls in all the comments from a handful of different documents (called "Cards"). Unfortunately, the API I'm using only lets you call one card at a ...
- 55
0
votes
1
answer
176
views
How to filter/sum array data by year/quarter?
Trying to consolidate dividend data by year and quarter from an object from this URL.
I was able to retrieve dividend date and dividend amount from the object and convert the dividend date to YYYY Q ...
- 281
-1
votes
2
answers
51
views
A function in Apps Script that get data from post API
I want to write a function to get a response from an API
Like myfunction( url , body)
Then give data as a return
Data response
Like otp( url, body)
Response data ( for example '1234')
