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

[Martin Molloy]

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.

https://gsuite.google.com/marketplace/app/sheetsie/369803151024 

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.

https://blog.sheetgo.com/how-to-solve-with-sheetgo/import-csv-to-google-sheets-automatically/

 

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]

You can using...

https://tanaikech.github.io/2019/08/28/benchmark-importing-csv-data-to-spreadsheet-using-google-apps-script/

put it to automate via setting triggers at desired interval.

[Martin Molloy]

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.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/33fe58e8-8237-4186-8f7f-5a9562a528c7o%40googlegroups.com.

[Martin Molloy]

Hi Vincent

Take a look at this

https://www.labnol.org/code/20279-import-csv-into-google-spreadsheet

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

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/f182c11d-a8c4-4e18-8852-9a4cef24fb30o%40googlegroups.com.