GoogleSheet Writer - Python To AppScript
Budget: $250 – $750 USD
Description:
Create a project for Google Sheets - App Script & Python.
Trigger App Script functions via Python on a user's spreadsheet documents.
It should be useable for any user and any sheet document.
We should be able to send parameters to that functions - test results should be updated to the document based on function inputs.
Sample
The function implemented on AppScript
appScriptFunction(string, cell) ->
// Row A B
// 1 - -
// 2 - -
Example
Input appScriptFunction("hello", "A1") -> Output
// Row A B
// 1 hello -
// 2 - -
This function needs to be triggered via Python Code. Python code can be done using any framework.
Final Output - Shared Github repository
1. Python code to execute app script -
2. Documents on
A. How to set up AppScript project.
B. How to setup google credentials for python projects.
3. Video tutorial of the entire project / Well-written document and proof of working implementation.
Create a project for Google Sheets - App Script & Python.
Trigger App Script functions via Python on a user's spreadsheet documents.
It should be useable for any user and any sheet document.
We should be able to send parameters to that functions - test results should be updated to the document based on function inputs.
Sample
The function implemented on AppScript
appScriptFunction(string, cell) ->
// Row A B
// 1 - -
// 2 - -
Example
Input appScriptFunction("hello", "A1") -> Output
// Row A B
// 1 hello -
// 2 - -
This function needs to be triggered via Python Code. Python code can be done using any framework.
Final Output - Shared Github repository
1. Python code to execute app script -
2. Documents on
A. How to set up AppScript project.
B. How to setup google credentials for python projects.
3. Video tutorial of the entire project / Well-written document and proof of working implementation.