Azure Blob Storage Excel To Airtable Data Loader by COZYROC

This gem automates the ingestion of Excel worksheet data from a designated Azure Blob Storage container into a specified Airtable base and table. By eliminating manual steps, it streamlines the data pipeline and ensures accurate, consistent, and timely updates. Designed for scalability and reliability, this solution enables seamless, hands-free data integration between cloud-based storage and Airtable.

Setup Guide

This gem establishes a connection between Azure Blob Storage and Airtable. It retrieves data from the specified worksheet within the Excel file stored in the desired container (as defined in the Excel File parameter), and then performs an ingestion into the target Airtable table.

To run this gem and connect desired Azure Blob Storage container to Airtable, configure the parameters that are mentioned below.

Azure Blob Storage

• Server Host Required. Specify the storage account name in the server host URL.
• Storage Account Required. Specify the storage account name.
• Shared Key Required. Specify the shared key.
• Source Folder Required. Specify the path to the source folder ending with a trailing slash, for example: container001/Files/Excel/.
• Excel File Required. Specify the source excel file name for example: Automobile.xlsx.
• Worksheet Required. Specify the worksheet name.
• Filter Column Optional. Specify a regular expression to exclude unwanted columns from the Excel file.

Airtable

• Server Host Required. Specify the correct [base id] in the server host URL.
• Token File Required. Select the airtable token file from the drop-down list. Review the documentation article here on how to generate the token file.
• Table Required. Specify the target Airtable table name.

Mapping

• Mapping Optional. Use this parameter when source and destination columns differ. Specify mappings in a key-value format, with each pair on a new line, e.g., SourceColumn1=DestinationColumn1.