Appscript Archive -

November 19, 2024 | Ashish Dwivedi

Send Bulk whatsapp

AppSScript Code Copy Code function onOpen() { var ui = SpreadsheetApp.getUi(); // Add a custom menu to the spreadsheet ui.createMenu('Bulk…

October 18, 2024 | Ashish Dwivedi

Auto Backup Google Sheets

AppSScript Code Copy Code function createBackup() { // Get the active spreadsheet var spreadsheet = SpreadsheetApp.openByUrl('https://docs.google.com/spreadsheets/d/1cdLeAOOVQyYYtjoMViEWr-8RW6yEdhfNjLynCsdpz6E/edit?gid=0#gid=0'); // Name of the…

September 4, 2024 | Editorial Team

How to Connect ChatGPT with Google Sheets using App Script: A Google Apps Script Tutorial

AppSScript Code Copy Code function onOpen() { var ui = SpreadsheetApp.getUi(); ui.createMenu('Chatgpt AI') .addItem('Generate Answers', 'generateAnswersForQuestions') .addToUi(); createHeader(); } function…

September 4, 2024 | Editorial Team

Get Notified about Google Spreadsheet Changes | Google Apps script!

AppSScript Code Copy Code function sendEmailOnEdit(e) { if (!e) return; // add this line to check if "e" is undefined…

September 4, 2024 | Editorial Team

Streamlining Data Collection: Connecting HTML Forms to Google Sheets

AppSScript Code 1 Copy Code function doGet() { return HtmlService.createHtmlOutputFromFile('index'); } function processForm(form) { var sheet = SpreadsheetApp.getActiveSheet(); var row…

September 3, 2024 | Editorial Team

Get Notified about Google Spreadsheet Changes | Google Apps script!

AppSScript Code Copy Code function sendEmailOnEdit(e) { if (!e) return; var sheet = e.source.getActiveSheet(); var sheetName = sheet.getName(); var recipients…

September 2, 2024 | Editorial Team

V1: Data Parsing From Incoming Emails

AppSScript Code Copy Code function fetchEmailData() { var labelName = "Fetch Gmail data"; // replace with the name of your…

September 2, 2024 | Editorial Team

V5- Autofill Google Doc

AppSScript Code Copy Code function onOpen() { const ui = SpreadsheetApp.getUi(); const menu = ui.createMenu('AutoFill Docs'); menu.addItem('Create New Docs', 'createNewGoogleDocs')…

August 30, 2024 | Editorial Team

Convert Your – Google Sheet into API in 2 Minutes

AppSScript Code Copy Code function doGet(req) { var doc = SpreadsheetApp.getActiveSpreadsheet(); var sheet = doc.getSheetByName('sheet1'); var values = sheet.getDataRange().getValues(); var…

August 30, 2024 | Editorial Team

Detect invalid urls with googleappsscript

AppSScript Code Copy Code function checkURLs() { var sheet = SpreadsheetApp.getActive().getSheetByName("Sheet1"); // Replace "Sheet1" with the name of your sheet…

August 16, 2024 | Editorial Team

Bulk URL Shortener In Google sheet using Bitly API & Apps Script

AppSScript Code Copy Code function shortenUrls() { var sheet = SpreadsheetApp.getActive().getSheetByName("Sheet1"); // Replace "Sheet1" with the name of your sheet…

August 16, 2024 | Editorial Team

How to Schedule Bulk Emails from Google Sheets using Google Apps Script

AppSScript Code Copy Code function scheduleDripEmails() { var sheet1 = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet1"); var sheet2 = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet2"); var dataRange = sheet1.getDataRange(); var…