Top Chaine YT 😍

Uniformiser des titres de postes (post scraping sale navigator)

Fichier Formule Sheet

Creer liste déroulante multi tags

Formules

Création de docs officiels - Bulk (à adapter)

📺. Tutoriel 👇

function createBulkPDFs() {
  const docFile = DriveApp.getFileById("1CiiA74JH617xX_CEWR0E79QyuyHquBBLJ4YRx0e7KD0")
  const tempFolder = DriveApp.getFolderById("13U3vfDiapfPoLKF1VW2zr-hUXfaofNrN")
  const pdfFolder = DriveApp.getFolderById("1lflBoUjj-c9XFK0PPmuIOutrJoLl-xXa")
  const currentSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("BESOINS")

  const data = currentSheet.getRange(2,1,currentSheet.getLastRow()-1,17).getDisplayValues();

  data.forEach(row => {
    try{
    createPDF(row[0],row[5],row[2],row[6],row[7],row[8],row[9],row[10],row[11],row[12],row[13],row[14],row[15],row[16],row[0],docFile,tempFolder,pdfFolder)
    } catch(err) {

    }
  }); //close for Each 
}

function createPDF(Poste,Secteur,Localisation,Contexte,Descriptif,Demarrage,Duree,Mobilite,Langues,Formations,Experience,Competences,Logiciels,Responsabilites,pdfName,docFile,tempFolder,pdfFolder) {

  // doc id 1CiiA74JH617xX_CEWR0E79QyuyHquBBLJ4YRx0e7KD0
  //  temp folder 13U3vfDiapfPoLKF1VW2zr-hUXfaofNrN
  // pdf folder 1lflBoUjj-c9XFK0PPmuIOutrJoLl-xXa
 
  const tempFile = docFile.makeCopy(tempFolder)
  const tempDocFile = DocumentApp.openById(tempFile.getId())
  const body = tempDocFile.getBody()
  body.replaceText("{Poste}", Poste);
  body.replaceText("{Secteur}", Secteur);
  body.replaceText("{Localisation}", Localisation);
  body.replaceText("{Contexte du projet}", Contexte)
  body.replaceText("{Descriptif du projet}", Descriptif)
  body.replaceText("{Date de démarrage}", Demarrage)
  body.replaceText("{Durée}", Duree)
  body.replaceText("{Mobilité}", Mobilite)
  body.replaceText("{Langues}", Langues)
  body.replaceText("{Formations}", Formations)
  body.replaceText("{Expériences}", Experience)
  body.replaceText("{Compétences}", Competences)
  body.replaceText("{Logiciels}", Logiciels)
  body.replaceText("{Responsabilités}", Responsabilites)
  tempDocFile.saveAndClose();
  const pdfContentBlob = tempFile.getAs(MimeType.PDF);
  pdfFolder.createFile(pdfContentBlob).setName(pdfName);
  tempFolder.removeFile(tempFile); 
}

Afficher l'Url pour modifier mes réponses au Google Form dans le spreadsheet de destination 👇

	/*
 * Global Variables
 */

// Form URL
var formURL = '<https://docs.google.com/forms/d/1rXt9n8Q_x4EUCohAUeCYHWBxB7CD9BY0pFuZ-wRzXUY/prefill>';
// Sheet name used as destination of the form responses
var sheetName = 'Réponses au formulaire 1';
/*
 * Name of the column to be used to hold the response edit URLs 
 * It should match exactly the header of the related column, 
 * otherwise it will do nothing.
 */
var columnName = 'Edit Url' ;
// Responses starting row
var startRow = 2;

function getEditResponseUrls(){
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(sheetName);
  var headers = sheet.getRange(1, 1, 1, sheet.getLastColumn()).getValues(); 
  var columnIndex = headers[0].indexOf(columnName);
  var data = sheet.getDataRange().getValues();
  var form = FormApp.openByUrl(formURL);
  for(var i = startRow-1; i < data.length; i++) {
    if(data[i][0] != '' && data[i][columnIndex] == '') {
      var timestamp = data[i][0];
      var formSubmitted = form.getResponses(timestamp);
      if(formSubmitted.length < 1) continue;
      var editResponseUrl = formSubmitted[0].getEditResponseUrl();
      sheet.getRange(i+1, columnIndex+1).setValue(editResponseUrl);
    }
  }
}

Macro : mise en forme nouveau spreadsheet 👇

/** @OnlyCurrentDoc */

function Nouveauspreadsheet() {
  var spreadsheet = SpreadsheetApp.getActive();
  spreadsheet.getRange('B1').activate();
};

function Nouveauspreadsheet1() {
  var spreadsheet = SpreadsheetApp.getActive();
  spreadsheet.getRange('A1').activate();
  spreadsheet.getRange('A1').applyRowBanding(SpreadsheetApp.BandingTheme.LIGHT_GREY);
  var banding = spreadsheet.getRange('A1').getBandings()[0];
  banding.setRange(spreadsheet.getRange('1:1000'))
  .setHeaderRowColor('#bdbdbd')
  .setFirstRowColor('#ffffff')
  .setSecondRowColor('#f3f3f3')
  .setFooterRowColor(null);
  banding = spreadsheet.getRange('A1:Z1000').getBandings()[0];
  banding.setHeaderRowColor('#5b95f9')
  .setFirstRowColor('#ffffff')
  .setSecondRowColor('#e8f0fe')
  .setFooterRowColor(null);
  spreadsheet.getRange('1:1').activate();
  spreadsheet.getActiveRangeList().setFontColor('#ffffff')
  .setHorizontalAlignment('center')
  .setFontSize(11);
  spreadsheet.getActiveSheet().setFrozenRows(1);
};

function myFunction() {
  var spreadsheet = SpreadsheetApp.getActive();
  spreadsheet.getRange('A1').activate();
};

function Macrosanstitre() {
  var spreadsheet = SpreadsheetApp.getActive();
  spreadsheet.getRange('H17').activate();
  var currentCell = spreadsheet.getCurrentCell();
  var sheet = spreadsheet.getActiveSheet();
  sheet.getRange(1, 1, sheet.getMaxRows(), sheet.getMaxColumns()).activate();
  currentCell.activateAsCurrentCell();
  spreadsheet.getActiveRangeList().setWrapStrategy(SpreadsheetApp.WrapStrategy.WRAP);
};