Tablot

whenever someone sends a public google sheets link in the server, Tablot takes the google sheet data and displays it in the form of a table.

we currently use terminaltables to generate the table.

we are working on this just for the sake of getting familiarized with discord.py

why tablot?

It's like one of those small things that makes your life 1% easier <3 ~ clash

commands

general commands

about command: $ts
action: bot introduces itself

ping command: $ts stats
action: returns bot latency in ms

gsheet commands

using google sheets link

full gsheet using gsheet link command: $ts show "<google sheet link>"
action: displays the whole table

gsheet link specific rows command: $ts show "<google sheet link>" row value
action: displays rows belonging to the specified value
(you can use --r instead of row)

gsheet link specific columns command: $ts show "<google sheet link>" col value
action: displays a specific column using column name (you can use --c instead of col)

using owner defined link variable

assign name to gsheet link (only the owner can do) command: $ts link <"link"> linkVariable
action: assigns a name to the link provided by the owner

full gsheet using owner defined link variable command: $ts show variableName
action: displays the whole table

gsheet linkVariable specific rows command: $ts show linkVariable row value
action: displays rows belonging to the specified value (you can use --r instead of row)

gsheet link specific columns command: $ts show linkVariable col value
action: displays a specific column using column name as value (you can use --c instead of col)

building from source

Install everything written in requirements.txt with pip install.

cd to tablot directory.

change cred variable value to your creds.json values

also put your discord bot token inside client.run()

mihiraggarwal/tablot