Skip to main content
Skip table of contents

Airtable - Upload File from Workflows to Airtable

Overview

Easily transfer data from a CSV file to Airtable using batch operations. Choose to either append new records, update existing ones, or completely replace the table's contents. When updating, you can identify records by their ID or match them based on specific fields (key_fields). Be cautious with the replace option, as it will remove all existing records in the table before adding the new data from the CSV file.

Variables

NameReferenceTypeRequiredDefaultOptionsDescription
Personal Access TokenAIRTABLE_API_KEYPassword--Personal Access Token associated with a user that has access to the specified Base, Table, and View listed.
BaseAIRTABLE_BASE_IDAlphanumeric--The ID of your Airtable base. Found in the URL of your base and starts with `app`
Table IDAIRTABLE_TABLE_IDAlphanumeric--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`.
Key FieldsAIRTABLE_KEY_FIELDSAlphanumeric--List of field names separated by commas that Airtable should use to match records in the input with existing records on the server.
TypecastAIRTABLE_TYPECASTBooleanFALSE-If enabled, the Airtable API will perform best-effort automatic data conversion from string values.
Workflows Folder NameAIRTABLE_SOURCE_FOLDER_NAMEAlphanumeric--Name of the local folder on Workflows to upload the target file from. If left blank, will look in the home directory.
Source Filename or PatternAIRTABLE_FILENAME_OR_PATTERNAlphanumeric--The name of the file to upload or search criteria
Match TypeAIRTABLE_MATCH_TYPESelectexact_matchExact: exact_match

Regex: regex_match

Glob: glob_match
Determines if the text in "Filename or Pattern" will look for one file with exact match, or multiple files using regex or glob.
Insert MethodAIRTABLE_INSERT_METHODSelect-Upsert: upsert

Replace: replace

Append: append
Upsert: Inserts or updates records as needed. Replace: Replaces table content with CSV data, removing old data. Append: Adds new records, ignoring potential duplicates.

YAML

Below is the YAML template

YAML

source:
  template: Airtable - Upload File from Workflows to Airtable
  inputs:
    AIRTABLE_API_KEY:
    AIRTABLE_BASE_ID:
    AIRTABLE_TABLE_ID:
    AIRTABLE_KEY_FIELDS:
    AIRTABLE_TYPECAST: 'FALSE'
    AIRTABLE_SOURCE_FOLDER_NAME:
    AIRTABLE_FILENAME_OR_PATTERN:
    AIRTABLE_MATCH_TYPE: exact_match
    AIRTABLE_INSERT_METHOD:
  type: TEMPLATE
guardrails:
  retry_count: 1
  retry_wait: 0h0m0s
  runtime_cutoff: 1h0m0s
  exclude_exit_code_ranges:
    - 100
    - 101
    - 102
    - 103
    - 104
    - 205
    - 206

      
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.