Is there any way to display a sheet name as the result of a function in a Google Spreadsheet (exactly like this question, except in gspread)?
Display Sheet Name in Google Spreadsheet
google spreadsheets
Someone has written a script to do this. It is available in Tools > Script gallery.... Search for sheet name and install the script, then use it with =getCurrentSheetName()