[Free] Amazing Automations 1 - Email Signups
Automatically track email signups with Googlesheets, Google Scripts, Zapier, & Mailchimp – Free Course
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
Requirements
- Some prior spreadsheet experience is recommended but not neccessary
- If you have never used spreadsheets before, I invite you to take my spreadsheet introduction course: Spreadsheets for Business Part 1.
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
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!
Author(s): Danny Blaker
