Skip to main content

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

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


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.


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!


@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


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.


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?


@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 

Thank you very much for the help,

but How can I delete them from Zapier?


@Mhamed Samy 

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

 


@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?


@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 

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.


@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 @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?


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!


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


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.


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?


Hi there @Mhamed Samy 👋

I’m so sorry we missed your message here previously! Were you since able to figure out how to extract the contents of the PDF file? 

Keen to ensure you’re all set here so please do let us know if you need any further assistance on that!