Super Simple Google Sheets Script needed (combine two)
- or -
Post a project like this557
£22(approx. $27)
- Posted:
- Proposals: 8
- Remote
- #3708112
- Awarded
Experienced Graphics designer |Experienced WordPress Full Stack|SharePoint Expert|Data Entry Team |flyer/business card/Brochure||2DAnimation||Photoshop work|
Islamabad
11+ years of exp. in Graphics Designing, Web Designing and Web Development
Chandigarh
WordPress Expert/Woocommerce Expert/Data Scientist/Python Expert/Auto-CAD/3D/2D Animation/ White Board Animation
Rawalpindi
Designer and Developer|WordPress|Shopify|PSD|PHP HTML, JavaScript|WIX| PowerPoint/Keynote| Logo Designing
Berlin
Experienced Full Stack Web and App Developer |Android and IOS App Development| Project Management
London
Logo & Graphic Designer / illustration / PowerPoint / CAD / AI Expert / Web Designer
Rawalpindi
23598251078875260137731510053811478489978466081737958672
Description
Experience Level: Entry
Action
Please make sure you have script writing experience using google scripts.
you must be able to complete the work within 24 hours
I have a google sheet and a template for a mail merge in a google sheet.
I’d like the script to do the following:
As data is added from a form, it will email an ‘approver’ who will approve the content
If they approve, then the data from the page is merged to a google slide template.
In the example sheet here
ABCD are entered by the form
D is the email address who will be sent a notification
E is the yes/ no field - if a ‘YES” - then it will merge the data to the shet.
F is the unique link for the slide created
The slides will use this template
Scripts to use:
Mail merge: https://spreadsheet.dev/mail-merge-from-google-sheets-to-google-slides
Notify email user https://blog.gsmart.in/google-sheets-send-email-based-on-date/
Both of these combined, with a few tweaks, would create the work.
Please make sure you have script writing experience using google scripts.
you must be able to complete the work within 24 hours
I have a google sheet and a template for a mail merge in a google sheet.
I’d like the script to do the following:
As data is added from a form, it will email an ‘approver’ who will approve the content
If they approve, then the data from the page is merged to a google slide template.
In the example sheet here
ABCD are entered by the form
D is the email address who will be sent a notification
E is the yes/ no field - if a ‘YES” - then it will merge the data to the shet.
F is the unique link for the slide created
The slides will use this template
Scripts to use:
Mail merge: https://spreadsheet.dev/mail-merge-from-google-sheets-to-google-slides
Notify email user https://blog.gsmart.in/google-sheets-send-email-based-on-date/
Both of these combined, with a few tweaks, would create the work.
James S.
98% (49)Projects Completed
44
Freelancers worked with
39
Projects awarded
55%
Last project
26 Oct 2023
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies