1. Create a new Pipeline
Click on PIPELINES option in the left navigation bar and click on Create New Pipeline.
2. Select Source Type
Select Drive from the list on Select Source Type Screen.
3. Authorize Hevo access to Google Drive
Click on AUTHORIZE in Connection Settings. It will take you to google sign in page.
Sign in to your Google account. On next page, Hevo will ask for your permission to access Drive files, Click on Allow. Clicking on Allow will take you back to Hevo Dashboard.
4. Provide Source name and data folders to replicate
Source name: Provide a unique for the Source
Folder ID(s): Provide folder ids in 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.
Hevo will pick all excel files in the specified folder and load them into a table in the destination. Please ensure that all excel files in a folder are following the same schema.
5. Select the Destination
Select the Destination where you want to replicate Drive Data or Click on NEW DESTINATION to create a new Destination. Check out How to add Destination tutorial for the detailed walkthrough on steps needed for adding new Destination.
6. Pipeline Created
Your Pipeline will be created when you enter this page and you will have an option to see Sample Data and Map Schema.
While Hevo tries to load schemas from your Drive files, you can select CONTINUE IN BACKGROUND if it is taking too much time. Click on CREATE SCHEMA MAPPING to map Source and Destination Schemas, check out Introduction to Schema Mapper to learn about Schema Mapper or you can select DO IT LATER to directly head to Pipeline page. You can map schemas later on Schema Mapper page in your pipeline.
Please note that your data will not start replicating in Destination tables until you map source and Destination schemas.