Python code to work with Google spreadsheet
Budget: $10 – $30 USD
I need a code to import and change data from a Google spreadsheet.
It is always the same spreadsheet, but I must be able to change the ID of the spreadsheet in the code.
First we need to import data in the range A1:A200 in the tab "home" and save it in a .txt file called import.txt, save in the same directory of the code. It always save in the same file "import.txt", it will overwrite the past data imported.
Repeat this action in a time interval configurable in the code, for example, 60 seconds.
After it imports, add one unit to the number in cell B2 (also configurable in the code). For example, if we have the number 1 it should change to 2, if we have the number 56 it should change to 57, so on.
Also, copy the content of cell C1:D1 of "home" tab and paste it o the first empty cell of "done" tab. For example, if we have data in the interval A1:B30 in "done" tab, paste the content on its cells A31:B31.
Let visible and clear in the code the following parameters:
Spreadsheet ID
Google account login and password
Time interval to import
Range to import
Tab to import and paste
Range to import, copy and paste
If you could, leave these in the first lines.
It is always the same spreadsheet, but I must be able to change the ID of the spreadsheet in the code.
First we need to import data in the range A1:A200 in the tab "home" and save it in a .txt file called import.txt, save in the same directory of the code. It always save in the same file "import.txt", it will overwrite the past data imported.
Repeat this action in a time interval configurable in the code, for example, 60 seconds.
After it imports, add one unit to the number in cell B2 (also configurable in the code). For example, if we have the number 1 it should change to 2, if we have the number 56 it should change to 57, so on.
Also, copy the content of cell C1:D1 of "home" tab and paste it o the first empty cell of "done" tab. For example, if we have data in the interval A1:B30 in "done" tab, paste the content on its cells A31:B31.
Let visible and clear in the code the following parameters:
Spreadsheet ID
Google account login and password
Time interval to import
Range to import
Tab to import and paste
Range to import, copy and paste
If you could, leave these in the first lines.