'Daily Google Sheets trigger csv import from CRM
I have a Google Sheet that I'm wanting to overwrite data on every day with a HTML link download that will also require a login and password to access. Is there a way to use Google Sheets scripts to accomplish this? For Example. I'd like to import and overwrite starting with cell A1 with the first csv file, BA2 with the 2nd csv file, and DA2 with the third csv file.
For the last year I've had to manually download, and manually import these files each day for our reports to show up correctly.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|