# Data import from Google Drive is not working

**URL:** <https://community.cratedb.com/t/data-import-from-google-drive-is-not-working/1424>\
**Category:** CrateDB Cloud\
**Created:** [March 21, 2023, 2:25pm UTC](https://community.cratedb.com/t/data-import-from-google-drive-is-not-working/1424 "2023-03-21T14:25:52Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![roman](https://sea2.discourse-cdn.com/flex020/user_avatar/community.cratedb.com/roman/32/36_2.png) [@roman](https://community.cratedb.com/u/roman)\
**Post date:** [March 21, 2023, 2:25pm UTC](https://community.cratedb.com/t/data-import-from-google-drive-is-not-working/1424/1 "2023-03-21T14:25:52Z")

</div>

Hello,  
I try to import a CSV file from my Google Drive to a CrateDB Cloud cluster. I set the sharing options of the file to “anyone with the link can edit”. Still it doesn’t import the data into the cluster. I see a strange error message that I can make no sense off ☹

 ![image](https://us1.discourse-cdn.com/flex020/uploads/crate/original/1X/7a71eb07a93d41d710adc04b9b91ab734a5c5ec5.png)

Any advice would be appreciated!

---

<div class="post-metadata">

**Author:** ![Matej](https://sea2.discourse-cdn.com/flex020/user_avatar/community.cratedb.com/matej/32/607_2.png) [@Matej](https://community.cratedb.com/u/Matej)\
**Post date:** [March 23, 2023, 2:30pm UTC](https://community.cratedb.com/t/data-import-from-google-drive-is-not-working/1424/2 "2023-03-23T14:30:50Z")

</div>

Hello there,

Unfortunately, the usual way of sharing documents from Google Drive is not enough as it doesn’t make the documents public, and therefore your cluster cannot access them. See their documentation [here](https://support.google.com/docs/answer/183965?hl=en&co=GENIE.Platform%3DDesktop&oco=0) for details.

**Follow these steps to import from Google Drive:**

1. Open the document you want to import.
2. Navigate to File → Share → Publish to web
3. In the modal, choose the “Link” tab
4. Choose either the entire document or the specific sheet you want to import.
5. Choose `.csv` as the format
6. Click Publish.
7. Copy the public link to the document and use this as the import URL in the Cloud Console

 ![image](https://us1.discourse-cdn.com/flex020/uploads/crate/original/1X/9d937fa544268754457259c67f8dff542b4d2f16.jpeg)

 ![image](https://us1.discourse-cdn.com/flex020/uploads/crate/original/1X/13fe7bab9c02a2f30b12c773ef2a76ee4cfa6b91.jpeg)

 ![image](https://us1.discourse-cdn.com/flex020/uploads/crate/original/1X/988037486456b5330537a1ce815ab18615e94e28.jpeg)

Hope this helps!