15 Prompts for Automating Workflows with Make, n8n, and Zapier

Introduction

Automation isn't just about connecting apps — it's about designing intelligent, self-running processes that save hours every week. Whether you're using Make (formerly Integromat), n8n (open-source workflow automation), or Zapier, the secret to efficient automation lies in how you prompt and structure your logic. This collection of 15 battle-tested prompts will help you automate data parsing, notifications, CRM updates, and more. Each prompt is designed to be copied directly into your favorite automation tool and adapted to your stack.

1. Parse Incoming Email Data into Google Sheets

• Tool: Make, n8n
• Prompt: "Watch Gmail inbox for emails with label 'Invoice'. Extract sender name, invoice number, total amount, and due date. Append to Google Sheets row."
• Example: A freelance designer receives 20 invoices monthly. This automation saves 40 minutes of manual data entry.
• Code (Make): Use Gmail > Watch Emails, then Text Parser (regex for invoice pattern), then Google Sheets > Add Row.

2. Slack Notification for High-Value Sales

• Tool: Zapier, n8n
• Prompt: "Monitor Stripe for successful payments over $500. Send a Slack message to #sales channel with customer name, amount, and product."
• Example: A SaaS company alerts the sales team instantly when an enterprise deal closes.
• Code (n8n): Stripe node > Filter (amount > 500) > Slack node.

3. Auto-Reply to Support Tickets with AI

• Tool: Make, n8n, Zapier
• Prompt: "When a new ticket arrives in Zendesk, analyze sentiment with OpenAI. If negative, escalate to manager via email. If positive, send a thank-you reply."
• Example: Reduces first-response time by 60% for a support team handling 200 tickets daily.
• Code (n8n): Zendesk trigger > HTTP Request (OpenAI sentiment) > IF node > Email / Slack.

4. Sync Calendly Events to Notion Database

• Tool: Zapier, Make
• Prompt: "When a new Calendly event is booked, create a Notion database entry with date, time, guest name, and meeting purpose."
• Example: A consultant keeps all client meetings in a searchable Notion hub.
• Code (Zapier): Calendly > New Event > Notion > Create Database Item.

5. Daily Email Digest of Analytics

• Tool: Make, n8n
• Prompt: "Every morning at 8 AM, fetch Google Analytics data for yesterday: total users, top page, bounce rate. Send a formatted email digest."
• Example: A marketing manager gets a quick daily snapshot without opening dashboards.
• Code (Make): Schedule > GA4 connector > HTML Email builder > Send via Gmail.

6. Auto-Generate Invoices from Shopify Orders

• Tool: n8n, Zapier
• Prompt: "When a new Shopify order is paid, generate a PDF invoice using a template, save to Google Drive, and email to customer."
• Example: An e-commerce store with 100 orders/day eliminates manual invoicing.
• Code (n8n): Shopify trigger > PDF generation (n8n PDF node) > Google Drive > Email.

7. Lead Enrichment from LinkedIn

• Tool: Make, n8n
• Prompt: "When a new lead is added to HubSpot, enrich with LinkedIn profile data (job title, company size) using Proxycurl API."
• Example: A B2B sales team improves lead qualification accuracy by 30%.
• Code (Make): HubSpot trigger > HTTP (Proxycurl) > Update HubSpot contact.

8. Automated Social Media Cross-Posting

• Tool: Zapier, Make
• Prompt: "When a new blog post is published in WordPress, share it automatically to Twitter, LinkedIn, and Facebook with custom captions."
• Example: A content creator saves 1 hour per post across 3 platforms.
• Code (Zapier): WordPress trigger > Twitter + LinkedIn + Facebook actions.

9. Invoice Payment Reminder Sequence

• Tool: Make, n8n
• Prompt: "Check Xero for unpaid invoices older than 7 days. Send a reminder email. If still unpaid after 14 days, escalate to manager via Slack."
• Example: A freelancer reduces late payments by 40% with gentle automated reminders.
• Code (n8n): Xero node > Filter (date diff) > Email > Delay > Slack.

10. GitHub Issue to Jira Task Sync

• Tool: n8n, Zapier
• Prompt: "When a new GitHub issue is labeled 'bug', create a Jira task with priority High, assign to dev team, and link back to GitHub."
• Example: A dev team maintains traceability across two tools without manual copying.
• Code (n8n): GitHub webhook > IF (label) > Jira node.

11. SMS Alert for Server Downtime

• Tool: Make, n8n
• Prompt: "Monitor a web endpoint every 5 minutes. If HTTP status is not 200, send SMS via Twilio to on-call engineer."
• Example: An IT team gets immediate alerts, reducing downtime response from 15 minutes to 2.
• Code (Make): Webhook > HTTP request > IF (status ≠ 200) > Twilio SMS.

12. Web Scraping Price Changes to Email

• Tool: n8n, Make
• Prompt: "Scrape a competitor's product page daily. If price drops below $50, send email alert with the URL."
• Example: An e-commerce manager adjusts pricing dynamically based on competition.
• Code (n8n): Schedule > HTTP node (scrape) > HTML extract > Filter > Email.

13. Auto-Archive Old Trello Cards

• Tool: Zapier, Make
• Prompt: "Every week, find Trello cards in 'Done' list that are older than 30 days, archive them, and add a note to a summary card."
• Example: A project manager keeps boards clean without manual cleanup.
• Code (Zapier): Schedule > Trello search > Archive action.

14. Form Submission to CRM and Slack

• Tool: Zapier, Make
• Prompt: "When a Typeform submission comes in, create a deal in Pipedrive, send a Slack notification to sales, and add a row to Google Sheets."
• Example: A startup captures leads from a landing page and notifies sales in real-time.
• Code (Zapier): Typeform trigger > Pipedrive + Slack + Sheets.

15. Automated Backup of Database to Cloud Storage

• Tool: n8n, Make
• Prompt: "Every night at 2 AM, export MySQL database as SQL file, compress, upload to AWS S3, and send success notification to admin."
• Example: A small business ensures daily backups without manual scripting.
• Code (n8n): Schedule > MySQL node > Compress > S3 node > Email.

Conclusion

These 15 prompts cover the most common automation scenarios — from data synchronization and notifications to CRM enrichment and backups. The key to successful automation is iterative refinement: start with a simple trigger-action pair, then add conditions, error handling, and enrichment. Whether you prefer Make's visual builder, n8n's flexibility, or Zapier's ease of use, these prompts give you a solid foundation. Start with one prompt today, customize it to your workflow, and watch your productivity soar.