Hi Guys,
I know that we can connect google drive to our Glide to upload files.
But I have a requirement Where I would want every user who signs into my app to be able to connect to their google drive account.
Create files and Upload files (Both Video and Images) into their google drive.
Share the uploaded file links to others
Be able to save the uploaded file link into Glide DB
Mainly to be able to link every app users personal Google drive account and be able to upload files. Is this something that is possible without using make or zapier?
Also wanted to know will Google drive API be possible to be integrated with glide?
Thank you in advance.
Regards,
Dilip
Yes, but not directly in Glide; it’s called a WebApp. However, to create it, you need to master Google App Script and HTML. There are plenty of tutorial sources available online.
If your goal is to upload files to your drive, it’s easier to use Google Forms that can be embedded into your Glide app.
Thank you for the reply Himaldin.
I will check the tutorial out. Though I have worked few things on google app script but they were mostly goole app scripts for Google sheets.
Yes my goal is to upload files to drive. but it is to app users account.
Meaning anyone who install my app must be able to connect my app to their google drive account and be able to upload files.
This would be possible via Glide?
Regards,
Dilip
I don’t understand your purpose. I suggest you use a single storage drive or you will encounter complex issues. Users can simply download it individually.
Google Drive is private. Even if allowed, you will encounter security issues implemented by Google. I doubt your idea.
My purpose is that Individual users will need to upload files into their personal account.
Not a central account like companies account.
I have specific requirement for uploads.
Regards,
Dilip
Let them share the link to your application.
Oh we thought about it.
But we want users to upload and sort content into google drive from the app.
It’s a requirement from app we want to facilitate
Regards,
Dilip
What you need to understand is the workflow, that Glide only has a relationship with just one spreadsheet, which is the spreadsheet used in your application, and not with your Google Drive, let alone the Google Drive of different users with different emails.
If you want to upload to your Google Drive, it is still possible, but it only works on the backend between your spreadsheet and your G. Drive. Again, not with the users’ Google Drive. I don’t know and haven’t discussed whether there are third-party services that allow this.
Of course, you already know that you need to authorize only to upload files to your own drive, what about your users’ drives?
It seems you might have a hidden agenda to circumvent Google Drive’s capacity. However, I think this is wasteful as users upload files to their own drives but have to go through Glide.
As for sorting the contents, this is another issue and I don’t see how it relates to the drive. If you mean sorting files, you can ask users to name their files/folders that can be sorted by date. You don’t need to use a cannon to kill an ant.
2 Likes
As a conclusion, I’ll give you tips that might be useful for you, even though consciously it’s a crazy idea. Assuming that the users are regular users who periodically upload files. Here’s how:
- Ask each of your users to create their own Google Forms. Copy and embed the URL into your application. This way, each user will upload/use their own Google Forms in Glide.
- In your Glide spreadsheet, create a table with an importrange formula with the ID from each user’s spreadsheet to pull their URL data (I’m not sure how you should structure this part).
The complexity will increase significantly depending on the number of your users.
Hi Himaldin,
Looking at your replies looks like having everyone upload to the same account drive would be the best possible solution. I will think on this flow.
So in this flow anyone who wants to upload a file will be able to create folder and be able to upload to that file and we can get link of file uploaded into our database right ?
Would we require make or zapier for this case too?
Regards,
Dilip
Hi,
Just curious to know, Wether Google Drive API can be integrated with glide?
What this allows us to do is authorise every users google drive account then they can upload files into their drive.
Not sure wether Glide allows this API integration, Wanted to know if you or anyone has tried.
Regards,
Dilip
“Google 的云端文件存储服务为用户提供了称为“我的云端硬盘”的个人存储空间，以及用于访问协作共享文件夹（称为共享云端硬盘）的选项。
Google’s cloud file storage service provides users with a personal storage space called My Drive, and the option to access collaborative shared folders called shared drives.”
Shared drive is not like what you assume. It’s still one drive that is shared.
Hi Himaldin,
My Drive
A Drive storage location that a specific user owns. Files stored on My Drive can be shared with other users, but ownership of the content remains specific to an individual user.
I think this is for My drive I mean for users specific account.
I know it works on any apps or web apps. But not sure wether Glide will allow this.
Regards,
Dilip
This is the environment in Google. You can try it yourself…
As far as I know, Glide cannot connect to your Google Drive, especially if the owner is your user. Many people will be bounced back to the OAuth issue.
I suggest you use a shared drive called a shared drive. After you successfully create a web app or you want to use G Form, you can embed it into Glide.
Lemme re think my strategy on this then.
Maybe I just have a single google drive account linked to upload data
Thank you for the help Himaldin.
Regards,
Dilip
You can create more than one drive account, meaning you will have a number of forms (Google or web app) according to the number of accounts, as I mentioned above.
However, you should limit it based on specific user groups using certain forms/drives. Otherwise, your table will be very complex. Each account will use one column for the importrange formula in your spreadsheet. This is not yet how you display it in Glide with many columns.
The upload button in Glide can only upload files to Glide’s cloud. So, the option to upload from Glide is clearly no longer possible.
Hi Himaldin,
For google form integration is there any resource you can point me to?
Regards,
Dilip
Is my assumption correct?
If I use Zapier ill have to still upload to glide table and then using zapier I should upload it to google drive?
Doesn’t really help the cause right?
Regards,
Dilip
You can easily find tutorials on how to create Google Forms on YouTube. When you publish, you’ll find the embed URL section that you can copy to the web embed component.
Zapier does exist, but I haven’t tried zapping for this because I think there are too many parties involved for this matter.
Ok you are saying I use web component which launches google form.
I do upload activities there
Is that right ?
Wondering how I’ll get the uploaded video link to my glide table?
Regards,
Dilip