google-apps-script tag

111 questions

1 answers
421 views
0

I want to get the email address of the person who accessed it in GAS, get the matching cell from Spreadsheet, replace the email address with a name, and send it to chat.

I would like to obtain the data of the cell to the right of the cell matching the email address in the program shown below and substitute the text below.var payload={ text—text }What I've tried so far...

google-apps-script google-spreadsheet

1 years ago

1 answers
393 views
0

I want to automatically replace my username with GAS.

I'd like you to automatically enter the person who executed this script in this part of vartxt=';, what should I do from here?function onOpen2(){ varurl='https://chat.googleapis.com'; var text = 'Auto...

google-apps-script

1 years ago

1 answers
439 views
0

I want to extract xml designated elements in GAS

I'm going to use GAS to create a program that will keep an eye on blog updates and notify you.https://web.plus-idea.net/2018/04/google-apps-script-xmlservice-parse/I was able to retrieve the contents ...

javascript google-apps-script xml

1 years ago

1 answers
363 views
0

I would like to obtain and set the work place of the calendar in Google apps script.

Is it possible to obtain and set the workplace on Google Calendar?

google-apps-script

1 years ago

1 answers
298 views
0

I want to parrot back on Line, but it doesn't come back.

Reference Sitehttps://gurishunin.com/line_gas_beginner/I'm a beginner.I copied the above site's code and put a channel access token (long term) in the access token.There is also a webnock setting and ...

google-apps-script line bot

1 years ago

1 answers
344 views
0

I don't know how to measure GA for html generated by Google Apps Script

We generate html, CSS, and JavaScript in Google Apps Script, and create and operate the original inquiry form.The inquiry form works well and there is no problem, but I don't know how to measure GA.ht...

google-apps-script google-analytics

1 years ago

1 answers
59 views
0

GAS "The item with the specified ID could not be found or you do not have permission to access" error.

I want to use GAS to retrieve the specified folder in my google drive, but every time I run a script, I get an error message saying, I couldn't find an item with the specified ID or I don't have permi...

google-apps-script

1 years ago

1 answers
74 views
0

Error writing to spsi by gspread

While writing to a spreadsheet using the gspread library, the following error occurred:gspread.exception.APIerror: { error: { code: 401, message: Request had invalid authentication credentials.Expecte...

google-apps-script

1 years ago

1 answers
63 views
0

I want the time to be displayed correctly.

The description of the time is obviously strange, but I don't know how to cure it.function myFunction(){ let year = new Date().getFullYear(); const startDate = new Date(2020/4/1 12:00); console.log(st...

javascript google-apps-script

1 years ago

1 answers
73 views
0

Google Apps Script taken over from predecessor does not work with permission error?

Thank you for your help.The script I took over from my predecessor didn't work, and I didn't know, but I debugged the execution.Authorization required Untitled project needs your permission to access ...

google-apps-script

1 years ago

- 2 -

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656