Send content automatically via a Google Sheet and an Apps Script
Vložit
- čas přidán 4. 12. 2019
- Thanks to the abundance of platforms that presently exist for creating content, so many people are able to create online white papers, ebooks, informational videos, or a tips and tricks blog, around different topics. In this episode, see why it can be handy to use a Google Form to help requestors receive these assets automatically by email using a Sheet’s Apps Script.
Previous episode → goo.gle/387e5nC
Best practices for bulk emailing → goo.gle/2DLy7tj
Google Groups how-to (as a mailing list) → goo.gle/3065Jtc
New Google Sites how-to (free websites with controlled access as a Google Doc) → goo.gle/3j2NxcG
Link to article with code in Google Spreadsheet → goo.gle/2B39nvw
Customizing G Suite playlist → goo.gle/2Rp30br
Sheets to Apps playlist → goo.gle/SheetstoApps
Subscribe to G Suite → goo.gle/GSuite
Product: Cloud, G Suite, Google App Maker, G Suite developer; fullname: AGV;
#SheetsToApps
#CustomizingGoogleWorkspace - Věda a technologie
Forms and AppScript is a godsend
Great intro; cheers
Thank you for these tutorials, some of the links are very slow to be discovered, why?
present smily presentation thankyou
I am loving the different kinds of ethnic gets up you got going on in these videos. This video gets a Like from me!
Thanks.
This was great info, but when viewing on phone the code hardly viewable. If you make the person smaller and the context larger. It would be stupendous!
great. how can we share the script (the one that handles info in a sheet) so it can be run by other shared users? not quite working for me.
The introduction is great, everything is great, best video I watch on CZcams till now.
Thanks for this great video.
In the functionOnFormSubmit, the e is not identified.
The line var responses = e.namedValues; i get the message: Cannot read property '0' of undefined
at onFormSubmit.
Any solution?
Thanks.
Hello, I have a Google form integrated with Google sheet and from that database on event action basis the data data is triggered via pabbly connect. My concern is I don't want duplicate mobile number entry so that double data is triggered.
Apps Script is Gold. When es6?
Which social media is the one that has an M?
Is appsheet app/web safe....?
👌
It is not sending the emails for me... any advice?
ok
where is google appscript code link
🙌 Fixed (apologies if it had the wrong one)
Can I do this with whatsapp?
Appsscript fails sometimes due to Sheet or other service unavailability, what's the solution for this?
what do you mean by unavailable? is the entire service down or has a daily quota been reached.
@@trappedcat3615 Entire service down, Shreadsheet service not available kind of errros