google-apps-script tag

111 questions

1 answers
50 views
0

I want to add the source settings to the Google form auto reply script.

I'm a complete script beginner.I successfully set up the following script by searching on the Internet.I'd like to add another source here.GmailApp.sendEmail(address, title, body, { from: 'email addre...

google-apps-script

2 years ago

1 answers
47 views
0

Retrieve the number of files in the folder and use them for new file names

▽ PurposeGAS has created a script to convert Excel files into spreadsheet files.In order to serialize the spreadsheet name, I tried to retrieve the number of files in the folder and use them as file n...

google-apps-script

2 years ago

1 answers
133 views
0

Google AppsScript Fails to Copy Large Files in GoogleDrive

If you try to use GoogleAppsScript below, you will fail in the copy section.This script copies all folder files with ID AAA to folder with ID BBB, and moves all folder files with ID AAA to the trash c...

google-apps-script google-drive-sdk

2 years ago

1 answers
126 views
0

How to Verify the Google Sheets API v3 to v4 Migration

GoogleSheetsAPIv3 is out of service on March 3, 2020, and a document on how to migrate to SheetsAPIv4 has been published. How can I confirm that v4 migration is supported so that v3 will continue to w...

google-apps-script google-app-engine google-api java8

2 years ago

1 answers
49 views
0

I'd like to get elements from multiple table tags that are not waved class,id by GAS (using jQuery).

I would like to obtain (scrap) the total number of people infected with corona in each city (Yokohama City, Yamakita Town, etc.) from this corona information.https://www.pref.kanagawa.jp/docs/ga4/covi...

javascript google-apps-script

2 years ago

1 answers
83 views
0

Authentication for "deployment as a web application" within an organization

[Prerequisite] We use G Suite Business.Deploy as a Web Application is configured below.·Run the application as the next user: 自分I·Users with access to applications: 組織All members of the organization[P...

google-apps-script oauth

2 years ago

1 answers
82 views
0

I want to save the base64 image in Google Apps Script.

I would like to decode the image encoded in base64 in gas and save it in blob.However, the seventh line of Utilities.base64Decode(data); displays the error Failed to decode the string.I tried other ba...

javascript google-apps-script base64

2 years ago

1 answers
137 views
0

How do I get the last row of multiple sheets and put them together into a new row in an Excel VBA or Google Apps Script?

Please check the sheet below first.https://docs.google.com/spreadsheets/d/1AlwgQLEZoZz_vWz0ZqKld528ViLAl8x2nR4SZz0VoHA/edit#gid=0There is an Excel file that records the monthly inventory of each produ...

google-apps-script vba excel google-spreadsheet

2 years ago

1 answers
130 views
0

Prohibit GAS Youtube Data Api Access

Hello I'd like to ask you about the error on YouTubeDataApi in GoogleAppsScript.I am writing a program on GAS that adds links to videos in spreadsheets to YouTube playlists.I got this error when I ran...

google-apps-script youtube-data-api youtube

2 years ago

1 answers
48 views
0

How do I check Google Apps Script calls and time limits?

You have started a spreadsheet script with a time-driven trigger.There were times when the code didn't work well even though there was no problem.Google Apps Script has a limited number of calls and t...

google-apps-script

2 years ago

- 6 -

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