SQL to Google Sheets Transfer Operators

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 SQL to Google Sheets

To upload data from and Database using SQL to Google Spreadsheet you can use the SQLToGoogleSheetsOperator.

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

upload_gcs_to_sheet = SQLToGoogleSheetsOperator(
    task_id="upload_sql_to_sheet",
    sql=SQL,
    sql_conn_id="database_conn_id",
    spreadsheet_id=NEW_SPREADSHEET_ID,
)

You can use Jinja templating with sql, spreadsheet_id, spreadsheet_range, impersonation_chain.

Was this entry helpful?