Help with using google sheets

(Rotakoi) #1

Is there a feature to add a certain value(number) to a row(named user account), when a user says /add 10 it will automatically add 10 to the user account

(Karen Barker) #2

Hi Dishaan,

You’d be able to set this up by using the text split function to return only the number in the users entry.

You could then use the output of this action to update/add a row dependent on how you want this to work to your Google Sheet.

To recognise the correct user you might want to store the users response path in the Google Sheet so you know which row to update depending on who is speaking to the bot.

(Rotakoi) #3

I Found a better solution
When the user says add10
It will add a row , there will be another row which totals all the things and gives the output.