Quick overview This template automates Shopify abandoned cart recovery with a 3-email Gmail sequence, tracks recoveries in Google Sheets via Shopify “order paid” webhooks, and sends a weekly HTML performance report every Monday using data aggregated from the same spreadsheet. How it works Receives a Shopify “checkout created” webhook, verifies the checkout includes an email address, and skips customers who already have an active recovery sequence logged in Google Sheets. Logs the abandoned checkout details to Google Sheets and waits one hour before checking Shopify Orders for a paid purchase by the same email. If no paid order exists, sends the first recovery email via Gmail and updates the Google Sheets row to mark Email 1 as sent. After another 23 hours, checks Shopify Orders again and, if still unpaid, sends the second recovery email via Gmail and updates Google Sheets. After another 48 hours, checks Shopify Orders again and, if still unpaid, creates a unique one-time Shopify discount (price rule + discount code) and sends the third email via Gmail, then stores the discount code and Email 3 status in Google Sheets.
Tags
Gmail
Google SheetsWHTTP RequestRelated workflows
See all Gmail→WRoute law firm client intakes with Claude and Google Sheets
Quick Overview This workflow hosts an n8n intake form for a law firm, sends each submission to Anthropic Claude for classification and qualification, logs the result to Google Sheets, emails the intake team for qualified matters via Gmail, and returns a neutral confirmation page to the submitter. How it works Receives a client intake submission through an n8n hosted form. Normalizes the submission into consistent fields (contact details, matter type, incident date, and narrative). Sends the normalized intake to Anthropic Claude to classify practice area, assess urgency and time sensitivity, flag conflict-check needs, and decide whether the matter is qualified. Parses Claude’s JSON response and merges the analysis back into the intake record. If the matter is qualified, sends an HTML alert email via Gmail to the intake team and appends the intake details to the “Qualified Intakes” tab in Google Sheets. If the matter is not qualified, appends the submission and decline reason to the “Declined Intakes” tab in Google Sheets. Returns a confirmation message to the submitter stating the intake was received and that no attorney-client relationship has been formed. Setup Create an Anthropic
WMove data between JSON and spreadsheets
This workflow illustrates how to convert data from JSON to binary format and import JSON data or files into Google Sheets or local spreadsheets.
W
Automate Paid Zoom Meetings with Stripe, Gmail & Google Sheets Tracking
Streamline Your Zoom Meetings with Secure, Automated Stripe Payments This comprehensive workflow automates the entire process of setting up a paid online event, from scheduling a Zoom meeting and creating a Stripe payment link to tracking participants and sending confirmation emails. How it Works This workflow has two primary, distinct branches: Event Creation and Participant Registration. Event Creation Flow (Triggered via Form): An administrator submits details (title, price, date/time) via a form. The workflow creates a new Zoom meeting with a unique password. It creates a Stripe Product and a Payment Link. A dedicated Google Sheet tab is created for tracking participants. An email is sent to the event organizer with all the details, including the Zoom link, payment link, and participant list URL. Participant Registration Flow (Triggered via Stripe Webhook): A webhook is triggered when a Stripe payment is completed (checkout.session.completed). The participant's details are added to the dedicated Google Sheet tab. A confirmation email is sent to the participant with the Zoom link and password. A notification email is sent to the event organizer about the new registration. Use Ca