Simple hooks and operators for transporting data from Smartsheet.
Import Smartsheet into PostgreSQL or export as CSV, PDF or EXCEL file.
SmartsheetToFileOperator
: exporting a Smartsheet sheet to a file/jsonSmartsheetToPostgresOperator
: exporting a Smartsheet sheet to a PostgreSQL table
Using pip:
pip3 install airflow-smartsheet-plugin
Create a variable in Airflow named SMARTSHEET_ACCESS_TOKEN
to store your Smartsheet API access token.
You can also pass in an override token in your DAG definition.
This plugin is published as a pip package. Refer to the example DAG for available parameters.
Refer to the enums for available PDF paper sizes.