Airtable - Download Table or View to Workflows

Overview

Quickly export data from a single table on an Airtable base to a CSV. Only one table or view of data can be downloaded at a time, since CSVs are flat files. Content of the downloaded file can be further refined by providing a view. Otherwise, the entire contents of the table will be downloaded.

Variables

Name	Reference	Type	Required	Default	Options	Description
Base ID	AIRTABLE_BASE_ID	Alphanumeric	✅	None	-	The ID of your Airtable base. Found in the URL of your base and starts with `app`
Table Name or ID	AIRTABLE_TABLE_NAME	Alphanumeric	✅	None	-	Can be the Name (case sensitive) or the ID of the table. The ID can be found in the URL and always starts with `tbl`.
View Name or ID	AIRTABLE_VIEW_NAME	Alphanumeric	➖	None	-	Can be the Name (case sensitive) or the ID of the view. The ID can be found in the URL and always starts with `viw`.
Include Record IDs?	AIRTABLE_INCLUDE_RECORD_ID	Boolean	✅	True	-	If checked, an additional column named `airtable_record_ids` will be created in the CSV containing each row's unique Airtable Record ID. This is recommended if data ever needs to be reloaded back into Airtable in the future.
Personal Access Token	AIRTABLE_API_KEY	Password	✅	None	-	Personal Access Token associated with a user that has access to the specified Base, Table, and View listed.
Workflows File Name	AIRTABLE_DESTINATION_FILE_NAME	Alphanumeric	✅	None	-	Name of file to be generated with the results. Should be `.csv` extension.
Workflows Folder Name	AIRTABLE_DESTINATION_FOLDER_NAME	Alphanumeric	➖	None	-	Folder where the file should be downloaded. Leaving blank will place the file in the home directory.

YAML

Below is the YAML template

YAML


source:
  template: Airtable - Download Table or View to Workflows
  inputs:
    AIRTABLE_BASE_ID:
    AIRTABLE_TABLE_NAME:
    AIRTABLE_VIEW_NAME:
    AIRTABLE_INCLUDE_RECORD_ID: true
    AIRTABLE_API_KEY:
    AIRTABLE_DESTINATION_FILE_NAME:
    AIRTABLE_DESTINATION_FOLDER_NAME:
  type: TEMPLATE
guardrails:
  retry_count: 1
  retry_wait: 0h0m0s
  runtime_cutoff: 1h0m0s
  exclude_exit_code_ranges:
    - 100
    - 101
    - 102
    - 103
    - 104
    - 205
    - 206