All Questions
9 questions
2
votes
1
answer
373
views
Email Specified Range in Current Active Sheet as PDF
I want to email a specified range from the current active google sheet.There is an error with this code,it says TypeError: SpreadsheetApp.getActiveSpreadsheet(...).getRange(...).getAs is not a ...
0
votes
1
answer
1k
views
it gives me the error" can not read property from undefined"
I write a script for google apps script to read from a list of emailsf from a googlesheet and send email to each one of them. but when I run the script it gives me the error:
TypeError: Cannot read ...
- 95
0
votes
2
answers
1k
views
Google Apps Script: Send PDF instead of .zip file in email
I have this code that generates a PDF file from a Google Spreadsheet and sends it as an email attachment. The issue is that it zips the file with const zipBlob = Utilities.zip(blobs).setName('${ss....
- 680
0
votes
1
answer
49
views
I have an odd variable that is showing the entire columns contents
I have modified a public script to work with the expiration dates in a spread sheet. I wanted to add information from another column to help out with details. The other variables all do as I expect ...
0
votes
0
answers
88
views
Google Sheet sends email from list when cell condition met
I'm still very new to scripting and can't work out why the below script doesn't work
function sendReturnEmail(event) {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss....
- 63
0
votes
1
answer
94
views
Google Form not emailing when changing subject variable
I'm pretty new to Google scripting or scripting in general. I used the following to send the information input by the user into one email to a specific email address. what I wanted to do was to have ...
0
votes
2
answers
1k
views
Periodically send email from Google Spreadsheet
So I have a Google Spreadsheet with values pulled via ImportData.
I want the contents of this spreadsheet (or if it's simpler, a range of cells) to be emailed to me on the last day of each month, at ...
- 173
1
vote
0
answers
227
views
How do i set Google spreadsheets to email each row daily with a specific subject? (Automatically)
I would like to email the Google spreadsheet rows daily, with a
specific SUBJECT, without me having to anything.
I have 4500 rows, which I would like emailed daily.
I have 4500 tweets which i would ...
- 11
0
votes
1
answer
3k
views
Workflow for Google Apps script approving correct row via email
I am creating a workflow process with Google Apps script. I have looked at this video for most of the layout.
I built a form in Google Apps script that takes input data from a user. The data is then ...
