google-apps-script tag

111 questions


1 answers
41 views
0
How to Upload Local Files to Google Apps Script

Is there a way to upload a locally placed text file instead of updating a file called xxxx.gs in Google Apps Script that you can edit on Google SpreadSheet etc.?Please let me know if you know.

2 years ago

1 answers
43 views
0
I want to get or set restrictions value in Drive.Drives.list

Drive.Drives.list({pageToken:pageToken, maxResults:100, useDomainAdminAccess:true});I was able to get the id and name values from the return values that get, but I cannot get the restrictions and I ca...

2 years ago

1 answers
42 views
0
Invalid OAuth ID for this script now appears

The Google Apps Script program, which had been running smoothly in the Google Apps for Works environment for months, stopped working with an Invalid OAuth ID for this script error when started.Manual ...

2 years ago

1 answers
44 views
0
Error in variables starting with numbers

I'd like to get a value from https://coinmarketcap.com/ja/api/, but I can't.There is a problem with 24h_volume_usd starting with a number in the source below. Where should I fix it?function getCoin24h...


1 answers
64 views
0
Authentication goes through on twitter API, but when you hit a tweet endpoint, you get 403 forbidden.

https://moripro.net/gas-twitter-bot/In the middle of writing the code to tweet from GAS using this as a reference, The success screen came out after the authentication, but when you run the tweet test...


1 answers
90 views
0
If you use GAS to send mail, it will be blocked.A free GMAIL account can be sent without any problems.

I'm a beginner.Thank you for your cooperation.I'd like to send an email via GoogleAppScript, but I can't because the following message came back to my contracted account's Gmail.Block MailYour email t...


1 answers
45 views
0
This is a question about the trigger when inserted from CF7 into Google spreadsheet.

when inserting data from CF7 Google Sheet Connector into Google spreadsheetIt will be added to the bottom of sheet 1, but I would like to put it in reverse order to sheet 3.I wrote the following JavaS...

2 years ago

1 answers
42 views
0
How to Stop Google Apps Script

I just started Google Apps JavaScript.It seems that Doc/Gmail sent Hello World! to the person by mistake, and the method of sending the message cannot be reproduced, so I cannot stop it, so please let...

2 years ago

1 answers
68 views
0
Manage passwords, id, and security issues within the GAS

I want to call an API periodically, but the execution uses a trigger.Hard coding of passwords, IDs, and tokens is a problem.I think it should be stored separately from the source code.Previously proje...

2 years ago

1 answers
142 views
0
About sheet coordination in spreadsheets

About managing spreadsheetsThere is sheet 1 of the basic product management calendar.Release date (column A), product name (column B), and basic information (column C-G)I would like to create and mana...

« - 11 - »

© 2024 OneMinuteCode. All rights reserved.