Google Drive Excel To Dataverse Data Loader by COZYROC

This gem automates the ingestion of Excel sheet data from Google Drive into a designated Microsoft Dataverse object. 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 spreadsheets into Dataverse for use across Microsoft Power Platform apps and services.

Setup Guide

This gem establishes a connection between Google Drive and Microsoft Dataverse. It pulls data from the Excel file specified in the Excel File parameter and transfers it to the designated Dataverse object (table). This enables seamless integration of cloud-based spreadsheet data into your Dataverse environment.

To run this gem and connect Google Drive to Microsoft Dataverse, 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.

Dataverse

• Server Host Required. Specify the correct instance in the server host URL.
• Token File Required. Select the Rest Token file from the drop-down list. Review the documentation article here on how to generate the token file.
• Object Required. Specify the target dataverse object (table) name.
• Ignore Null Value Optional. Specify to ignore null values and not send for processing.
• Alternate Key Optional. Specify alternate key identifier column.

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.