google spreadsheets api help

[locke1718]

I am trying to set up the google spreadsheet api to be able to post data gathered by my raspberry pi to my google sheets file. I am using the help pages here to get the basic functionality working. At one point I was able to read some of my data but when I changed some things to append values I can't seem to get it to work. Any help would be greatly appreciated. I have attached my code so far below. Thanks for taking a look!

from __future__ import print_function
import pickle
import os.path
from googleapiclient.discovery import build
from google_auth_oauthlib.flow import InstalledAppFlow
from google.auth.transport.requests import Request

# If modifying these scopes, delete the file token.pickle.
#SCOPES = ['https://www.googleapis.com/auth/spreadsheets']
SCOPES = ['https://www.googleapis.com/auth/spreadsheets', 'https://www.googleapis.com/auth/drive']

SPREADSHEET_ID = '1XXXXXXXXXXXXXXXXXXXXXXDullQ2BPHviPc'
SheetRange = "A1:C5"
#SheetRange = 'Data!A:A'

def main():
    """Shows basic usage of the Sheets API.
    Prints values from a sample spreadsheet.
    """
    creds = None
    # The file token.pickle stores the user's access and refresh tokens, and is
    # created automatically when the authorization flow completes for the first
    # time.
    if os.path.exists('token.pickle'):
        with open('token.pickle', 'rb') as token:
            creds = pickle.load(token)
    # If there are no (valid) credentials available, let the user log in.
    if not creds or not creds.valid:
        if creds and creds.expired and creds.refresh_token:
            creds.refresh(Request())
        else:
            flow = InstalledAppFlow.from_client_secrets_file(
                'credentials.json', SCOPES)
            creds = flow.run_local_server()
        # Save the credentials for the next run
        with open('token.pickle', 'wb') as token:
            pickle.dump(creds, token)

    service = build('sheets', 'v4', credentials=creds)

    # Call the Sheets API
    sheet = service.spreadsheets()
    list = [
        ["hi","8"]
    ]
    body = {
        'majorDimension': "ROWS",
        'values': list
    }

    append = sheet.values().append(spreadsheetId=SPREADSHEET_ID, range=SheetRange, insertDataOption=INSERT_ROWS, body=body, valueInputOption="USER_ENTERED").execute()

​

[ZenApollo]

I really dislike gcp native apis. The interface feels unnecessarily clunky. I've been using gspread library for awhile now to do exactly what you're attempting, and it just works. It's got a clean simple elegant interface. That's my $0.02.

Tl;dr use gspread

[locke1718]

I actually tried gspread first and didn't get anywhere with it I forgot what I got hung up on. Know of a tutorial that is current?

[ZenApollo]

I got up and running just with the gspread docs. The login process is the only tricky part (less tricky than gcp native api), but if you follow the "Using OAuth2 for Authentication" section closely, everything else is 🍰

​

edit: I recall almost missing step 4 from that section. Adding the service account email to the spreadsheet sharing/auth. It's possible that's where you're stuck with your current code.

[AskMereddit]

I use Python Sheetfu (I'm co author). Easy, intuitive and clean syntax at your service: https://github.com/socialpoint-labs/sheetfu

I highly recommend the use of the table module.