Tag Info

Hot answers tagged

1

My suggestion: Create a Google Spreadsheet with either ImportData (for CSV), ImportXML (for XML) or ImportFeed (for RSS/Atom). There is a trick to make it update more often than the Google default (whatever it is). Have a Google Apps script comparing the data in a particular cell to a given threshold. It can run every hour, and send an email when ...


1

Use the IMPORTDATA() built-in function. AFAIK the refresh of the data is done on the server side, so refreshing or recalculating the spreadsheet very frequently could not make any difference. The time that it takes on the server side is not documented in an canonical source; some sources say that it takes 5 minutes others 1 hour. References IMPORTDATA - ...


1

I acknowledge that this does not answer "what is Google Spreadsheets’ new line character?". However, if not for OP for others wanting to get from a text file containing: hi,hello\r\nwelcome,to\r\npeaceful,world to : a process of the kind below may suit. The technique is basically to 'feed' Google Sheets with a replacement for \r\n that ...



Only top voted, non community-wiki answers of a minimum length are eligible