Integration with Google Drive?

[DanielCS]

We have a hubspot form from where we collect documents from clients. This documents are then attatched to their records on HubSpot.

We need to upload this documents to Google Drive at a folder with the same name as the record. 

I have looked at a solution with Zapier and Integromat/Make, but haven't been able to figure out the optimal way to do this. 

First, because when the files are attatched to a record they become private (correct me if I'm wrong), there is no way to detect them on the contact record with Zapier or Make, so I have to catch the file when is submitted with the form.

With Zapier I have the option to get the public URL of the file, but had troubles creating the Google Drive folder (which might be easy to solve, just bad mapping on my end)  

With Make, I couldn't figure out how to get the public URL, but was able to create the folder on Google Drive with the name submited on the form.  

Thing is that whatever I end up using, the folder won't have the same name as the contact record, because the clients will end up not typing their name on the form exactly as we have it on the hubspot record. We have a lot of clients with similar names, that's why we need it exactly as the record.  Also this solutions might work when client uploads just 1 file, but when multiple files are uploaded at the same time not sure if the Zapier/Make flows would handle all of those or just 1 file. 

Appreciate any idea or suggestion that might help me solve this, uploading the file after it was attatched to the record would be ideal because then I could map that record name to the drive folder name. 


Thanks.

[SteveHTM]

@DanielCS - do you have Ops hub access to custom code workflow steps?

Steve

[DanielCS]

Yes I have access

[SteveHTM]

So, having just wrestled the files API for uploaded files into submission, I think this would provide you with the all the options and features you want. The tricky bit might be engineering the Google authentication methods.

Probably a fair amount of coding work, but you will get the features you need.

Steve

[DanielCS]

Thanks, wasn't aware of the custom code on workflows. 
I'm not a coder, so I ended up asking chatgpt for a code (which most probably than not, is incorrect) but mentions that it can send a webhook to zapier or make with the files to then be uploaded to Google drive... if this is correct, will this take care of the google authentication that you mention? 

[SteveHTM · Accepted solution]

I can't be sure without trying it, but a webhook to a 3rd party app may not get around the naming issues you mentioned in your original post. If it were me, i'd be trying to implement this without going through Zapier etc. but you may have other constriants.

Steve