I receive stats everyday by mail, in a google analytics format (.csv , a file with 3 tabs; the important data is in the 2nd tab). How can I automate to the most the task of getting the data out of the 2nd tab? Can I, for example, a) create a rule in Zoho docs so that the program will have a look everyday into a certain cloud folder, open the file and get the data from the 2nd tab? b) Can I email zoho? (just like i email "podio", for example). c) should I create a Centralization file, place it in a cloud folder, tell the route to Zoho crm and tell zoho crm the instructions to get the data every week, and then open the .csv file I get by email and cut and paste the content of the 2nd tab into the Centralization file everyday? (so that zoho can show the updated data every week).
In case of having to do it like stated in C), then, would it be better to paste the data of each day in a new row, day after day, right? Please, tell me if I should post this question into a help forum. Thanks!