Google Sheets - Importar Archivo CSV de Nuestra PC con Google Apps Script de Forma Automatica

Google Sheets - Automatically Import a CSV File from Your PC with Google Apps Script Today you will learn how to automatically import a CSV file stored on your PC into your Google Sheets spreadsheet using Google Apps Script. You will also be able to create a button that, when clicked, will import the data contained in your CSV file. I will first show you how to create the script and build the code for the function you will use. Then, I will assign the function to your button so that, when clicked, the information will be imported. I'll leave the code here so you can copy it directly into your Google Apps Script editor. Code: var sheet = SpreadsheetApp.getActive().getSheetByName('tab name'); var fSource = DriveApp.getFolderById('drive folder id'); var fi = fSource.getFilesByName('csv file name'); var file = fi.next(); var csvData = Utilities.parseCsv(file.getBlob().getDataAsString('ISO-8859-1')); function importCsv() { sheet.getRange('A:G').clearContent(); // Enter the columns to be deleted here sheet.getRange(1,1,csvData.length,csvData[0].length).setValues(csvData); } 👉🏻 Here's the Google Sheets link: https://www.google.com/sheets/about/ 👉🏻 Don't forget to subscribe to my Channel... Here's the link. https://www.youtube.com/c/MCAdminSolu... OTHER VIDEOS YOU MIGHT BE INTERESTED IN: 👉🏻Here's my tutorial on the IF function in Google Sheets in Spanish:    • Google Sheets Tutorial En Español - Funcio...   👉🏻Here's my tutorial on matching indexes in Google Sheets in Spanish:    • Google Sheets Tutorial En Español - Indice...   👉🏻Here's a way to search left with reverse search:    • Google Sheets Tutorial Español - BUSCARV I...   👉🏻I'm also sharing my tutorial on the Google QUERY function. sheets:    • Google Sheets ARRAYFORMULA - ARRAYS   👉🏻Here's a link to another video where I talk about IMPORTRANGE and Arrays.    • Google Sheets Tutorial Español - Funcion Q...   #googleAppsScript #googleSheets 🖋️Thanks, don't forget to subscribe! I'll be uploading video tutorials every week! https://www.youtube.com/c/MCAdminSolu... Tags: Google Sheets How to use Google Sheets Google Sheets Spanish tutorial Google Sheets spreadsheets Google Sheets course Google Drive spreadsheets Google Sheets spreadsheets Google Sheets tutorial Google Sheets for beginners Google Sheets tutorial in Spanish Import CSV with Google Apps Script to Google Sheets Import CSV to Google Sheets CSV Google Apps Script Google Drive tutorial Google Drive CSV Install Google Drive on PC Sync files with Google Drive