Google Drive

Connection Settings

  • Source name - Provide a unique name for the Source.
  • Select the folders which contain the files whose data is to be replicated. Hevo ingests data from all supported files present in the chosen folders.

How are Event Types generated

Excel files or Google Sheets

For Excel files or Google Sheets, the event types are generated on the basis of Sheet names. So, if you have multiple files in the folder, the rows from all the files with the same sheet name will be ingested as one event type and hence can be replicated to one table in the destination.

The event names for these files will be in foldername_sheetname format. Here, the folder name is the Drive’s Folder Name.

CSV files

All the CSV files in the folder will be ingested as the same event type. The event names for these files will be the Drive folder name.

Limitations

  • Hevo only supports ingesting Excel, Google Sheets and CSV files from Drive.
  • The name of Drive folders should not be modified once the Pipelines are built. If the names are modified, the new events will be ingested with a different name according to the new folder name.
Last updated on 03 Jul 2020