You cannot apply on this project as you are not part of any company. Please add new or join existing company.
Sorry, you cannot apply on this project. But you can apply on many other projects. Find More Projects

Google Sheets Script - Auto/Schedule Import of .txt File Closed

I have a piece of software that saves the data file in txt format on Google Drive (shareable link). I need a script that will auto import the data on a predetermined schedule (delimited). There will be multiple files that need to be imported, each one into their own worksheet (the same exact file format for each). The header needs to be slightly manipulated upon import, parsing out some text so that the headers are in date format (date/times are there, just surrounded by extra characters).


REQUIREMENTS:

1) Create a simple control panel worksheet where I can adjust the settings for the entire thing (frequency of import, start time, original txt file URLs)

2) Script should run automatically and continuously so it will import all data on its own. Each txt file will import into it's own worksheet.

3) The imported headers need to be auto-parsed, so it strips out the extra characters, and each column header is just a date/time format.


This really is a simple project. It sounds more complicated than it is. PMB me and I can send you a sample file so you see what I'm talking about.


Thank you!


Posted On: August 14, 2017 00:10 UTC
Category: Web, Mobile & Software Dev > Scripts & Utilities
Country: United States
ID103242 TitleGoogle Sheets Script - Auto/Schedule Import of .txt File
TypeHourly Budget$2-$5
Is PrivateNo Created On3 months ago