Hi. My name is Ken. I am trying to create a Slack Bot first one message every Monday at 9:00 am and asks for a input (goal number of sales for the week). Then responds with user input in new message saying (great your weekly sales goal is (#). Then it takes this number and adds it to Google sheets. Then asks user to enter daily goal for the day. And responds with (daily goal set as). Then at 9:00 pm asks user to input the number of deals written and keeps track of all data in Google sheets and provides graphs. I have been thinking maybe MySQL would work for that too. It’s for my senior year project.
Creating Slack Bot with Google Sheets Integration
KarenBarker
(Karen Barker)
#2
Hi Ken,
This is definitely something that you could do using a bot.
You’ll need to use the Wait function to set the time to wait until Monday at 9am. This will be followed by an Ask A Question action to ask the weekly sales goal #. The users response is stored as the answer to this question which you can then use to add to Google Sheets. You’ll then repeat the question for the Daily Goals and again store this in Google Sheets. The wait function will then allow you to pause until 9pm to ask the final question.
Give it a go and if you get stuck we’ll be happy to help out. 
1 Like