Need small python program that uses google spreadsheet api
$5-10 USD
Cancelled
Posted over 11 years ago
$5-10 USD
Paid on delivery
I need a simple python script that replaces the contents of a google spreadsheet worksheet with the results of db query. This is a small task - I will pay $10 for it.
Your inputs will be
- dbquery, dbname, dbhost,dbport dbuser, dbpassword
- google-user, google-passwd, spreadsheet url, worksheet name, x,y position where the query result should be pasted
The result should be the equivalent to producing a csv with headers out of the query and then in then importing that csv at the specified spreadsheet/worksheet/x,y position
- The script should be minimal in terms of code needed (10-100), library dependencies and highly readable - it shouldn't need un-necessary commenting
- The inputs can be in the form of configuration variables within the code
- The code does not need to be dealing with errors - i.e. assume that things that typically work do work.
- The code should emit minimum progress reporting info (issuing query, … connecting to spreadsheet service… updating…)
- If you feel that some of the above requirements or assumption affects too much the complexity, then ask me - you probably know better (I hope).
- I should be able to install any missing dependencies, modify the configuration constants above and then just run the script
Include in the file as documentation a minimal readme about how to use the script .
I will pay $10 for a job well done.