[PYTHON] A story connecting Slack and google spreadsheets

It's pretty easy to just connect slack and google spreadsheets

I will proceed on the assumption that the API of slackbot has already been created,

Click here for how to make slackbot

I will continue to add settings to my_mention.py here.

And this person has written how to get google API. Probably the easiest to understand here ...

Google API and SpreadSheets API settings

After that, just give instructions to chatbot and output

In slackbot @respond_to ('Responds to what you type here') Receives the value using, and the print-like element of chatbot message.reply ('chatbot reply') You can do it here

my_mention.py

@respond_to('output')
def smart_func(message):
    message.reply('As you say')
    worksheet.update_cell(2,1,str('It's cool Mr. Murakami'))

(Worksheet.updata_cell (*, *) is from the gspread library) After that, it feels like outputting to a csv file just by giving instructions.