Small dockerized python script to convert a google sheet into a Trello board
1) Create a copy of the 'Example Template' on Google and fill it in based on the instructions in it. https://docs.google.com/spreadsheets/d/1Q_aOqbvPPiDeovl-eDC7bKdurMq1M_BQyY9tca1i-lg/edit#gid=372680571
2) Run this docker command
docker run -it praqma/gsheets2tboards:latest
You need to have read access to the sheet importing from. After the import, you have a personal Trello board.
The credentials in this project will only work on eficode
GSuite Google accounts. If you want to run it within your own organisation, you need to do the following:
ENABLE APIS AND SERVICES
and turn on the Google Sheets API for your project.OAuth consent screen
tab, and create an Internal
project. If you want it to be external, you will have to wait for Google to verify your project. Add scope -> ../auth/spreadsheets.readonly
. Click Save
.Credentials
tab and click CREATE CREDENTIALS -> OAuth client ID
. Choose the Application type Other
. client_id
and client_secret
in client_secret.json
with the credentials you just created.docker build -t gsheets2tboards .
docker run -it gsheets2tboards