Spaces:
Build error
Build error
| import json | |
| import os | |
| import gspread | |
| from oauth2client.service_account import ServiceAccountCredentials | |
| # Define the scope and authenticate with the service account | |
| scope = [ | |
| "https://spreadsheets.google.com/feeds", | |
| "https://www.googleapis.com/auth/drive", | |
| ] | |
| json_key = json.loads(os.getenv("GKEY"),strict=False) | |
| credentials = ServiceAccountCredentials.from_json_keyfile_dict(json_key, scope) | |
| client = gspread.authorize(credentials) | |
| # Open the Google Sheet by name | |
| spreadsheet = client.open("Team 7 Data") | |
| worksheet = spreadsheet.sheet1 # Access the first sheet | |
| # Function to insert the JSON string into the first column | |
| def submit_json_to_sheets(json_data): | |
| # Convert JSON data to string format | |
| json_string = json.dumps(json_data) | |
| # Append the JSON string as a new row with one cell in the first column | |
| worksheet.append_row([json_string]) | |