Google sheets or from scratch?

Good evening. I have to back to the survey results, which then need to upload in Excel and word, so, please advise how can I be, say, could learn from their project Google spreadsheets or to write all from scratch? I need the variant with maximum efficiency in minimal time. Thank you
April 4th 20 at 00:48
3 answers
April 4th 20 at 00:50
Solution
Who will bring to the polls? It trusted people (your staff) or you can spoil someone else's work?
The results will be entered by the script, if the api allows it, I will try - maymie.Torphy commented on April 4th 20 at 00:53
Script sent to the warehouse files the text data easiest way to CSV. Then either collect them from a single file and import it in Excel or import into Excel one at a time. - Shaylee_Ernser90 commented on April 4th 20 at 00:56
@Shaylee_Ernser90, there is an example? - maymie.Torphy commented on April 4th 20 at 00:59
An example of what? Filogeniya? It depends on the situation - Samba, FTP, SFTP, something cloud.

Script? Depends on the Protocol. And from where to take data.

Merging files in a bunch? Well, cat *.csv >result/result.csv(to cat is not caught, the result of their work). - Shaylee_Ernser90 commented on April 4th 20 at 01:02
Why data is not exported to Google spreadsheet? - maymie.Torphy commented on April 4th 20 at 01:05
April 4th 20 at 00:52
Solution
For this idea enough Google spreadsheets. If faced with Google forms, you will understand that you Google for free did it all. Well, if you do not like the Google form, the mass of tutorials for a bunch samopisnogo front with Google spreadsheets. Contact us and we will try to help.
Just got up, sorry. Did not work with Google services, I would be grateful for the tip, maybe the article is there, where js transmit data in Google spreadsheet? I have the architecture of the table are discussed with the customer, but I think if you see how one is made, will be able to make your option. Thank you. - maymie.Torphy commented on April 4th 20 at 00:55
In the comments above is the guide, now I will try. - maymie.Torphy commented on April 4th 20 at 00:58
Why data is not exported to Google spreadsheet? - maymie.Torphy commented on April 4th 20 at 01:01
April 4th 20 at 00:54
Solution
And the customer-what he wants? The cost of development will be very different if all washed down by 100% from scratch.
I think this is a good reason for learning integrtiy with Google Sheets. By the way, "pile up", and the data Analytics service to connect.
I found this integrator services: zapier.comthere is a large selection of services is, in many ways.
I would be grateful for views on its use in WEB development and programming, because it is still hands did not reach.
I need from the database to build the query in the Google table, it will be able to implement? - maymie.Torphy commented on April 4th 20 at 00:57
Here is a step by step guide :) from MySQL in a Google doc spreadsheet. He did not expect that so simple when have the manual :).
The second option, if not will, to do the same using Zapier. Maybe then there is something you will need. I wonder how this service settings will understand. Please give me feedback if you use, or someone else wants to use.
If the feedback needs to be set, it is possible here to dig. Although at this stage you probably don't "return" - chandler89 commented on April 4th 20 at 01:00
zapier - awesome. but worth the money, if even a little something more complicated linear flow.
if you have the skills to effectively execute yourself. - Loyce96 commented on April 4th 20 at 01:03
@Loyce96, then all linear, I don't know what will happen then, if needed, we will return to this issue, thanks - maymie.Torphy commented on April 4th 20 at 01:06
@chandler89, thank you, start trying - maymie.Torphy commented on April 4th 20 at 01:09
Why data is not exported to Google spreadsheet? - maymie.Torphy commented on April 4th 20 at 01:12

Find more questions by tags JavaScriptData storage