Queue Shopify orders for WhatsApp order review (Part 1 of 2)
.webp)
About template
Automatically queue fulfilled Shopify orders for WhatsApp review requests.
This template watches for Shopify orders that have been fulfilled (shipped) and adds them to a Google Sheet queue for delayed review requests. Use Part 2 to process the queue and send messages.
How it works:
- Triggers when a Shopify order is updated
- Filters for fulfilled orders with valid phone numbers
- Adds order to Google Sheets queue with a calculated send date
Setup required:
- Shopify store connection
- Google Sheets spreadsheet with columns: Order ID, Customer Name, Phone, Order Total, Send Date, Processed
- Configure delay days (default: 3 days after fulfillment)
Important: Install Part 2 template to process the queue and send WhatsApp messages daily.
Questions? [email protected]
Similar templates
Find inspiration by the type of content that fits your goals.
Generate ChatGPT Completions from Google Sheets Rows
Effortlessly enhance your content creation process by integrating ChatGPT with Google Sheets. This powerful template allows you to automatically generate relevant completions, ranging from SEO keywords to custom responses, boosting productivity and content quality with ease. Learn more
Add webhook data to a Google Sheet
Use this automation to instantly capture data from a webhook and automatically add it as a new row in a Google Sheet. This is ideal for real-time data logging, form submissions, or any event-driven updates that must be stored in a spreadsheet. Learn more about webhooks!
Send a Gmail email from a new Google Sheets row
Effortlessly send Gmail messages when a new row is added to your Google Sheets. Just ensure your spreadsheet includes these columns: Email Address Subject Content