2,028
questions
-1
votes
0
answers
43
views
Issue with Contact Form Script [closed]
The script for my contact form works when in my Google Site https://sites.google.com/sgartwork.com/sgartwork/contact but when I changed my domain to a custom one it no longer works. https://www....
0
votes
0
answers
52
views
google sheets .ico, .png, .svg images all fail when copy/paste to google sheets
We have a simple table based grid on an html page that contains a few icons which are about 1KB in size.
Our end users have copied and pasted info out of this table into google sheets for about 10 ...
- 1,430
0
votes
1
answer
63
views
Facing Google Restrictions on Time Based Triggers every 5 minutes [closed]
Could you please confirm if real-time syncing, with Gmail activities and attachments updating every 5 minutes, is achievable using a 5-minute time-based trigger in Apps Script?
The primary goal was ...
0
votes
0
answers
23
views
Users unable to see google add-in installed by the admin
I have created an add-on for Google Drive using App Script. The add-on works as designed using the Test Deployment feature. Now I have listed the internal app with Marketplace SDK. It's configured as ...
- 133
0
votes
1
answer
50
views
Sorting A Huge Sheet
I have a sheet in the following format:
What I need to do is, sorting the skills by skill number, not alphabetically. I'm having trouble because the original sheet has thousands of names.
Here's what ...
- 3
0
votes
3
answers
82
views
Is there a way to get each value from a table then connect with it's title by row in a table
I have a table managed list of items (Green row), and its quantity by using a table (like a matrix). But in the end I want to combine it into one single string by each row, representing the quantity ...
0
votes
1
answer
56
views
Custom Formula for Google Sheet
I am trying to have my table auto assign members as either Alumni or Active based on the year of their graduation and the current date.
Example
Column A = Year of Graduation
Column B = Membership ...
-1
votes
0
answers
80
views
Add a Tab in Google Docs [closed]
Is there a workaround or an alternative way to create a new tab in Google Docs with Apps Script?
Has anyone else encountered this issue or found a creative way to manage separate daily logs within a ...
0
votes
0
answers
31
views
ETag missing in Google Sheets API GET request
When using the Google Sheets API - spreadsheets/get (docs) I don't see any ETag value, but it seems that it CAN be in the APIs:
var sheet = test.Spreadsheets.Get("1WC7CGN**************************...
2
votes
1
answer
68
views
AppScript throwing Exception error of Spreadsheets when trying to access Charts present in a Google Sheet
I am running the below code
var reportSheet = SpreadsheetApp.openByUrl("https://docs.google.com/spreadsheets/d/1HWg9ip6iC7wnw9e80IpM6ISKslMbtO591SLoKHTQGms/edit");
var reportStudentGraph = ...
0
votes
0
answers
24
views
Webhook error Google chat with Hubspot workflow integration
I just created a workflow from the HubSpot CRM using the webhook tool, entering the webhook url that provides me with a public space (chat) on Google Chat.
But this gives me the following error (image ...
0
votes
0
answers
38
views
How to deploy a private Chrome extension through Google Admin Console?
How to deploy a private Chrome extension through Google Admin Console?
I have developed a Chrome extension for internal use in my organization. I've successfully tested it using the "Load ...
0
votes
1
answer
106
views
400 error code on calling a Google Apps Script Web App
I created and exposed this very simple Google Apps Script:
function doPost(e) {
try {
Logger.log('Data received : ' + JSON.stringify(e));
return ContentService.createTextOutput(JSON....
- 13
1
vote
0
answers
46
views
Google Chat API: 404 Error When Using Existing Thread Key with Webhook
I’m currently working with the Google Chat API to send messages to specific spaces using webhooks. I have encountered a persistent 404 error (Requested entity was not found) when trying to send a ...
1
vote
1
answer
70
views
400 error on calling Google Apps Script from Wordpress
I created and exposed this very simple Google Apps Script:
function doPost(e) {
try {
Logger.log('Data received : ' + JSON.stringify(e));
return ContentService.createTextOutput(JSON....
- 13