Automate Shopify Cart Recovery & Reports with Gmail & Sheets

Effortlessly Recover Shopify Carts and Optimize Weekly Reports with Gmail & Google Sheets Automation

Transform your e-commerce operations by automating Shopify cart recovery and weekly performance reports using Gmail and Google Sheets. This n8n workflow ensures no abandoned cart goes unnoticed, leveraging a strategic 3-email sequence to rekindle customer interest, while meticulously tracking recovery and revenue statistics in Google Sheets. Unlock valuable insights with automated weekly reports sent directly to your inbox every Monday.

What this workflow does

• Receives a "checkout created" webhook from Shopify, ensuring each checkout includes an email and cross-referencing Google Sheets to avoid duplicate recovery efforts.
• Logs abandoned checkout information in Google Sheets and waits one hour, checking Shopify Orders for any purchases made with the same email.
• If no purchase is detected, dispatches the first recovery email via Gmail and marks it as sent in Google Sheets.
• After another 23 hours, it rechecks Shopify Orders and, if still unpaid, sends the second recovery email, updating Google Sheets accordingly.
• 48 hours later, if the cart remains unpaid, it constructs a unique Shopify discount and sends a final email offering the discount, recording the discount code and email status in Google Sheets.
• Whenever an "order paid" webhook is received, it updates the Google Sheets log, marking the cart as recovered with valuable data such as revenue and the triggering email.
• Compiles all recovery and revenue data from the past week into a comprehensive HTML report and sends it every Monday morning at 9:00 AM.

Use cases

• Enhance your e-commerce strategy by tackling abandoned carts seamlessly, converting potential lost sales into successful transactions.
• Optimize your marketing efforts with data-driven insights, courtesy of automated performance reports that highlight weekly recovery trends.
• Maintain a well-organized record of customer interactions to refine targeted marketing approaches and improve customer retention.

Technical details

• Platforms/Tools: Shopify, Gmail, Google Sheets
• n8n's tech stack: if, code, wait, webhook, sticky note