Automatically track email signups with Googlesheets, Google Scripts, Zapier, & Mailchimp
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
In this Amazing Automation - the first of the series,Danny Blaker-Head of Data Analysis and MarketingatoneofAustralia'slargestenterprisetechnologyfirmsIcestormDigitalSolutions(www.icestormds.com) -takesyou through automating the process of tracking your Email signupKPIs (Key Performance Indicators) Step-by-step.
In this one-off and invaluablecourse, you'll learn how to:
- create live,dynamic and scallable spreadsheetsusing advanced techniques and googlesheets functions.
- Write agoogle script that automaticallysends 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 processesand create the very same tools that Danny uses in large firms, as well asstartups.
This is a great opportunity to learn how custommarketing automation works for modern businesses.
Everything you create and learnin this course can beimmediately appliedto your own businesses or projects.
The course is also filled with helpful advice, hints, tips, tricks, to make your google-sheetsworkflow faster and more optimized.
If you're an entrepreneur - fromrunningstartupsto mammoth,scaling corporations-this is a must do course for you, by an expert in the field!