App Scripts

function clearInvoice() {

 const sheet = SpreadsheetApp.getActiveSheet();

 const invoiceDate = sheet.getRange("H2").clearContent(); //Update cell/range as needed

 const invoiceNumber = sheet.getRange("H4").clearContent(); //Update cell/range as needed

 const invoiceDueDate = sheet.getRange("H6").clearContent(); //Update cell/range as needed

 const invoiceProjectDetails = sheet.getRange("B16").clearContent(); //Update cell/range as needed

 const invoiceBillTo = sheet.getRange("B9:B13").clearContent(); //Update cell/range as needed

 const invoiceItemRange = sheet.getRange("B19:G27").clearContent(); //Update cell/range as needed

 const invoiceRemarks = sheet.getRange("B29:B30").clearContent(); //Update cell/range as needed

}

function insertDefault() {

 const sheet = SpreadsheetApp.getActiveSheet();

 const invoiceDate = sheet.getRange("H2").setValue('January 1, 2025'); //Update cell and value as needed

 const invoiceNumber = sheet.getRange("H4").setValue('1000'); //Update cell and value as needed

 const invoiceDueDate = sheet.getRange("H6").setValue('February 1, 2025'); //Update cell and value as needed

 const invoiceProjectDetails = sheet.getRange("B16").setValue('Type Project Description Here'); //Update cell and value as needed

 const invoiceBillTo1 = sheet.getRange("B9").setValue('CLIENT COMPANY NAME'); //Update cell and value as needed

 const invoiceBillTo2 = sheet.getRange("B10").setValue('CLIENT COMPANY ADDRESS'); //Update cell and value as needed

 const invoiceBillTo3 = sheet.getRange("B11").setValue('ADDRESS LINE 2'); //Update cell and value as needed

 const invoiceBillTo4 = sheet.getRange("B12").setValue('CITY, STATE, ZIP CODE'); //Update cell and value as needed

 const invoiceItemDate = sheet.getRange("B19").setValue('12/15/24'); //Update cell and value as needed

 const invoiceItemDescription = sheet.getRange("C19").setValue('Enter description here'); //Update cell and value as needed

 const invoiceItemHours = sheet.getRange("F19").setValue('2'); //Update cell and value as needed

 const invoiceItemRate = sheet.getRange("G19").setValue('$100'); //Update cell and value as needed

 const invoiceRemarks = sheet.getRange("B29").setValue('Enter details here'); //Update cell and value as needed

}