GoogleSheet Writer - Python To AppScript

Job ID: 34178505

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.