I want to do the same thing, only bring in a CSV file from my C drive on my laptop rahter than from Google drive. I have searched and searched and can't find the way to do this. Do you know if there is a way to do this? I have code that does this in Excel VBA but can't find the equivalent way of doing it in Sheets. I know how to write script code that prompts the user to select a file from a Windows file dialog so that I can get the file name, but I don't know how to read that data and convert it to a worksheet.
So with Google Apps Script, there isn't a way to upload files from C drive natively without user interaction. You would have to have some kind of service on your desktop that the script could access. If you're wanting to upload CSVs from your computer on a regular basis or with automation, what you'll probably want to do is get a python or other local script. Another option is download "Google Drive for Desktop" and then when you're on your computer, you can drop files right into a Google Drive folder shortcut on your desktop: www.google.com/drive/download/
Awesome Video! Exactly what I needed. This will help me and my DAD. Thank you for making this video!
I want to do the same thing, only bring in a CSV file from my C drive on my laptop rahter than from Google drive. I have searched and searched and can't find the way to do this. Do you know if there is a way to do this? I have code that does this in Excel VBA but can't find the equivalent way of doing it in Sheets. I know how to write script code that prompts the user to select a file from a Windows file dialog so that I can get the file name, but I don't know how to read that data and convert it to a worksheet.
So with Google Apps Script, there isn't a way to upload files from C drive natively without user interaction. You would have to have some kind of service on your desktop that the script could access. If you're wanting to upload CSVs from your computer on a regular basis or with automation, what you'll probably want to do is get a python or other local script.
Another option is download "Google Drive for Desktop" and then when you're on your computer, you can drop files right into a Google Drive folder shortcut on your desktop: www.google.com/drive/download/