Google Drive Excel To Airtable Data Loader by COZYROC

This gem automates the ingestion of Excel sheet data from Google Drive into a designated Airtable table. By removing 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 migration from cloud-based sources into Airtable.

Setup Guide

This gem will establish a connection between Google Drive and Airtable. It will then pull the data from Google Drive Excel File specified in the parameter Excel File and transfer it to the target Airtable destination table.

To run this gem and connect Google Drive to Airtable, configure the parameters that are mentioned below.

Google Drive

• Token File Required. Select the Google Drive token file from the drop-down list. Review the documentation article here on how to generate the token file.
• Source Folder Required. Specify the source folder path ending with the trailing slash, for example: Dev/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.