Google¶
Required Extra
To use the Google connectors, you will need to install parsons with the google extra.
To do this, you will need to install it with pip install parsons[google] or pip install parsons[all].
For more information, see our Installation notes.
Overview¶
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
- BigQuery
- Overview
- Quickstart
- API
GoogleBigQueryGoogleBigQuery.clientGoogleBigQuery.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
- Cloud Storage
- Overview
- Quickstart
- API
GoogleCloudStorageGoogleCloudStorage.clientGoogleCloudStorage.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
- Google Drive
- Google Sheets
- Overview
- Quickstart
- API
GoogleSheetsGoogleSheets.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()