Apps Script Coding Examples
Bullet code copy 1
Sending an email 4
Reading data from a Google Sheet 5
Writing data to a Google Sheet 7
Generating a PDF from a Google Document 9
Get a web PDF and save it to your gDrive 10
Converting a Google Document to plain text 11
Bullet code copy
https://youtu.be/o3WWmNB2qis
Laurence Svekis https://basescripts.com/
example of how you can copy a bulleted list from one Google
Document to another using Google Apps Script:
// Function to copy the bulleted list from one document
to another
function copyBulletedList() {
// Get the source document
const sourceDoc = DocumentApp.getActiveDocument();
// Get the list items from the source document
const sourceListItems =
sourceDoc.getBody().getListItems();
// Create a new Google Document
const targetDoc = DocumentApp.create("Target
Document");
// Get the body of the target document
const targetBody = targetDoc.getBody();
// Loop through each source list item
for (const i = 0; i < sourceListItems.length; i++) {
// Get the text of the current list item
const listItemText = sourceListItems[i].getText();
// Add the text as a bulleted list item in the
target document
targetBody.appendListItem(listItemText).setGlyphType(Do
cumentApp.GlyphType.BULLET);
}
}
Laurence Svekis https://basescripts.com/
Note: This script assumes that the source document has at least
one bulleted list item. If the source document doesn't have any
bulleted list items, the script will throw an error.
function copyBullets() {
//const sourceDoc = DocumentApp.getActiveDocument();
const sourceDoc =
DocumentApp.openById('1SCE46vJBBIYWKFjiwZCXXVY');
const listItems = sourceDoc.getBody().getListItems();
Logger.log(listItems);
//const targetDoc = DocumentApp.create('New Doc
Bullets');
const targetDoc =
DocumentApp.openById('1KCwguT8iHINHXlH-I4');
const targetBody = targetDoc.getBody();
for(let i=0;i<listItems.length;i++){
const listItemText = listItems[i].getText();
targetBody.appendListItem(listItemText).setGlyphType(Do
cumentApp.GlyphType.BULLET);
Laurence Svekis https://basescripts.com/
}
}
Sending an email
https://youtu.be/x3_y-HWvr0U
Sending an email using Google Apps Script:
function sendEmails() {
// Get the active Gmail account
const email = Session.getActiveUser().getEmail();
// Define the recipient and subject of the email
const recipient = "
[email protected]";
const subject = "Test Email";
// Define the body of the email
const body = "This is a test email sent from Google
Apps Script";
// Send the email
GmailApp.sendEmail(recipient, subject, body, {from:
email});
}
In this example, the script uses the GmailApp class to send an
email. The sendEmails() function first retrieves the email address
of the active Gmail account using the
Session.getActiveUser().getEmail() method. The recipient,
subject, and body of the email are then defined as variables.
Finally, the GmailApp.sendEmail() method is used to send the
Laurence Svekis https://basescripts.com/
email, passing in the recipient, subject, body, and sender email
address as arguments.
function sendMyEmail() {
const email = Session.getActiveUser().getEmail();
const recEmail = email;
const subject = 'Test Emailing';
const body = '<h1>Laurence Svekis</h1><p>This is an
email sent by script</p>';
const id = '1SCE46vJiwZCXXVY';
const file = DriveApp.getFileById(id);
const blob = Utilities.newBlob('My
Content','text/html','myHTML.html');
/*
GmailApp.sendEmail(recEmail,subject,body,{
from:email
});
*/
MailApp.sendEmail({
to:recEmail,
subject:subject,
name:'My Docs',
htmlBody:body,
attachments:[file.getAs(MimeType.PDF)]
});
}
Reading data from a Google Sheet
https://youtu.be/MR2dUNd5g1A
Laurence Svekis https://basescripts.com/
Reading data from a Google Sheet:
function readData() {
// Get the active sheet
const sheet = SpreadsheetApp.getActiveSheet();
// Get the data range from the sheet
const dataRange = sheet.getDataRange();
// Get the values from the data range
const data = dataRange.getValues();
// Log the data to the console
Logger.log(data);
}
In this example, the readData() function uses the
SpreadsheetApp class to read data from a Google Sheet. The
SpreadsheetApp.getActiveSheet() method is used to get the
active sheet, and the sheet.getDataRange() method is used to get
the data range from the sheet. The dataRange.getValues()
method is then used to get the values from the data range.
Finally, the values are logged to the console using the
Logger.log() method.
function readData(){
const sheet = SpreadsheetApp.getActiveSheet();
const dataRange = sheet.getDataRange();
const data = dataRange.getValues();
data.forEach(row=>{
Logger.log(row.length);
Laurence Svekis https://basescripts.com/
})
Logger.log(data);
}
Writing data to a Google Sheet
https://youtu.be/Dy_A2IlerJc
Writing data to a Google Sheet:
function writeData() {
// Get the active sheet
const sheet = SpreadsheetApp.getActiveSheet();
// Define the data to be written to the sheet
const data = [["Name", "Age"], ["John", 30], ["Jane",
28]];
// Get the last row in the sheet
const lastRow = sheet.getLastRow();
// Write the data to the sheet starting from the next
row after the last row
sheet.getRange(lastRow + 1, 1, data.length,
data[0].length).setValues(data);
}
In this example, the writeData() function uses the
SpreadsheetApp class to write data to a Google Sheet. The
SpreadsheetApp.getActiveSheet() method is used to get the
Laurence Svekis https://basescripts.com/
active sheet, and the data to be written to the sheet is defined as
a two-dimensional array. The sheet.getLastRow() method is used
to get the last row in the sheet, and the sheet.getRange() method
is used to get a range starting from the next row after the last
row. The setValues() method is then Writing data to a Google
Sheet:
// Write the data to the sheet starting from the next
row after the last row
sheet.getRange(lastRow + 1, 1, data.length,
data[0].length).setValues(data);
}
The setValues() method is then used to write the data to the
sheet, passing in the data as an argument. The first argument to
getRange() specifies the starting row (lastRow + 1), the second
argument specifies the starting column (1), the third argument
specifies the number of rows (data.length), and the fourth
argument specifies the number of columns (data[0].length).
function writeData(){
const ss = SpreadsheetApp.getActiveSpreadsheet();
const sheets = ss.getSheets();
Logger.log(sheets);
const sheet = sheets[2];
//const sheet = ss.getSheetByName('Sheet2');
//const sheet = SpreadsheetApp.getActiveSheet();
const data =
[['Name','ID'],['Laurence','100'],['Laura','50'],['John
','1140']];
const lastRow = sheet.getLastRow();
Logger.log(lastRow);
Laurence Svekis https://basescripts.com/
const range =
sheet.getRange(lastRow+1,1,data.length,data[0].length);
range.setValues(data);
}
Generating a PDF from a Google Document
https://youtu.be/kBNfHBxYU_I
Generating a PDF from a Google Document:
function generatePdf() {
// Get the active document
const document = DocumentApp.getActiveDocument();
// Get the URL of the active document
const url = document.getUrl();
// Define the file name for the PDF
const fileName = "Test PDF";
// Generate the PDF
const pdf = UrlFetchApp.fetch(url +
"&exportFormat=pdf").getBlob();
// Save the PDF to Drive
DriveApp.createFile(pdf).setName(fileName);
}
Laurence Svekis https://basescripts.com/
In this example, the generatePdf() function uses the
DocumentApp and UrlFetchApp classes to generate a PDF from a
Google Document. The DocumentApp.getActiveDocument()
method is used to get the active document, and the
document.getUrl() method is used to get the URL of the
document. The file name for the PDF is defined as a variable, and
the UrlFetchApp.fetch() method is used to fetch the URL of the
document with the &exportFormat=pdf parameter appended to it,
which causes the document to be exported as a PDF. The
getBlob() method is used to get the binary data of the PDF, and
the DriveApp.createFile() method is used to save the PDF to
Google Drive.
function generatePdf() {
const url =
'https://basescripts.com/wp-content/uploads/2023/02/Jav
aScript-interview-questions-with-code-examples.pdf';
const fileName = "Test PDF";
const pdf = UrlFetchApp.fetch(url).getBlob();
DriveApp.createFile(pdf).setName(fileName);
}
Get a web PDF and save it to your gDrive
https://youtu.be/u_Y9sRiMqVQ
const ID = '1SCE46vJBcW0LBIYWKFjiwZCXXVY';
const FOLDERID = '1sFNkLwdPK6ggAUlWfunctiowZ';
function genPDF(){
const doc = DriveApp.getFileById(ID);
const pdf = doc.getAs('application/pdf');
Laurence Svekis https://basescripts.com/
pdf.setName('test1');
const folder = DriveApp.getFolderById(FOLDERID);
folder.createFile(pdf);
}
Converting a Google Document to plain text
Converting a Google Document to plain text:
function convertToPlainText() {
// Get the active document
const document = DocumentApp.getActiveDocument();
// Get the body of the document
const body = document.getBody();
// Get the plain text representation of the document
const plainText = body.getText();
// Log the plain text to the console
Logger.log(plainText);
}
In this example, the convertToPlainText() function uses the
DocumentApp class to convert a Google Document to plain text.
The DocumentApp.getActiveDocument() method is used to get
the active document, and the document.getBody() method is
used to get the body of the document. The body.getText()
method is then used to get the plain text representation of the
Laurence Svekis https://basescripts.com/
document, which is logged to the console using the Logger.log()
method.
Laurence Svekis https://basescripts.com/
