How to create a new sheet and change its name in Google spreadsheet?

Question

Python

How to use python to create a new sheet and change its name in google spreadsheet?

Answer 1

Documentation

Answer 2

Probably gspreadnot a bad solution, but with the advent of the Sheets API v4, things have become a little easier.

spreadsheetId=''
new_sheet_title=''

from googleapiclient.discovery import build
service = build('sheets', 'v4')

requests = []

requests.append({
    'addSheet': {
        'properties': {
            'title': new_sheet_title
        }
    }
})

body = {
    'requests': requests
}

response = service.spreadsheets().batchUpdate(
  spreadsheetId=spreadsheetId,
  body=body).execute()

You can run the code "here and now" at the link https://colab.research.google.com/drive/1_IdQAxqk7...

Answer 3

https://github.com/burnash/gspread