Google

Google Cloud services allow you to upload and manipulate Tables as spreadsheets (via GoogleSheets) or query them as SQL database tables (via GoogleBigQuery). You can also upload/store/download them as binary objects (via GoogleCloudStorage). Google also offers an API for civic information using GoogleCivic and admin information using the Google Workspace Admin SDK.

For all of these services you will need to enable the APIs for your Google Cloud account and obtain authentication tokens or other credentials to access them from your scripts. If you are the administrator of your Google Cloud account, you can do both of these at Google Cloud Console APIs and Services - Dashboard. The connectors below have more specific information about how to authenticate.

• Google Admin
  • Overview
  • Quickstart
  • API
    • GoogleAdmin
      • GoogleAdmin.get_aliases()
      • GoogleAdmin.get_all_group_members()
      • GoogleAdmin.get_all_groups()
• BigQuery
  • Overview
  • Quickstart
  • API
    • GoogleBigQuery
      • GoogleBigQuery.client
      • GoogleBigQuery.connection()
      • GoogleBigQuery.query()
      • GoogleBigQuery.query_with_connection()
      • GoogleBigQuery.get_job()
      • GoogleBigQuery.copy_from_gcs()
      • GoogleBigQuery.copy_large_compressed_file_from_gcs()
      • GoogleBigQuery.copy_s3()
      • GoogleBigQuery.copy_direct()
      • GoogleBigQuery.copy()
      • GoogleBigQuery.duplicate_table()
      • GoogleBigQuery.upsert()
      • GoogleBigQuery.delete_table()
      • GoogleBigQuery.table_exists()
      • GoogleBigQuery.get_tables()
      • GoogleBigQuery.get_views()
      • GoogleBigQuery.get_columns()
      • GoogleBigQuery.get_columns_list()
      • GoogleBigQuery.get_row_count()
      • GoogleBigQuery.extract()
      • GoogleBigQuery.copy_between_projects()
• Civic
  • Overview
  • Quickstart
  • API
    • GoogleCivic
      • GoogleCivic.get_elections()
      • GoogleCivic.get_polling_location()
      • GoogleCivic.get_polling_locations()
      • GoogleCivic.get_representative_info_by_address()
• Cloud Storage
  • Overview
  • Quickstart
  • API
    • GoogleCloudStorage
      • GoogleCloudStorage.client
      • GoogleCloudStorage.list_buckets()
      • GoogleCloudStorage.bucket_exists()
      • GoogleCloudStorage.get_bucket()
      • GoogleCloudStorage.create_bucket()
      • GoogleCloudStorage.delete_bucket()
      • GoogleCloudStorage.list_blobs()
      • GoogleCloudStorage.blob_exists()
      • GoogleCloudStorage.get_blob()
      • GoogleCloudStorage.put_blob()
      • GoogleCloudStorage.download_blob()
      • GoogleCloudStorage.delete_blob()
      • GoogleCloudStorage.upload_table()
      • GoogleCloudStorage.get_url()
      • GoogleCloudStorage.copy_bucket_to_gcs()
      • GoogleCloudStorage.format_uri()
      • GoogleCloudStorage.split_uri()
      • GoogleCloudStorage.unzip_blob()
• Google Docs
  • Overview
  • Quickstart
  • API
    • GoogleDocs
• Google Drive
  • Overview
  • Quickstart
  • API
    • GoogleDrive
      • GoogleDrive.download_file()
      • GoogleDrive.replace_file()
      • GoogleDrive.upsert_file()
      • GoogleDrive.copy_file()
      • GoogleDrive.get_permissions()
      • GoogleDrive.share_object()
      • GoogleDrive.transfer_ownership()
• Google Sheets
  • Overview
  • Quickstart
  • API
    • GoogleSheets
      • GoogleSheets.list_worksheets()
      • GoogleSheets.get_worksheet_index()
      • GoogleSheets.get_worksheet()
      • GoogleSheets.share_spreadsheet()
      • GoogleSheets.get_spreadsheet_permissions()
      • GoogleSheets.create_spreadsheet()
      • GoogleSheets.delete_spreadsheet()
      • GoogleSheets.add_sheet()
      • GoogleSheets.append_to_sheet()
      • GoogleSheets.paste_data_in_sheet()
      • GoogleSheets.overwrite_sheet()
      • GoogleSheets.format_cells()