Import data from Google Drive
Zoho DataPrep supports importing data from Google Drive a file storage and synchronization service developed by Google. Google Drive allows users to store files in the cloud, synchronize files across devices, and share files.
To import data from Google Drive
Note: If you had already added a Google Drive connection earlier, click the Saved connections category from the left pane and proceed to import. To learn more about Saved connections, click here.
Note: Click the Add new link to add a new Google Drive account. You can create as many Google Drive connections as required.
3. Authenticate your Google account. You will need to authorize DataPrep to access your files when you do this for the first time.
4. Select the files you want to import and click the Import button. You can also select files from the Shared with me tab.
5. If it is an HTML, XLS, or XLSX file, you can click the Preview option to view a sample of the data.
6. If the file is password protected, enter the password, and click the right arrow.
7. Click Import button.
8. Once you have completed importing data, your dataset will open and you can start preparing your data right away.
Note: You can choose to schedule the import using the Schedule import option available for datasets in your workspace or from the Import menu in the top bar of the DataPrep Studio page. Click here to know more.
SEE ALSO
How to import data from cloud databases?
How to import data from saved data connections?
What are the other cloud storage options available in Zoho DataPrep?
How to export data to Google Drive?
Access your files securely from anywhere
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
Create. Review. Publish.
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
Zoho Sheet Resources
Zoho Forms Resources
Zoho Sign Resources
Sign, Paperless!
Zoho TeamInbox Resources
Design. Discuss. Deliver.
Related Articles
Import data from cloud storage services
DataPrep supports import from the following cloud storage services. Google Drive One Drive Box Storage Dropbox Zoho WorkDrive Amazon S3 To import data from a cloud storage service 1. Choose the Cloud storage category from the left pane and click the ...Import incremental data from Google Drive
Incremental data fetch is a method used to import new files from a source after the previous sync. Zoho DataPrep helps you import incremental data from Google Drive using the advanced selection feature. To import incremental data 1. Choose the Cloud ...Import data from Google Cloud SQL MySQL
Zoho DataPrep allows you to import data from Google Cloud SQL, a cloud database. It is a fully-managed database service that helps you set up, maintain, manage, and administer your relational databases on Google Cloud Platform. To import data from ...Export data to Google Drive
Zoho DataPrep supports exporting data to Google Drive, a file storage and synchronization service developed by Google. Google Drive allows users to store files in the cloud, synchronize files across devices, and share files. To export data to Google ...Import data from Dropbox
Zoho DataPrep supports importing data from Dropbox, a file hosting service. Dropbox offers cloud storage, file synchronization, personal cloud, and client software. To import data from Dropbox 1. Choose the Cloud storage category from the left pane ...