All Questions
12 questions
1
vote
1
answer
64
views
Unable to clear the contents in the sheet while using Sheets API in Google Appscript
I am using the following code to fetch table from Gmail to my sheet.
var labelName = "label"
function getEmailss_(labelName, sheetName) {
var label = GmailApp.getUserLabelByName(...
- 63
-1
votes
1
answer
49
views
Is it possible to customize the 'CC' info to fetch data from each corresponding row in Google Appscript?
I am currently using Google Appscript to send automatic mails. I have the option to include people in copy (CC), however, wanted to know if there's any way to fetch this data from each row ...
- 63
0
votes
1
answer
430
views
Gmail Signatures For Google Workspace Employees
I am developing an Google Sheets Add-on and at this point I need to be able to access all employees of the domain and change their Gmail signatures.
I have come across a solution but I find it hard to ...
- 158
0
votes
1
answer
672
views
Google Apps Script - Sheet - Menu Trigger not working
So I am building a mailmerge tool, and it works fine.
Testing the trigger with a hard coded input works fine:
function test(){
sendEmails("TEST MAILMERGE FROM DRAFT")
}
It also works fine ...
- 657
0
votes
2
answers
485
views
Save a excel file as gsheet
I want to automate a process and i have working with python, selenium and vba.
My process starts with a downloaded file from SQL server with python and selenium, later with vba, I transform the file ...
0
votes
2
answers
3k
views
How to run script if gmail subject contains " "
I have a script that imports CSV gmail attachments to google sheets, it runs every minute. I have another script that copies data to another sheet, I'd like to include the copy script to run after the ...
- 139
1
vote
3
answers
5k
views
Can I use script to send an email with HTML formatting?
I am creating an invoicing script add-on for Google Sheets. I want to be able to write in a value for a cell in the sheet that has an email message in it. I now understand how to send an email ...
- 1,187
0
votes
1
answer
273
views
Combining both a text message and an HTML table in one e-mail
I have the following code which sends out an email with the cases that exceeded the threshold (those cases are inserted as an HTML object into the e-mail). Right now the code works fine, but it doesn'...
- 63
1
vote
1
answer
375
views
Google APIs (gmail and spreadsheet): what more should I set up, or to know what setup I'm missing?
I'm creating a webapp, that includes some cron jobs, which would call the gmail API, and the google spreadsheet API.
I've created a project in my google developers deashboard, and credentials for it, ...
- 7,632
3
votes
3
answers
10k
views
GmailApp.sendEmail 'from' option stopped working
As of yesterday, Nov 10th 2016, my google script stopped working with the following error msg.:
Invalid argument: [email protected] (line 168, file "Code")
The line in question looks like this:
...
- 31
4
votes
2
answers
837
views
How to get all draft message with specific label attached to it
I have written a script, where I want to pull all draft message whose tag is shc.
Code:
function getDraftsWithLabel_shc() {
Logger.clear();
Logger.log("fn start..");
var drafts = GmailApp....
- 10.2k
0
votes
1
answer
807
views
Exporting XML from a google spreadsheet with apps-script, how do i get namespaces right?
I am trying to export a gmail filters compatible xml from a spreadsheet with some configs.
The XML should look like the sample below.
What I can't get right is the "apps:" namespace part of the "...
- 1,056