Turn each WordPress form submission into a ready to send Gmail draft and a clean row in Google Sheets. Messages are auto sorted into product questions, order questions, or other topics, so the right team sees the right draft fast. Ideal for teams that get many daily inquiries and want faster responses with better records.

Here is how it works. A webhook receives the Contact Form 7 POST from your site. The workflow maps form fields, then uses a Google Gemini model to classify the message. Based on the category, an AI email writer creates a clear subject and body. Gmail nodes save the draft in the team inbox, while Google Sheets nodes store key details on separate tabs for product, order, and other. Subjects and message text are generated as separate fields for easy editing. A fallback path makes sure unclassified messages still get a draft and are logged.

Setup needs the CF7 to Webhook plugin, access to Gmail, Google Sheets, and a Google Gemini API. Expect response prep to drop from minutes to seconds, while every inquiry is saved for tracking. Great for online stores handling order status questions, brands fielding product info requests, and support teams that need a shared log without extra manual entry.

• Webhook trigger captures Contact Form 7 submissions from WordPress using a POST request
• Field mapping normalizes first name, last name, email, phone, subject, and message
• AI message classifier sorts inquiries into Product Info, Order Info, or Other with a fallback
• Three AI email writers generate category specific subjects and reply text
• Gmail nodes create polished drafts instead of sending, so agents can review before send
• Google Sheets logging writes each inquiry to the correct sheet tab by category
• Separate subject and message outputs make edits quick and consistent

• Reduce manual sorting from 10 minutes to under 1 minute per inquiry
• Automate up to 90% of initial reply drafting with AI
• Improve routing accuracy by mapping each category to the right team inbox
• Unify website, email, and spreadsheet records without copy and paste
• Handle 3 to 5 times more inquiries with the same team size

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with WordPress, Gmail, Google Sheets and Google Gemini. See the Tools Required section above for links to create accounts with these services.
3. In WordPress, install the CF7 to Webhook plugin for Contact Form 7. Open your form settings and add a webhook. Set the method to POST and paste the n8n Webhook node URL path shown in the workflow.
4. In n8n, open the Webhook node and confirm the path and HTTP method match what you set in WordPress. Click Listen for Test Event and submit a test form to verify you receive data.
5. Open the Set Fields node and confirm each field maps to your Contact Form 7 field names. Adjust names like first_name, last_name, email, phone, subject, and message to match your form.
6. Double click the Google Gemini language model nodes. In the Credential dropdown, click Create new credential and follow the on screen steps to connect your Google Gemini API. Use a valid API key from the official API page.
7. Open each Gmail node. In the Credential dropdown, click Create new credential, sign in to the correct Google account, and approve requested scopes. Use an inbox that your support team monitors.
8. Open each Google Sheets node. In the Credential dropdown, click Create new credential and connect your Google account. Select a spreadsheet and worksheet for product, order, and other logs.
9. Open the Message Classifier node and review the categories. Edit or add categories to match your business. Map each category to a team email by setting the email field used by the Gmail sendTo option.
10. Check the three Subject and Text parser nodes feeding the email writers. Make sure they output separate subject and body so drafts are structured and easy to edit.
11. Run end to end tests. Submit one product question and one order question. Confirm two Gmail drafts appear in the right inbox and two new rows are added to the correct Google Sheets tabs.
12. Troubleshoot common issues: if the webhook does not fire, recheck the WordPress POST URL. If Gmail or Sheets fail, reconnect credentials and confirm permissions. If messages misclassify, refine category descriptions and test again.