How I am able to read data from google drive / box using alteryx?

[DataPsycho]

Hi,

I am trying to find a solution to read data directly form Google Drive/ Box. For example I have excel file stored in that location click here and I want to read it by alreryx directly because later on I am going to automate the workflow in the Server from local with some schedule. Though my company use Box as cloud service. So I have to configure every thing for Box.

[Treyson]

Ah @DataPsycho! I am jealous of that name!

I know that if you had this file on Google Sheets, there are connectors for that.

Here is the link for the specifics and the download links are at the bottom.

https://help.alteryx.com/10.5/DataSources/GoogleSheets.htm

Here is also a great post by @JordanB about how to go about setting all of that up.

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/The-How-to-Guide-to-Google-Sheets/ta-p/20354

[DataPsycho]

But I think its about reading data form google sheets. But is it work same for Excel, csv or txt also?

[Treyson]

So I am playing around with the Google Sheets API right now and I was looking at the documentation. Those last two look like the scope you may need to set that up. Here is @TaraM's documentation on the Google Sheets API Credentials setup.

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/How-to-Create-Google-API-Credentials/ta-p/11...

Google Sheets API, v4

Scopes

https://www.googleapis.com/auth/drive	View and manage the files in your Google Drive
https://www.googleapis.com/auth/drive.file	View and manage Google Drive files and folders that you have opened or created with this app
https://www.googleapis.com/auth/drive.readonly	View the files in your Google Drive
https://www.googleapis.com/auth/spreadsheets	View and manage your spreadsheets in Google Drive
https://www.googleapis.com/auth/spreadsheets.readonly	View your Google Spreadsheets

[DataPsycho]

Hi @Treyson,

Thank you for all the resources. I will read those and try to find the solution I need and will share my findings.

Thanks Again.

[Caleb]

Hey @DataPsycho,

I just went through this stuff last week, let me know if you want to connect or need any help figuring it out!

Thanks,

Caleb

[DataPsycho]

Hi, I was busy doing other stuffs so I could not read those document so much. But so far I saw it about reading from google sheet. Will it be the same If I want to read excel?

[Caleb · Accepted solution]

@DataPsycho

From what I can tell, the spreadsheet needs to be a Google Sheet in order for you to use the API to view it. I didn't see .xlsx files that I'd dropped in my drive show up until I opened them in Sheets first. When you open them with Sheets it creates a duplicate sheets version.

I hope that helps!

Caleb

[DataPsycho]

@Caleb,

Hi, I also observed it. So I think there is no direct way to read the data from csv or xlsx. Thank you for your time. Even I have to configure it for Box cloud storage. So I will continue testing the whole process for Box If I can do something. If it does not work then it should be improved in alteryx, in upcoming version. I often read data from Box using R package called boxr or SDK Box in python which works really well.

[melissa_m]

Hi All,

Do you know if this has been addressed.  I was able to setup connectivity if it's saved as a Google Sheet.  However, I am unable to see the file if it was uploaded as an Excel File.  Appreciate any input.

Thanks!