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

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.

API

Accepted answers

Caleb

@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

All comments

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/11834

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?

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335