- Introduction
- Spreadsheet framework
- Build A Task Worksheet PART 2
- Build A Task Worksheet PART 1
- Formula for colouring in every second row
- Custom Mailchimp Embeds
- Custom Mailchimp Embeds
- Zapier Integration
- Week Tracking PART 1
- Week Tracking PART 2
- google script (auto emails) PART 1: Getting ready!
- google script (auto emails) PART 2: THE SCRIPT!
- The Dashboard
- 9. Conclusion
What you'll learn
- Use Zapier to push data from Mailchimp to a spreadsheet
- Create a dynamic, automated spreadsheet using advanced formulas including OR, VLOOKUP, HLOOKUP, and Nested IF statements
- Customize Embedded Mailchimp Signup form to track email signups from as many landing pages as you want
- Write and customize a google script that sends automatic emails
- Create a spreadsheet framework and layout that is scalable and easy to modify
Description
BRAND NEW COURSE!
In this Amazing Automation - the first of the series, Danny Blaker - Head of Data Analysis and Marketing at one of Australia's largest enterprise technology firms Icestorm Digital Solutions (www.icestormds.com) - takes you through automating the process of tracking your Email signup KPIs (Key Performance Indicators) Step-by-step.
In this one-off and invaluable course, you'll learn how to:
- create live, dynamic and scallable spreadsheets using advanced techniques and googlesheets functions.
- Write a google script that automatically sends emails based on KPIs being met
- Use Zapier to collect email signups via the mailchimp API and push them to a spreadsheet
You'll learn the very same processes and create the very same tools that Danny uses in large firms, as well as startups.
This is a great opportunity to learn how custom marketing automation works for modern businesses.
Everything you create and learn in this course can be immediately applied to your own businesses or projects.
The course is also filled with helpful advice, hints, tips, tricks, to make your google-sheets workflow faster and more optimized.
If you're an entrepreneur - from running startups to mammoth, scaling corporations - this is a must do course for you, by an expert in the field!
Other Courses
Online Business Academy - Websites in WordPress
How to design you professional WordPress website!
Sequence & Series|High School|NCERT : Become an Expert
Learn everything there is to know about Arithmetic Progression, Geometric Progression and some more special series.
Introduction to Database Development
See the databases from developer's point of view. They are just look complicated, it is fun to play with them.
About the instructors
- 4.64 Calificación
- 33629 Estudiantes
- 3 Cursos
Danny Blaker
Software Developer
Danny is a passionate web developer and growth engineer based in Melbourne, Australia. His language of choice is Python, but he also works in a number of other languages including R and Ruby, Web frameworks such as Django, Ruby on Rails, and ofcourse front-end languages including HTML, CSS, JS. Danny is also an avid spreadsheet and google scripts user, his Udemy courses have amassed over 30,000 students to date.
Student feedback
Course Rating
Reviews
it was very engaging, interactive and easy to learn
informative and easy to understand
I love this, easy to follow, thank you. Keep up the good work.
So easy to learn. Very impress.