I want to click on a button and send an email to non-Gmail email address with google sheet as attachment.
Can this be done?
Do you plan to attach a file or an url to a Google Sheet? If a file, where is it stored? This file must be available in the application.
What I would like to do is to attach one Google sheet to an email to one specific person.
You can use open url action to send email with url scheme:
mailto:[email protected]?subject=Subject&body=Here is the Google Sheet https://docs.google.com/spreadsheets/d/1eTOMb4_kfdQ32QBXYQTJhjEWprv4Jbth8fX7y-r-u_0/edit?usp=sharing
See the example send_mail.pma (5.3 KB)
I tried this example and also used my own data and what happens is that the Subject does not show up in the Subject field but it does show in the body of the text and runs into the link to the sheet.
How do I get that to work?
NOTE: I fixed that, but I get a link that is not a hyperlink. I thought it would come as an attachment?
Can you share the string you are passing?