hello. Please share your ideas.
I want to collect the user’s email information in a google sheet with a google form, and then send the file from google drive as an attachment in gmail.
The file size is about 13MB, but I am getting an error message in the scenario process because the file size is large.
If there is a way to solve this, I would appreciate it.
However, I don’t want to forward the file as a shared link.
I want to send an email with the file attached.
Please see the progress and error messages below and let us know if you have any ideas.
1 Like
According to the documentation for the files export endpoint (module), the limit is 10MB.
This is a limit set by Google.
Potential workarounds are discussed here:
You have to use the universal “Make an API call” module to perform the workaround that was mentioned in one of the answers linked above.
samliew – request private consultation
Join the Make Fans Discord server to chat with other makers!
2 Likes
My workaround to limits in gmail uploading is to use a public google drive document/folder or whatever you need and sharing the link with the client.
So files over 10MB can only be linkshared?
Can I get some help on how to create the API call you mentioned?
Hi,
There is a possible workaround that works for me.
First of all, for future visitors, the limit is set only for export, e.g., when you change the file format to another.
If you have a file that doesn’t need to be converted, the workaround is not necessary.
Important notice:
- The file must be available to the public.
- I don’t know the limits of this method—it worked for me with a 26MB file.
Here’s how to achieve it:
-
Google Drive- Get a Share Link:
Setup this module to change sharing settings of the file.
It is important to set role to Reader and type to Anyone
-
HTTP Get a File:
Now tricky part. You must setup link in desired format
Config for Sheets:
CSV:
https://docs.google.com/spreadsheets/d/FILE_ID/export?format=csv
XLSX:
https://docs.google.com/spreadsheets/d/FILE_ID/export?format=xlsx
PDF:
https://docs.google.com/spreadsheets/d/FILE_ID/export?format=pdf
Scenario:
Proof:
Hope it helps.
Please check it and let us know if it works for you. If yes- mark thread as solved:
Have a nice day!
Michal
Simplymation
4 Likes
Thanks to your explanation, I was able to solve the problem. Thank you very much.
3 Likes
