Google Drive

Connection Settings

Source name: Provide a unique name for the Source. Folder ID(s): Provide folder ids in a comma-separated format. To get folder id of your drive folder, open that folder in the browser and copy content after /folder/ from the URL. For eg. If folder URL is https://drive.google.com/drive/u/0/folders/0B1slnwOds09BRjdlMnhERHhxMEU, folder ID will be 0B1slnwOds09BRjdlMnhERHhxMEU.

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.