Case Study – Cookie Doodle Doo

Cookie Doodle Doo

Case Study – Cookie Doodle Doo

The Client -
Cookie Doodle Doo.

This is a case study of Cookie Doodle Doo who make personalised cookies.

Challenges
What were they?

This case study highlights the fact automation can be used on the smallest repetitive tasks.  Regardless of whether you automate a whole process or a single task you can and will see substantial cost and time savings.

Manual Process

Hand-writing labels for delivery boxes.

Goals
What were the goals?

Hand writing labels was not the best use of Mel’s time.  It was a boring job that was essential but it was taking at least 1 minute per label.  For 800 orders received Mel would spend on average 2 days writing labels.

 

We were tasked with automating the process by creating a mail merge based on orders received in Shopify.

I highly recommend Yvonne to any business who has tasks that are necessary but where Yvonne’s help leaves you to concentrate on the things you do best!

Mel Drewery – Cookie Doodle Doo

0
days
per 800 orders

The Solution
How did we help?

The solution was to connect Shopify, Google Sheets and Avery mail merge together using Zapier.

1. Zapier was used to pull the address details from Shopify into a Google Spreadsheet
2. Avery mail merge add on was added to Google
3. A mail merge was used to create the printed labels which included Mel’s logo and the order number so this could be tied back to the initial order to ensure the correct cookies was in the right box.

 

The Post Office prefers printed labels too as they are easier to process.  So a win-win all round!

Tools Used

Need help streamlining your workflows?

Here’s how we can help you …

 

1. Join our Facebook group NocodeVA where we share in-depth content and trainings on automation and the latest no-code tools

2. Purchase our eBook Automation Made Simple which has 25 done for you automated Zapier templates ready to implement into your business for just £25

3. Book a Power Hour where we will hang out on Zoom, share screens, focus on your automation plan, problem solve any tech issues you have, map your workflows out or just brush up on your automation skills. The choice of what you spend the hour on is yours

4. Sign up for interactive Zapier automation training (beginner – intermediate or intermediate – advanced) This training will not only help you save time in your own business but for your clients business too.

5. Work with us on a 1:1 basis to create bespoke automations specific to your business email us at info@amsuk.co

Share this post