Re: [Apps-Script] How to import CSV to Google Sheets Automatically

630 views
Skip to first unread message
Message has been deleted

Martin Molloy

unread,
Jul 19, 2020, 4:32:25 AM7/19/20
to google-apps-sc...@googlegroups.com
Hi Vincent

If you don't want to write a script to do it. Sheetgo will work and save you the work.It is a paid product. It will cost you $240 a year to import a csv file every week.

I publish a sheets addon called Sheetsie, which will also do the job for you. It costs $144 a year.

Here is the link if you want to try it.

Martin 



On Sun, 19 Jul 2020 at 08:54, Vincent Adipietro <vincent....@gmail.com> wrote:
Hi! I am trying to figure out the best way to import a CSV file to Google Sheets automatically. I receive a new CSV file weekly, and manual importing it to sheets every week is very time consuming. I came across the article below, as a way to automate this process. Please let me know your thoughts, and if this is a good method.

Best,
Vincent Adipietro

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/d4f627a5-d6f7-4cd3-9777-a95fe0713837o%40googlegroups.com.

Gitesh Kohli

unread,
Jul 19, 2020, 10:13:06 AM7/19/20
to google-apps-sc...@googlegroups.com
You can using...
Message has been deleted

Martin Molloy

unread,
Jul 19, 2020, 3:18:35 PM7/19/20
to google-apps-sc...@googlegroups.com
Hi Vincent

If you write your own script you are in complete control of the data. It is held in the spreadsheets you save it to. The only people who have access to the data are the people you share your spreadsheet with

The same applies if you use my add on SheetsIE. None of the data goes outside your domain; it is always entirely within your control. Again the only people who have access to your data are the people you share your spreadsheet with.

Sheetgo say the same on their website.

Hope that helps

Martin
Martin Molloy
MTMOMK Limited


On Sun, 19 Jul 2020 at 19:39, Vincent Adipietro <vincent....@gmail.com> wrote:
Hi Martin,

Thank you for the quick response!

I am not against writing a script to do it, but are there security issues there? I want to ensure the files are safe, and not accessible by the public.
Message has been deleted

Martin Molloy

unread,
Jul 20, 2020, 3:29:12 AM7/20/20
to google-apps-sc...@googlegroups.com
Hi Vincent

Take a look at this


Martin


Martin Molloy
MTMOMK Limited
Add-ons: 
Form Maker; Create forms quickly and easily using a spreadsheet interface.
SheetsIE; Automate the movement of data between files of different types.
Accounts Manager; Manage User Accounts for your domain from a spreadsheet.
Classroom Manager; Mange Google Classroom classes and class lists for one teacher or the whole domain
Password Manager; Delegate management of user password resets to trusted users.
Drive Files Metadata; use a spreadsheet to view and mange metadata about your Google Drive files.
Sheets Pages Manager; Manage the pages in your Google Sheets files.


On Mon, 20 Jul 2020 at 07:13, Vincent Adipietro <vincent....@gmail.com> wrote:
Hi Martin,

Well noted! I guess I was concerned about the database that will store the CSV, but I found out I can use Google Drive.

Do you have any recommendations as to where to begin, if I wanted to write my own script?

I will also check out your add-on!

Best,
Vincent Adipietro
Reply all
Reply to author
Forward
0 new messages