Adding a row Google Sheet Python

Question

I want to add a line to the google sheet document with python. But it doesn't work and I always find this error:

Traceback (most recent call last):
  File "D:\...\...\...\spreadsheet.py", line 27, in <module>
    sheet.add_rows(row,1)
TypeError: add_rows() takes 2 positional arguments but 3 were given

I'm using this code:

import gspread
from oauth2client.service_account import ServiceAccountCredentials
from pprint import pprint

scope = ["https://spreadsheets.google.com/feeds",'https://www.googleapis.com/auth/spreadsheets',"https://www.googleapis.com/auth/drive.file","https://www.googleapis.com/auth/drive"]


creds = ServiceAccountCredentials.from_json_keyfile_name("GymBot_database.json", scope)

client = gspread.authorize(creds)

sheet = client.open("GymBot_sheet").sheet1  # Open the spreadsheet

row = sheet.row_values(2)  # Get a specific row
insertRow = ["hello", 5, "red", "blue"]

sheet.add_rows(row, 1)  # Insert the list as a row at index 1

This code is not really mine I copied it from this link, to do some tests. But in my case it doesn't work and I don't know why.

I see a typo in your code, add_rows takes insertRow as input not row. Check the link again. — sushanth
– sushanth, Commented May 26, 2020 at 18:43

Jason Chen · Accepted Answer · 2020-05-26 18:53:14Z

1

If you look at the documentation (https://gspread.readthedocs.io/en/latest/api.html#gspread.models.Worksheet.add_rows)

add_rows(rows)

Adds rows to worksheet. Parameters: rows (int) – Number of new rows to add.

add_rows(rows) adds a specified number of empty rows at the bottom of the sheet. I think what you want instead is to insert values into the sheet. You can use append_row (https://gspread.readthedocs.io/en/latest/api.html#gspread.models.Worksheet.append_row).

e.g.

sheet.append_row(insertRow, table_range="A1")

answered May 26, 2020 at 18:53

Jason Chen

1941 silver badge5 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Julian George Over a year ago

This is outdated now

ppxx · Accepted Answer · 2021-04-03 19:28:44Z

1

Try this to append. sheet.append_row(insertRow)

answered Apr 3, 2021 at 19:28

ppxx

1982 silver badges12 bronze badges

Comments

Jack Cummins · Accepted Answer · 2020-05-26 18:45:57Z

0

You need to use insertRow as your parameter for the function add_rows. You used row as your parameter. Try changing that.

answered May 26, 2020 at 18:45

Jack Cummins

411 gold badge1 silver badge8 bronze badges

Collectives™ on Stack Overflow

Adding a row Google Sheet Python

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related