Using the module - Python Connector for Google Sheets

Using the module

To retrieve data from Google Sheets:

1. Import the module.

   import devart.googlesheets as googlesheets

2. Connect to a database using the connect() module method and obtain a connection object.

   response = googlesheets.signin()
   my_spreadsheet = googlesheets.getspreadsheet("RefreshToken=" + response["Refresh Token"])
   my_connection = googlesheets.connect(
       SpreadsheetId=my_spreadsheet["Spreadsheet Id"]
       RefreshToken=response["Refresh Token"]
   )

3. Create a cursor object using the cursor() connection method.

   my_cursor = my_connection.cursor()

4. Execute the SQL statement using the execute() cursor method.

   my_cursor.execute("SELECT * FROM Company")

5. Retrieve the result set using one of the fetch*() cursor methods.

   for row in my_cursor.fetchall(): 
       print(row)