Describe

This project uses the Google Sheets API to access, read, write, and manage data in Google Sheets from a Python application. The goal is to automate tasks such as entering data, creating reports, or updating information directly in Google Sheets.

Library

from google.oauth2.credentials import Credentials
import os
import gspread
from googleapiclient.discovery import MediaFileUpload
from googleapiclient.discovery import build
from google.oauth2 import service_account

Main features

• Read data from Google Sheets: Connect and retrieve data from sheets.
• Record data to Google Sheets: Add, update or delete data in sheets.
• Manage Sheets: Create, edit, and delete sheets via API.

Procedure