1. Tutorials
  2. Google Sheets API

Python Google Sheets API: Insert and Update Row

July 16, 2019

This artile focus on insert a new row at the top (row 2).

For append row at the bottom, refer to Python Google Sheets API: Append New Row.

credentials = ...
service = build('sheets', 'v4', credentials=credentials)
sheet = service.spreadsheets()

SPREADSHEET_ID = ...
SHEET_NAME = ...
SHEET_ID = ...

# Insert New Empty Row at A2
body = {
    'requests': [
        {
            'insertDimension': {
                'range': {
                    'sheetId': SHEET_ID,
                    'dimension': 'ROWS',
                    'startIndex': 1,
                    'endIndex': 2
                },
                'inheritFromBefore': True
            }
        }
    ]
}

# Using sheet.values().batchUpdate will trigger: Invalid JSON payload received. Unknown name "requests": Cannot find field.
result = sheet.batchUpdate(spreadsheetId=SPREADSHEET_ID,
                           body=body).execute()

body = {
    'value_input_option': 'USER_ENTERED', # RAW
    'data': [
        {'range': f"'{SHEET_NAME}'!A2:B2", 'values': [["1", "New Row"]]}
    ]
}

result = sheet.values().batchUpdate(spreadsheetId=SPREADSHEET_ID,
                                    body=body).execute()

NOTE: Refer Setup and Access Google Sheets API With Python.

NOTE: Refer Python Google Sheets API: Get Sheet Id by Sheet Name.

References:

❤️ Is this article helpful?
Buy me a coffee☕ or support my work to keep this space 🖖 and ad-free.
If you can't, do send some 💖 to @d_luaz or help to share this article.
👶 Apps I built
Travelopy - discover travel places in Malaysia, Singapore, Taiwan, Japan.
Pixtory App (Alpha) - easily organize photos on your phone into a blog.
暖心芽 (WIP) 🌞❤️🌱 - reminder of hope, warmth, thoughts and feelings (or just quotes).
LuaPass - offline password manager
By Desmond Lua
A dream boy who enjoys making apps, travelling and gardening. Follow me on @d_luaz.
This work is licensed under a
Creative Commons Attribution-NonCommercial 4.0 International License.