1. First download google drive for PC and install .Please refer ruclips.net/video/3bW6tMBW9Ro/видео.html 2. Place the excel or csv in the drive (After Goolgedrive installation it will show new drive in the PC) 3. In the googlesheet - >go to -> Extensions ->Apps Script and paste the below code function fetch() { var file = DriveApp.getFilesByName('merged_report.csv').next(); // Change the name of the CSV var csvData = Utilities.parseCsv(file.getBlob().getDataAsString()); var sheet = SpreadsheetApp.getActiveSheet(); sheet.deleteRows(2, sheet.getLastRow()); sheet.getRange(1, 1, csvData.length, csvData[0].length).setValues(csvData); }; 4. Test manually by clicking on the play button 5. Go to triggers and set the time for daily runs. PLease let me know if you have any questions
Hi sir. Intha oru video mattum tha naan yenna expect seitheno athe pol irunthana...thanks for sharing this video. Naa oru time tracker macro create pannen and save as xlsm format...i tried to sync with google sheet but ennala mudila. Enaku itha teach panna mudiyuma please
When the data loads into Google Sheets, it is displaying as a bunch of special characters. I am importing an xlsx file instead of csv. Is this a different process? If so, can it be done in a similar way? Thanks!
Hi I copied the same script from your video but it did not work I got a message (error :Cannot retrieve the next object: iterator has reached the end.)
Hi there! This is an EXCELLENT solution to us who have no money to subscribe to services that others are selling. 👏👏👏 However, there is an issue with the data for me, it doesn't appear on the Sheet as intended, but all the data gets placed in the A-column and the data is just there with semicolons. For example if i'd have data such as song, artist name, length of song, and BPM in their own columns, it appears on the Google Sheet's column A as: Shivers;Ed Sheeran;3.40;130.00.00 instead all of them appearing neatly in their own columns. Any advice on why is that?
@@techeesh Thank you. However, I did try earlier on TextToColumnsDelimiter (as in sheet.TextToColumnsDelimiter(';')), but all I got as a response was "TypeError: sheet.TextToColumnsDelimiter is not a function". :( If I use it as sheet.TextToColumnsDelimiter.SEMICOLON, the error is TypeError: Cannot read properties of undefined (reading 'SEMICOLON'). What am I missing here? Also, the same thing with sheet.Split (";"), same error message. And with sheet.SplitTextToColumns(';'). And I tried to put csvData in front of Split and TextToColumnsDelimiter (such as csvData.Split (";")), but the same result sadly. :( function fetch() { var file = DriveApp.getFilesByName('ListOfSongs.csv').next(); // Change the name of the CSV var csvData = Utilities.parseCsv(file.getBlob().getDataAsString()); var sheet = SpreadsheetApp.getActiveSheet(); sheet.deleteRows(1, sheet.getLastRow()); sheet.getRange(1, 1, csvData.length, csvData[0].length).setValues(csvData); sheet.TextToColumnsDelimiter(';'); };
can you pls share the correct script i have and error in delete row code /** @OnlyCurrentDoc */ function UntitledMacro() { var spreadsheet = SpreadsheetApp.getActive(); spreadsheet.getRange('A7').activate(); }; function fetch() { var file = DriveApp.getFilesByName('SUPPLY').next(); var csvData = Utilities.parseCsv(file.getBlob().getDataAsString()); var sheet = SpreadsheetApp.getActiveSheet(); sheet.deleteRows(2, sheet.getLastRow()); sheet.getRange(1, 1, csvData.length, csvData[0].length).setValues(csvData); }; pls help as soon as possible
/** @OnlyCurrentDoc */ function UntitledMacro() { var spreadsheet = SpreadsheetApp.getActive(); spreadsheet.getRange('A7').activate(); } function fetch() { var file = DriveApp.getFilesByName('SUPPLY').next(); var csvData = Utilities.parseCsv(file.getBlob().getDataAsString()); var sheet = SpreadsheetApp.getActiveSheet();
// Clear existing content from row 2 onward var lastRow = sheet.getLastRow(); if (lastRow > 1) { sheet.getRange(2, 1, lastRow - 1, sheet.getLastColumn()).clearContent(); }
// Paste new data sheet.getRange(1, 1, csvData.length, csvData[0].length).setValues(csvData); } Try this one
Looks great. Kindly share the script
1. First download google drive for PC and install .Please refer ruclips.net/video/3bW6tMBW9Ro/видео.html
2. Place the excel or csv in the drive (After Goolgedrive installation it will show new drive in the PC)
3. In the googlesheet - >go to -> Extensions ->Apps Script and paste the below code
function fetch() {
var file = DriveApp.getFilesByName('merged_report.csv').next(); // Change the name of the CSV
var csvData = Utilities.parseCsv(file.getBlob().getDataAsString());
var sheet = SpreadsheetApp.getActiveSheet();
sheet.deleteRows(2, sheet.getLastRow());
sheet.getRange(1, 1, csvData.length, csvData[0].length).setValues(csvData);
};
4. Test manually by clicking on the play button
5. Go to triggers and set the time for daily runs.
PLease let me know if you have any questions
@@techeesh hii if i want to store the file in onedrive. is it using the same code or is there any changes i should do for the script
Great video! May I ask if it only works with .csv files? And does the .csv file have to be located on the same Google Drive?"
Hi sir. Intha oru video mattum tha naan yenna expect seitheno athe pol irunthana...thanks for sharing this video. Naa oru time tracker macro create pannen and save as xlsm format...i tried to sync with google sheet but ennala mudila. Enaku itha teach panna mudiyuma please
If you can convert it to a csv file then this method will work
Wonderful... Can i get it live auto sync realtime data.?? At one sec interval???
Yes... You can use triggers
நன்றி bro.. can you please make video for that?? It will be highly useful.. please consider it
It's really awesome & I really loved it
As I need to do same functionality, could you pls share the script ?
Mail me @ seashore707@gmail.com
@@techeesh hi there... Kindly please do share with me too. Would be grateful for it. Thanking you in advance.
Hi. Great video. Can you send me the script?
Thank you for sharing this. Is it possible to do the same if my input file is an Excel worksheet. I mean, file saved as ".xlsx"
It's trigger didn't work like real sync
Thank you very much for the video tutorial, it's great This video has helped me a lot in my work. ^_^
it worked for you?
Glad to hear that!
When the data loads into Google Sheets, it is displaying as a bunch of special characters. I am importing an xlsx file instead of csv. Is this a different process? If so, can it be done in a similar way? Thanks!
Really nice. Could you please share the script .
Hi I copied the same script from your video but it did not work I got a message (error :Cannot retrieve the next object: iterator has reached the end.)
Just enter something in the Google sheet.. and try
save file in google drive
Hi there! This is an EXCELLENT solution to us who have no money to subscribe to services that others are selling. 👏👏👏 However, there is an issue with the data for me, it doesn't appear on the Sheet as intended, but all the data gets placed in the A-column and the data is just there with semicolons. For example if i'd have data such as song, artist name, length of song, and BPM in their own columns, it appears on the Google Sheet's column A as:
Shivers;Ed Sheeran;3.40;130.00.00
instead all of them appearing neatly in their own columns. Any advice on why is that?
It will copy all the data available in the CSV file... You can add a delimiter command at the end of the script to get it fixed
@@techeesh Thank you. However, I did try earlier on TextToColumnsDelimiter (as in sheet.TextToColumnsDelimiter(';')), but all I got as a response was "TypeError: sheet.TextToColumnsDelimiter is not a function". :(
If I use it as sheet.TextToColumnsDelimiter.SEMICOLON, the error is TypeError: Cannot read properties of undefined (reading 'SEMICOLON').
What am I missing here?
Also, the same thing with sheet.Split (";"), same error message. And with sheet.SplitTextToColumns(';'). And I tried to put csvData in front of Split and TextToColumnsDelimiter (such as csvData.Split (";")), but the same result sadly. :(
function fetch() {
var file = DriveApp.getFilesByName('ListOfSongs.csv').next(); // Change the name of the CSV
var csvData = Utilities.parseCsv(file.getBlob().getDataAsString());
var sheet = SpreadsheetApp.getActiveSheet();
sheet.deleteRows(1, sheet.getLastRow());
sheet.getRange(1, 1, csvData.length, csvData[0].length).setValues(csvData);
sheet.TextToColumnsDelimiter(';');
};
This is what I’m finding, can I have your script ? Thanks a lot
Please email me @ seashore707@gmail.com
When I run I always got “Those rows are out of bounds “. Have any way to solve it?
Add a random content before running the script
Waoo.. great video... I need the script
How didi you do this?
CAN WE CALL XLXS MACRO ENABLED FILE TOO OR ONLY CSV EXTENSION FILES
Look great, kindly share with me
Hi there! Such a nice video. I've sent an email to you so I can get the script, looking forward from your reply. Thanks mate all the best!
Hey, great vid. Where do you save the csv file?
Please email me @ seashore707@gmail.com
in google drive
Can you please share the script
This is a fabulous technique. Could you please share the script.
Pls check the pinned comment
I want that code. Can u please share that code.
Can you please send me the script,i wrote to your email addres?
I want this code
CAN I HAVE A SCRIPT?
Hello, plz send me the script and excel files
Thanks
Where i will save my file please let me know its not working for me and can we need to save file as .csv(comma delimited)
Yes
save file in google drive
Good video Can you send me this script please?
Hi,
Can everyone send me his script?
Thanks
this is the best ive seen. can you share?
Drop me the mail to seashore707@gmail.com .. I'll share
Please subscribe and support
@@techeesh oh i already did both and sent the email now
@@thepoolstatguy sent mail with instructions
i have liked and subscribed your channel, please share the details regarding this video, how to sync sheet and excel
@@thepoolstatguy Can you share with me too?
Can I get Script?
Pls mail me @ seashore707@gmail.com
There is no pinned comment.......
Please send me your scripts
This didn't work for excel
Works only with CSV
Thanks you so much! Can you share me abouy script.
Sent
Pls share the script sir
Mail me @ seashore707@gmail.com
Hi genius, Could you send me this script?. I´m writing from argentina. thnx!
Drop me a mail @ seashore707@gmail.com
Hello
Please can you send me this script?
Sir can you please share the script ??
Check the pinned comment
Can you sent me script?
Please email @ seashore707@gmail.com
I sent mail
Sent
plz send me the script sir
Email me seashore707@gmail.com
pls send me script
mail id
Hi sir pls send me this script
Check the pinned comment
Can you please share the script
Mail me @ seashore707@gmail.com
can you pls share the correct script i have and error in delete row code
/** @OnlyCurrentDoc */
function UntitledMacro() {
var spreadsheet = SpreadsheetApp.getActive();
spreadsheet.getRange('A7').activate();
};
function fetch() {
var file = DriveApp.getFilesByName('SUPPLY').next();
var csvData = Utilities.parseCsv(file.getBlob().getDataAsString());
var sheet = SpreadsheetApp.getActiveSheet();
sheet.deleteRows(2, sheet.getLastRow());
sheet.getRange(1, 1, csvData.length, csvData[0].length).setValues(csvData);
};
pls help as soon as possible
/** @OnlyCurrentDoc */
function UntitledMacro() {
var spreadsheet = SpreadsheetApp.getActive();
spreadsheet.getRange('A7').activate();
}
function fetch() {
var file = DriveApp.getFilesByName('SUPPLY').next();
var csvData = Utilities.parseCsv(file.getBlob().getDataAsString());
var sheet = SpreadsheetApp.getActiveSheet();
// Clear existing content from row 2 onward
var lastRow = sheet.getLastRow();
if (lastRow > 1) {
sheet.getRange(2, 1, lastRow - 1, sheet.getLastColumn()).clearContent();
}
// Paste new data
sheet.getRange(1, 1, csvData.length, csvData[0].length).setValues(csvData);
}
Try this one
I just sent you an email, please check your email, thank you very much❤
Can you please send me the script, I wrote to your email address?
Please email me seashore707@gmail.com