Integrating Zoho Creator with Google Drive

Integrating Zoho Creator with Google Drive

I am interested in using Google Drive as a convenient repository to push files from file upload fields in my creator app.

I am wondering if people have come up with best practices for this or even how viable it is.


By their API they seem to require including the content length to be the number of bytes of the file but we don't have access to the file size of files in the upload field.  And opposed to the workdrive integration it can only handle 5MB unless we use the https://developers.google.com/drive/api/guides/manage-uploads#resumable one however this burns an extra External Call which are a precious commodity and it still seemingly wants the content-length  which we don't have access to. 

The Drive API also doesn't seem to have any way to create folders through HTTP requests?

I considered node.js functions but if I'm reading this right https://help.zoho.com/portal/en/kb/creator/developer-guide/workflows/create-and-manage-functions/articles/create-and-manage-node-js-functions it can only perform requests with 1MB making it beyond useless for transferring data.

Is there any optimal way to do this?