Hot answers tagged

3

A script cannot give a file to you (well, it could email it to you, but I think this is going too far). You'll need to use "save as csv" menu command, and since it only saves the current sheet, you'll have to create a sheet that has only those columns in it. The straightforward way is to just create a new sheet and type in cell A1 ={'My Sheet'!A:A, 'My ...


2

Based on Normal Human's answer, I've created a Google sheets script that will parse and email IFTTT based on a price threshold. Google sheet cells won't update ImportXml() or other external site data more than once every hour or so, even using workarounds. However, accessing external sites via the script works. Use the following script and set up a ...


2

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

Generating a direct download link, as described in this article seems to work fine with the =IMPORTDATA function. To summarize, you take the SITE_ID string from the sharing link you have: https://drive.google.com/file/d/FILE_ID/edit?usp=sharing Using this, you can generate the direct download link for use with the =IMPORTDATA function: ...


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

The best way to do this is to just select the cells you want to save as CSV, paste it into notepad, then find/replace tab with a comma.



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