Google Cloud Storage to Google Sheets Transfer Operators

Google has a service Google Cloud Storage. This service is used to store large data from various applications.

With Google Sheets, everyone can work together in the same spreadsheet at the same time. Use formulas functions, and formatting options to save time and simplify common spreadsheet tasks.

Prerequisite Tasks

Upload data from GCS to Google Sheets

To upload data from Google Cloud Storage to Google Spreadsheet you can use the GCSToGoogleSheetsOperator.

airflow/providers/google/suite/example_dags/example_gcs_to_sheets.pyView Source

upload_gcs_to_sheet = GCSToGoogleSheetsOperator(
    task_id="upload_gcs_to_sheet",
    bucket_name=BUCKET,
    object_name="{{ task_instance.xcom_pull('upload_sheet_to_gcs')[0] }}",
    spreadsheet_id=NEW_SPREADSHEET_ID,
)

You can use Jinja templating with spreadsheet_id, bucket_name, object_name, spreadsheet_range, impersonation_chain.

Was this entry helpful?