google-apps-script tag

111 questions


1 answers
50 views
0
Post-Data Import from CSV into Spreadsheet

After loading the local CSV file into the spreadsheet, I would like to put in a blank code.I've created a button on the spreadsheet from which I call function.I'd like to do everything in one click, b...

2 years ago

1 answers
53 views
0
I want to retrieve Dropbox files from Google Apps Script.

I would like to get a list of Dropbox files from Google Apps Script and insert them into Spreadsheet.I used the following HTTP request for Dropbox API:An error will be returned.It seems that the conte...


1 answers
50 views
0
I want to see the e-mail address of the respondents in the domain from the goolge script on Google form.

I am creating a survey within the domain using the Google form.Currently, the email address of the respondent is manually entered, but We have received a request to make this automatic.More specifical...

2 years ago

2 answers
47 views
0
The Google apps script trigger was previously started, but it no longer started.

I previously set the trigger to start every 15 minutes, but now it doesn't start.It can be started without any problems when you manually run it (press the arrow button), but it does not work at all o...

2 years ago

1 answers
136 views
0
Google Form Auto-Reply E-mails Are No Longer Sent Due to Errors

From the Google form spreadsheet, I set up the Tools > Script Editor edit to receive an automated reply email when I submit the form.(See script, trigger settings at the bottom) It worked fine for a w...


1 answers
115 views
0
Google Workspace Marketplace Does Not Review "Menu options not show after App is Installed"

Hello,I created an add-on to a Google spreadsheet and applied to Google Workspace Marketplace, but no matter how many times I communicate with them, the reviewer will reject me if I don't see the menu...


1 answers
42 views
0
I want to get an email address

I would like to obtain an email address using Google form.However, if Settings → General → Collect email addresses, I have to enter an address one by one, so I want to avoid it.Therefore, you must log...

2 years ago

2 answers
45 views
0
About Google Apps Script MailApp.sendEmail Errors

function attachmentsToCsvFile(){ varsheet=SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Sheet1'); // You could use now Date(); on its own but it will not look nice. vardate=Utilities.formatDat...

2 years ago

1 answers
49 views
0
Is it possible to read the contents of Google spreadsheet from external HTML?

I'm a beginnerIs it possible to read the contents of Google spreadsheet into external HTML?(Example: Place A1 in the spreadsheet in the HTML P tag) I was able to find the document that you said you wo...

2 years ago

1 answers
48 views
0
I want to change the format of the date in the script using the doGet function.

Nice to meet you.Using the following article as reference, I have written a script using the doGet function.[Workflow created with GAS] How to create a script that says approval by clicking the URLTo ...

2 years ago
« - 7 - »

© 2024 OneMinuteCode. All rights reserved.