About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

How do I access files from a shared Google Drive link which is not in my Drive?

Mhamed Samy
Userlevel 1
Badge +1

I want to access on G.Drive link that is NOT in my drive, to extract files from the drive link, How i do it

icon

Best answer by Troy Tessalone 5 May 2024, 17:25

View original

18 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @Mhamed Samy 

The GDrive account that has the files you want to use must be connected to Zapier here: https://zapier.com/app/connections

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Mhamed Samy
Userlevel 1
Badge +1

Hi @Troy Tessalone 

Thank you for your response,
This means that I could not access a drive link that was NOT in my drive, even using a specific script as python.

ken.a
Userlevel 7
Badge +6

Yes that’s correct @Mhamed Samy. Google Drive requires that you are the owner of the files and folders:

https://help.zapier.com/hc/en-us/articles/8495965163405-How-to-Get-Started-with-Google-Drive#about-the-google-drive-integration-0-0

e21d23935872a4d2dd8fbf1c9e8c0a87.png
(view larger)

Hopefully, this helps!

Mhamed Samy
Userlevel 1
Badge +1

@ken.a @Troy Tessalone 

I receive a drive link from Asana NOT in my drive,
This link contains some files and I have permission to access the link
How do I access this link and obtain certain data from these files and store them in a file in Google Sheet
Is there a way to do that?

Or a way to download the files in the Drive link to my Drive through Zapier


I am waiting for you and thank you for your cooperation with us.

Mohamed Samy

ken.a
Userlevel 7
Badge +6

Hi @Mhamed Samy,

As long as the Google Drive link from Asana is a direct download link and it’s publicly accessible, you can download the Google Drive link to your Google Drive account using Zapier.

You can learn more about sending files via Zap here: https://help.zapier.com/hc/en-us/articles/8496288813453-Send-files-in-Zaps

Hopefully, this helps.

Mhamed Samy
Userlevel 1
Badge +1

Hi @ken.a @Troy Tessalone 

Thank you a lot for the help,

I was trying to convert a drive link into a downloadable link. I will attach pictures in the comments
Is there a way to do that?

And How do I download the link to my drive?

2 Attachments
Troy Tessalone
Userlevel 7
Badge +14

@Mhamed Samy 

You need to isolate the ID from the URL and remove the query string parameters. (? and after)

 

Tool: https://sites.google.com/site/gdocs2direct/

 

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Mhamed Samy
Userlevel 1
Badge +1

@Troy Tessalone 

Thank you very much for the help,

but How can I delete them from Zapier?

Troy Tessalone
Userlevel 7
Badge +14

@Mhamed Samy 

For the Zap action GDrive Delete File, you need to provide the File ID.

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Mhamed Samy
Userlevel 1
Badge +1

@Troy Tessalone 

I do that but my file has been deleted, i don’t understand you.

I know that you made an effort to solve my problem, but I could not understand you
I'll explain what I want to do,
I took the drive link from Asana and I want to access this link in order to extract specific data from files inside the drive Folder.
Then I want to extract this data from the files and put it in Google Sheet
Is that all I want to do?
Is it possible to achieve it automatically?

1 Attachment
Troy Tessalone
Userlevel 7
Badge +14

@Mhamed Samy 

You will need to parse the GDrive File ID from the GDrive File Link.

 

Depending on the file type/format, you can use the File by Zapier to extract data from the file itself.

https://zapier.com/apps/files-by-zapier/integrations#triggers-and-actions

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Mhamed Samy
Userlevel 1
Badge +1

@Troy Tessalone 

Regarding the first point that I do not understand yet, it can be clarified further
As for the second point, I did what was mentioned, but the data appears strange. I did research and learned that it is possible to use a Bitskout program, but I could not link it to Zapier.

1 Attachment
Troy Tessalone
Userlevel 7
Badge +14

@Mhamed Samy 

We would need to see screenshots with how your Zap steps are configured in EDIT mode for the ‘Action’ section to have context.

 

If you are still having trouble, you may want to consider hiring help, there’s a directory of Certified Zapier Experts: https://zapier.com/experts

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Mhamed Samy
Userlevel 1
Badge +1

@Troy Tessalone @ken.a @SamB @ZapierExplorer @christina.d @nicksimard @JammerS 

The first step is to create a database in Google Sheet in order to receive data into it,
The second step is to log in to Task in Asana in order to extract the drive link from it,
/ The drive link contains files. I wanted to extract specific data from each file in the drive link /
/ I knew that it was necessary to make the drive link downloadable in order to put it in my drive, but I did not know how? /
In the third step, I extracted the link from which I will extract the data
This is what I have done so far
I just want to know what I need to do in Zapier to get going :
1 - Make the file downloadable
2 - How do I put the file in my drive?
3- How do I extract data from files?

3 Attachments
ken.a
Userlevel 7
Badge +6

Hi @Mhamed Samy,

Thanks for clarifying!

Would you mind sharing the Google Drive link here? We might need to tweak your Formatter setup depending on how the Google Drive link is constructed.

I'll be keeping an eye out for your response!

Mhamed Samy
Userlevel 1
Badge +1

Hi @Troy Tessalone 

Thank you very much for your response
Of course, I will share the drive link

https://drive.google.com/drive/folders/18nBWxWDlhm2Z1oWBMNS-EhyIPhXf3DPL?usp=drive_link

The drive link contains two files less than 100mg and there is permission for anyone to access them
Through Zapier,

I want to access the files contained within the link and extract specific data within the files in order to place them in Google Sheet.


I hope you can help me with this. I hope to find a solution to address this problem
I'll be watching your comment on this
Thank you very much

ken.a
Userlevel 7
Badge +6

Hi @Mhamed Samy,

It looks like the Google Drive link is a folder link. Unfortunately, I don’t have experience converting that to a direct download URL.

I’d recommend consulting with one of our certified Zapier Experts regarding your workflow they can help you streamline your workflow.

You can reach our certified Zapier Experts here: https://zapier.com/experts

Hopefully, this helps.

Mhamed Samy
Userlevel 1
Badge +1

Thank you very much for help me,

i’ll contact with them but i have another ask I think you have a background about this 

I have extracted data from a Google Drive file with the .docx extension using webhook - Get
But I cannot extract data from the PDF file,
I converted the drive file link to an extension that contains PDF by python, but the link does not work in the webhook,

I have attached pictures for clarification


What can I do to extract specific data from a file in Google Drive?

2 Attachments

Reply


Terms & Conditions