All Questions
9 questions
0
votes
1
answer
85
views
GAS: Send automatically emails from spreadsheet with date ant time info
I've the following columns in a spreadsheet
email
name
link
date
time
file
subject
title
[email protected]
Sam Z
abc
18.01.23
14:41:00
def
abc
Hello World
With following code deployed as add-on in google ...
-1
votes
1
answer
88
views
Filter message body by using Google App Scrip to put in spreadsheet table
I'm receiving emails from bank on every transaction based on transaction data in email body, see example below.
Now, I want to separate data to transfer in my spreadsheet like the value next to ...
- 105
0
votes
1
answer
447
views
Attach file from PC in Gmail Draft using Google App Script
Currently, I m using Google App script to create Gmail Draft from Spreadsheet, The last thing that is missing is I want to attach the file in "Gmail draft" directly from the computer instead ...
- 105
1
vote
1
answer
2k
views
Create HTML Draft from Google App script using GmailApp
I want to create a Google App Script to get Gmail Draft with a signature, by collecting data from a google spreadsheet. by default,
function Loop_Email_Drafts() {
var ss = SpreadsheetApp....
- 105
1
vote
1
answer
2k
views
Google Sheets - Send email based on cell matching True or False
I don't work with Google Sheets very often and mainly deal with Google Form's script editor. We have created a database from various forms that fill into one spreadsheet and I would like to send email ...
- 11
0
votes
2
answers
653
views
Google Apps Script - Trying to find a Google Sheet by name on Gmail
I'm trying to create a sheet that will work like a database for some data from Gmail (my sidebar works only on Gmail).
But, before I create a new google sheet for that, I have to look if the sheet ...
0
votes
0
answers
56
views
Google Script sometimes not reading full spreadsheet
I have a spreadsheet that is 862 lines long. However, for some reason the below code is only reading the first line of that spreadsheet and thinking that is all that is in there. This code has ...
- 1
0
votes
1
answer
413
views
Import data through Excel sheet in Google sheet with Google Script
I'm trying to get data from a csv file in attachment in my my Gmail, parse it and import it with Google Script in Google Sheets.
Problem is when I get content type of my attachment I have this ...
1
vote
2
answers
4k
views
How to get subject from gmail and put into a google doc or spreadsheet
I am trying to automatically extract subject lines to a Google doc or spreadsheet. I found a basic example but don't know how to make this work.
function processInbox() {
// get all threads in ...
- 11